Forum Discussion
Excel
What does it mean when Excel says "you've entered too many criteria" in an IF formula?
2 Replies
Or you have more than two commas for single IF, like
=IF(A1=1,1,"",3)
- Excel only allows a limited number of nested IF statements. If you have too many options to check, maybe its better to consider VLOOKUP instead.
See here for more info.
https://support.office.com/en-us/article/if-function-%E2%80%93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8
