If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
No Balance Owed Flag Help!
"Danny Boy" wrote:
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". 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 ----- "Danny Boy" wrote: 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 |
#3
|
|||
|
|||
No Balance Owed Flag Help!
Thanks for the help and the information Joe!
Best, Dan "Joe User" wrote: "Danny Boy" wrote: 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". 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 ----- "Danny Boy" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|