Excel

[eva grzelak]

What does it mean when Excel says "you've entered too many criteria" in an IF formula?

[#2]

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...

[#3]

Or you have more than two commas for single IF, like

=IF(A1=1,1,"",3)