| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving nested IF statements
I have too many nested if Statements! i need help figuring out how to reduce
them: my problem: to ensure the validity of a calculated formula, i am checking to see if a cell is blank or = 0 before imputting the formula, and then the formula has a lot of nested ifs as it is. so, something like: if(A6=0, "A6", if(B6=0, "B6", if(C6=0,"C6",FORMULA))) but much larger. anyone help? - make it simplier, more efficient? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Iterations & Automatically Solving If Statements | Excel Discussion (Misc queries) | |||
| NESTED IF STATEMENTS | New Users to Excel | |||
| Nested if statements | Excel Worksheet Functions | |||
| Nested IF Statements | Excel Discussion (Misc queries) | |||
| Nested If Statements | Excel Worksheet Functions | |||
Threaded Mode
