Forum Discussion
Solved
Why can't I nest more than 8 IF Functions?
Hi, According to the Excel Help tutorial, you can nest up to 64 IF functions. But I am only permitted to nest 8. Excel returns this error message as soon as I press enter: The specified formula c...
- You have probably saved the file as an Excel 2003 file type, which will limit this feature to what Excel 2003 was capable of. But you shouldn't be using that many nested ifs. Create a small table which has the limits like so:
10 60
11 75
21 90
31 105
41 120
(truncated, you get the idea)
Suppose this table is on Sheet2!$A$1:$B$19 then use this formula:
=VLOOKUP(G22,Sheet2!$A$1:$B$19,2,TRUE)
You have probably saved the file as an Excel 2003 file type, which will limit this feature to what Excel 2003 was capable of. But you shouldn't be using that many nested ifs. Create a small table which has the limits like so:
10 60
11 75
21 90
31 105
41 120
(truncated, you get the idea)
Suppose this table is on Sheet2!$A$1:$B$19 then use this formula:
=VLOOKUP(G22,Sheet2!$A$1:$B$19,2,TRUE)
10 60
11 75
21 90
31 105
41 120
(truncated, you get the idea)
Suppose this table is on Sheet2!$A$1:$B$19 then use this formula:
=VLOOKUP(G22,Sheet2!$A$1:$B$19,2,TRUE)
Thank you so much. I was not familiar with the VLOOKUP function but it works. Thanks!
- You're welcome!
You can makr my answer as "Best response" if you ike it.
