Thread: Hiding the value of a formula if 1 cell has a value of zero.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
duugg
 
Posts: n/a
Default Hiding the value of a formula if 1 cell has a value of zero.

If I'm using this formula...

=IF(F24="","",F22+F24)

In cell F26


and this formula

=IF(F20="","",F18+F20)

is in cell F22

and

1

is in cell F24

I got a #value! error

Why is this the case when there is indeed a number 1 in cell
F24?


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=531995

Reply With QuoteReply With Quote