Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok, I have this formula with 3 nested if statements, referencing another part
of the worksheet so I can toggle between -1 and 85, let's say. No need to reprint the exact formula, it's a generic nested if formula. If the value returned by the formula is above 80 or below 0, or returns an error, it leaves the cell blank. It's an ugly nested if formula. Wondering if there is a better way? Thanks... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum in first blank cell and a few more things... | Excel Discussion (Misc queries) | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |