Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW MANY IF STATEMENTS CAN YOU HAVE IN ONE FORMULA?
I have nine conditions I want the IF statement to recognize, but when I enter
the formula I get an error after the 8th condition. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW MANY IF STATEMENTS CAN YOU HAVE IN ONE FORMULA?
You can only use 7 nested IF. There are other options, like CHOOSE, VLOOKUP
or MATCH/INDEX that may fit in your particular case, check the help for those functions as that may give you ideas. Hope this helps, Miguel. "bvehslage" wrote: I have nine conditions I want the IF statement to recognize, but when I enter the formula I get an error after the 8th condition. Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW MANY IF STATEMENTS CAN YOU HAVE IN ONE FORMULA?
You can actually have quite a few. While you can only have 7 nested if
statements, you can format you equation to unnest the ifs in most occurances for example =if(a12,5,if(a10,3,1) has two levels of ifs while =if(a12,5,0)+if(and(A10,A1<=2),3,0) and if(A1<=0,1,0) will give the same answer with one level of if staements. There are multiple other equations which will give the same answer, but will not be hit by the 7 nested limit. "bvehslage" wrote: I have nine conditions I want the IF statement to recognize, but when I enter the formula I get an error after the 8th condition. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assign formula to another cell | Excel Worksheet Functions | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |