#value!

[Desert Piranha]

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?

 

[Peo Sjoblom]

Not pretty but SUM ignores text (your "" is text)

=IF(startingcash1="","",SUM(startingcash1,B39)-SUM(C39))


--
Regards,

Peo Sjoblom

Portland, Oregon




"Desert Piranha"

 

[Desert Piranha]

Hi Peo,
Pretty cool arrangement of the formula, works fine.
I learned something about formulas.
Thanks very much Peo.
Dave

Not pretty but SUM ignores text (your "" is text)

=IF(startingcash1="","",SUM(startingcash1,B39)-SUM(C39))


--
Regards,

Peo Sjoblom

Portland, Oregon




"Desert Piranha"
message

 

[Peo Sjoblom]

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon




"Desert Piranha"