No Balance Owed Flag Help!

  • Thread starter Thread starter Danny Boy
  • Start date Start date
D

Danny Boy

Trying to resolve this formula to work appropritely in cell E7:

=SUM(E2:E6),IF(E2:E6=0,"No Balance Owed")

In other words, all currency outcomes are totaled in cell E7, however, if
all outcomes in cells E2:E6 are $0.00, than I'd like cell E7 to say "No
Balance Owed".

Any help would be appreciated!
Thanks
 
Danny Boy said:
In other words, all currency outcomes are totaled
in cell E7, however, if all outcomes in cells E2:E6
are $0.00, than I'd like cell E7 to say "No
Balance Owed".
Click to expand...

Try:

=if(round(sum(E2:E6),2)=0, "No Balance Owed", sum(E2:E6))

To understand the need for ROUND, at least in the first argument, try the
following experiment: =10.1-10-0.1 formatted as General. It's an anomaly of
computer arithmetic that we all need to be aware of. It would be prudent to
use ROUND even in the third argument.

Alternatively, do:

=round(sum(E2:E6),2)

with the Custom format 0.00;-0.00;"No Balance Owed".


----- original message -----
 
Back
Top