How My If Or Statements

J

John

How many IF OR statements can one have in one formula?

I need 12 and if I can only have a MAx of 7, do I just split over 2 cells?
 
W

William Horton

2 options.

Split over 2 cells
Or
Make a formula with 6 of the If's and define it with a name. Then make a
formula with the other 6 If statementsx and define it with a name. Then in
the cell where you want the answer make a formula with both of your named
formulas in it.

Hope this helps.

Bill Horton
 
Top