Why do you get the “You’ve entered too many arguments…” error
A Sales commission calculation using an IF function is shown in the data set below.
To calculate the commission amounts, use the formula below 👇
In the above example, you have to input data correctly to function.
You can do some changes to the above function to understand the reasons for this error.
The error “You’ve entered too many arguments for this function” can happen due to the following reasons:
- You have not closed all the parentheses properly.
For example, if you miss closing the parentheses of the inside IF function, you will encounter this error.
You can enter the same formula without closing the end parentheses of the inner function.
You can write the below formula and test it.
- You have placed a comma in an incorrect place.
For example, if you mistakenly entered a comma before you close the last parenthesis of the function, Excel will not get you the answer.
- The number of arguments entered does not match the syntax of the function.
The IF function, for example, accepts three arguments.
You would run into the same error if you tried to give this function more than three arguments.
Assume you’ve made a mistake.
You added a fourth value argument to the end function after the third one.
To test this, enter the Excel formula below.