How My If Or Statements

  • Thread starter Thread starter John
  • Start date Start date
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?
 
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
 
Back
Top