ExcelBanter - How My If Or Statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How My If Or Statements (https://www.excelbanter.com/excel-worksheet-functions/84938-how-my-if-statements.html)

John

How My If Or Statements

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?

William Horton

How My If Or Statements

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

"John" wrote:

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?

All times are GMT +1. The time now is 01:38 AM.