Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DAYS360 + 2 If Functions
I have converted the date ranges into the number of days; however, I need to
add 2 what if functions when the cell produces a number < 0 and #VALUE!. When the response is <0, I need it to say "Open" and when the response is #VALUE!, I need it to say "NA". I keep trying different formulas but I keep getting an error message. Help please. -- Dixie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DAYS360 + 2 If Functions
=IF(ISERROR(formula),"NA",IF(formula=0,"Open,formu la))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dixie" wrote in message ... I have converted the date ranges into the number of days; however, I need to add 2 what if functions when the cell produces a number < 0 and #VALUE!. When the response is <0, I need it to say "Open" and when the response is #VALUE!, I need it to say "NA". I keep trying different formulas but I keep getting an error message. Help please. -- Dixie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
days360 | Excel Discussion (Misc queries) | |||
DAYS360 | Excel Worksheet Functions | |||
DAYS360 | Excel Worksheet Functions | |||
=DAYS360 | Excel Discussion (Misc queries) | |||
DAYS360 | Excel Worksheet Functions |