Thread: #value
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Biff
 
Posts: n/a
Default #value

is there much chance of getting you to explain why it works as opposed
to what i was using??


Sure, that's how we learn!

If this formula returned the blank (""):

=IF(SUM(D64:I64)=0,"",SUM(D64:I64))

Then this formula was trying to multiply 18.15 * ""

=IF(SUM(M64*L64)=0,"",SUM(M64*L64)*12)

The formula blank ("") is an empty TEXT string. So, 18.15 * TEXT = #VALUE!

This formula:

=IF(ISNUMBER(L64),L64*M64*12,"")

Tests the value in L64 to see if it is a number and if it is then carries
out the multiplication of L64*M64*12.

Biff

"George." wrote in
message ...

wow
thanks so much for that, ur formula worked perfectly!!!
ive been battling with this problem for far too long.

is there much chance of getting you to explain why it works as opposed
to what i was using??

thanks again for your help.


--
George.
------------------------------------------------------------------------
George.'s Profile:
http://www.excelforum.com/member.php...o&userid=35028
View this thread: http://www.excelforum.com/showthread...hreadid=547722