Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working out VAT owed | Excel Worksheet Functions | |||
debt owed/ how to calculate payments with in time frame? | Excel Worksheet Functions | |||
tracking money owed and paid | Excel Discussion (Misc queries) | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
Time Sheet to show hours owed | Excel Worksheet Functions |