Hi All,
Search reveals nothing, Help is helpless (for me anyway).
I know this needs an ISERROR or somethig like that but i can't get it
to work.

It works as long as there are values in B39 and C39.
But sometimes B39 and/or C39 will not have a value,
but there will always be a value in startingcash1
in which case i want whatever does have a value, to display.

This is the problem formula:
'=IF(startingcash1="","",(startingcash1+B39-C39))

This is in B39:
'=IF(SUM(receipts1)=0,"",(SUM(receipts1)))

This is in C39:
'=IF(SUM(drops1)=0,"",(SUM(drops1)))

Of course i could use B39 and C39 with a 0 instead of ""
but then i have a 0 in those cells. Could use Conditional Formating
to get rid of the 0 display. Must be an easier way.
IE:
'=IF(SUM(receipts1)=0,0,(SUM(receipts1)))
'=IF(SUM(drops1)=0,0,(SUM(drops1)))

Anyone give me a clue?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=503572