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"))
Excel says: You've entered too many arguments for this function:



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 F15F18 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.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!