Excel formula gives error - 'You entered too many arguments' - IF function

Solution 1:

The IF function only accepts a maximum of 3 arguments. The error occurred because you closed the bracket after this IF(P10>10<26,10*100+P10-10*50). Thus having 4 arguments. The bracket must be removed. Then, you must insert it at the end of your formula.

You also have another problem with your formula: P10>10<26. If you are trying to compare when P10 is greater than 10 and less than 26, you should use AND(P10>10,P10<26).