software

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=quot;quot;,quot;quot;,(startingcash1 B39-C39))

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

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

Of course i could use B39 and C39 with a 0 instead of quot;quot;
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: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=503572Not pretty but SUM ignores text (your quot;quot; is text)

=IF(startingcash1=quot;quot;,quot;quot;,SUM(startingcash1,B39)-SUM(C39))--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Desert Piranhaquot;
lt;Desert.Piranha.21ytoa_1137814500.8068@excelforu m-nospam.comgt; wrote in
message newsesert.Piranha.21ytoa_1137814500.8068@excelfo rum-nospam.com...
gt;
gt; Hi All,
gt; Search reveals nothing, Help is helpless (for me anyway).
gt; I know this needs an ISERROR or somethig like that but i can't get it
gt; to work.
gt;
gt; It works as long as there are values in B39 and C39.
gt; But sometimes B39 and/or C39 will not have a value,
gt; but there will always be a value in startingcash1
gt; in which case i want whatever does have a value, to display.
gt;
gt; This is the problem formula:
gt; '=IF(startingcash1=quot;quot;,quot;quot;,(startingcash1 B39-C39))
gt;
gt; This is in B39:
gt; '=IF(SUM(receipts1)=0,quot;quot;,(SUM(receipts1)))
gt;
gt; This is in C39:
gt; '=IF(SUM(drops1)=0,quot;quot;,(SUM(drops1)))
gt;
gt; Of course i could use B39 and C39 with a 0 instead of quot;quot;
gt; but then i have a 0 in those cells. Could use Conditional Formating
gt; to get rid of the 0 display. Must be an easier way.
gt; IE:
gt; '=IF(SUM(receipts1)=0,0,(SUM(receipts1)))
gt; '=IF(SUM(drops1)=0,0,(SUM(drops1)))
gt;
gt; Anyone give me a clue?
gt;
gt;
gt; --
gt; Desert Piranha
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Desert Piranha's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28934
gt; View this thread: www.excelforum.com/showthread...hreadid=503572
gt;
Hi Peo,
Pretty cool arrangement of the formula, works fine.
I learned something about formulas.
Thanks very much Peo.
Dave
Peo Sjoblom Wrote:
gt; Not pretty but SUM ignores text (your quot;quot; is text)
gt;
gt; =IF(startingcash1=quot;quot;,quot;quot;,SUM(startingcash1,B39)-SUM(C39))
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Desert Piranhaquot;
gt; lt;Desert.Piranha.21ytoa_1137814500.8068@excelforu m-nospam.comgt; wrote in
gt; message
gt; newsesert.Piranha.21ytoa_1137814500.8068@excelfo rum-nospam.com...
gt; gt;
gt; gt; Hi All,
gt; gt; Search reveals nothing, Help is helpless (for me anyway).
gt; gt; I know this needs an ISERROR or somethig like that but i can't get
gt; it
gt; gt; to work.
gt; gt;
gt; gt; It works as long as there are values in B39 and C39.
gt; gt; But sometimes B39 and/or C39 will not have a value,
gt; gt; but there will always be a value in startingcash1
gt; gt; in which case i want whatever does have a value, to display.
gt; gt;
gt; gt; This is the problem formula:
gt; gt; '=IF(startingcash1=quot;quot;,quot;quot;,(startingcash1 B39-C39))
gt; gt;
gt; gt; This is in B39:
gt; gt; '=IF(SUM(receipts1)=0,quot;quot;,(SUM(receipts1)))
gt; gt;
gt; gt; This is in C39:
gt; gt; '=IF(SUM(drops1)=0,quot;quot;,(SUM(drops1)))
gt; gt;
gt; gt; Of course i could use B39 and C39 with a 0 instead of quot;quot;
gt; gt; but then i have a 0 in those cells. Could use Conditional Formating
gt; gt; to get rid of the 0 display. Must be an easier way.
gt; gt; IE:
gt; gt; '=IF(SUM(receipts1)=0,0,(SUM(receipts1)))
gt; gt; '=IF(SUM(drops1)=0,0,(SUM(drops1)))
gt; gt;
gt; gt; Anyone give me a clue?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Desert Piranha
gt; gt;
gt; gt;
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Desert Piranha's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=28934
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=503572
gt; gt;--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=503572Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Desert Piranhaquot;
lt;Desert.Piranha.21ywom_1137818401.2319@excelforu m-nospam.comgt; wrote in
message newsesert.Piranha.21ywom_1137818401.2319@excelfo rum-nospam.com...
gt;
gt; Hi Peo,
gt; Pretty cool arrangement of the formula, works fine.
gt; I learned something about formulas.
gt; Thanks very much Peo.
gt; Dave
gt; Peo Sjoblom Wrote:
gt;gt; Not pretty but SUM ignores text (your quot;quot; is text)
gt;gt;
gt;gt; =IF(startingcash1=quot;quot;,quot;quot;,SUM(startingcash1,B39)-SUM(C39))
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Desert Piranhaquot;
gt;gt; lt;Desert.Piranha.21ytoa_1137814500.8068@excelforu m-nospam.comgt; wrote in
gt;gt; message
gt;gt; newsesert.Piranha.21ytoa_1137814500.8068@excelfo rum-nospam.com...
gt;gt; gt;
gt;gt; gt; Hi All,
gt;gt; gt; Search reveals nothing, Help is helpless (for me anyway).
gt;gt; gt; I know this needs an ISERROR or somethig like that but i can't get
gt;gt; it
gt;gt; gt; to work.
gt;gt; gt;
gt;gt; gt; It works as long as there are values in B39 and C39.
gt;gt; gt; But sometimes B39 and/or C39 will not have a value,
gt;gt; gt; but there will always be a value in startingcash1
gt;gt; gt; in which case i want whatever does have a value, to display.
gt;gt; gt;
gt;gt; gt; This is the problem formula:
gt;gt; gt; '=IF(startingcash1=quot;quot;,quot;quot;,(startingcash1 B39-C39))
gt;gt; gt;
gt;gt; gt; This is in B39:
gt;gt; gt; '=IF(SUM(receipts1)=0,quot;quot;,(SUM(receipts1)))
gt;gt; gt;
gt;gt; gt; This is in C39:
gt;gt; gt; '=IF(SUM(drops1)=0,quot;quot;,(SUM(drops1)))
gt;gt; gt;
gt;gt; gt; Of course i could use B39 and C39 with a 0 instead of quot;quot;
gt;gt; gt; but then i have a 0 in those cells. Could use Conditional Formating
gt;gt; gt; to get rid of the 0 display. Must be an easier way.
gt;gt; gt; IE:
gt;gt; gt; '=IF(SUM(receipts1)=0,0,(SUM(receipts1)))
gt;gt; gt; '=IF(SUM(drops1)=0,0,(SUM(drops1)))
gt;gt; gt;
gt;gt; gt; Anyone give me a clue?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Desert Piranha
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt; Desert Piranha's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=28934
gt;gt; gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=503572
gt;gt; gt;
gt;
gt;
gt; --
gt; Desert Piranha
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Desert Piranha's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28934
gt; View this thread: www.excelforum.com/showthread...hreadid=503572
gt;