View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny boy Danny boy is offline
external usenet poster
 
Posts: 102
Default No Balance Owed Flag Help!

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