Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

need help with a formule

I am working with excel (one of the first time I use excel :D) but
have a problem.

I have this formula:
=SOM(Q8*Instellingen!B16*Instellingen!Q3)

But when you leave the field blank in Q8, you see in the field wher
this formula is a -

How do I change the formula to see nothing in that field???

(i hope you guys understand it a little bit

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
On the celd show a formule not its value, why??	adis	Excel Discussion (Misc queries)	4	February 9th 07 09:41 PM
time formule	arslan	Excel Discussion (Misc queries)	0	April 15th 06 12:21 PM
formule	Natiq Hason	Excel Programming	1	May 15th 04 09:33 PM
Itratie formule	Natiq Hason	Excel Programming	1	May 14th 04 09:48 PM
HOW to show in A2 the formule used in A1 ?	Thierry Fracheboud	Excel Programming	1	October 13th 03 12:00 AM

All times are GMT +1. The time now is 03:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us