what is the max no. of nested Ifs can an If Statements have in EXC

  • Thread starter Thread starter Guest
  • Start date Start date
Hi StevenE

The alleged limitation is 7. It is easy to overcome though.

Try and use lookup, iso IF. You can also split your argument into more than
one column, of which each can have 7 levels, but this is the long route, and
dates back to before Office, when Lotus 123 was the in thing

You can also use arrays
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nest vs Hive? 10
solving nested IF statements 13
Need more than 7 nested "IF" statements in Excel" 1
Nested IF Help 3
Nested IF Statement Question 6
Formula nesting with IF statements 2
Nested If 3
IF statement syntax 4

Back
Top