 # Excel says: You've entered too many arguments for this function:

• Excel says: You've entered too many arguments for this function:
=IF(F20="","",IF(AND((F15)>=\$D\$15,(F16)>=\$D\$16,(F17)>=\$D\$17,(F18)>\$D\$18),(F19)>\$D\$19),RANK(F20,\$E\$20:\$AE\$20),"FAIL"))

• Re: Excel says: You've entered too many arguments for this function:

=IF(F20="","",IF(AND((F15)>=\$D\$15,(F16)>=\$D\$16,(F17)>=\$D\$17,(F18)>\$D\$18),(F19)>\$D\$19)),RANK(F20,\$E\$20:\$AE\$20),"FAIL"))

I think your parentheses are just in the wrong place • Re: Excel says: You've entered too many arguments for this function:

Quote from S O;781324

=IF(F20="","",IF(AND((F15)>=\$D\$15,(F16)>=\$D\$16,(F17)>=\$D\$17,(F18)>\$D\$18),(F19)>\$D\$19)),RANK(F20,\$E\$20:\$AE\$20),"FAIL"))

I think your parentheses are just in the wrong place That is giving me and error now with problem with this formula, any other ideas

• Re: Excel says: You've entered too many arguments for this function:

I have done as suggested by inputting the parenthesis brackets but now i am getting an error about the formula, it works the way it is when looking at the four cells IE F15-F18 but when I add the (F19)>\$D\$19) part it comes up with the too many argument error. Any other ideas out there as to what I'm doing incorrect • Re: Excel says: You've entered too many arguments for this function:

Try this:

=IF(F20="","",IF(and(F15=\$D\$15,F16=\$D\$16,F17=\$D\$17,F18=\$D\$18,F19=\$D\$19),RANK(F20,\$E\$20:\$AE\$20),"FAIL"))

Nesting formulas can get messy if not careful about the parentheses.

I generally set them up as blank arguments then fill in

=IF(,,IF(AND(,,,,,),RANK(,),"FAIL"))

Obviously, each comma separates the arguments. If you set up the nesting structure first before filling in arguments it is generally easier, IMO, to prevent mistakes with the parentheses.

TIP: learn to make use of the Evaluate Formula Tool to step through formulas - you will learn how Excel evaluates the arguments and see where mistakes occur.
The tool is located on the Ribbon - Formulas > Evaluate Formula. Just select any formula cell before invoking the tool.

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!