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:


    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.