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