TO many arguments

    Does anyone see a problem with this formula? I simply don't see why i'm getting a to many arguments rule hard stop. It says the to many arguments is in the last value if false spot at the end of the formula. I'm sure I am missing something very easy and retarded, but I simply can't figure it out.


    =IF(D4="","",IF(AND(Data!BO4="TRUE",Data!H4=7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4+'Base Price Charges - Credits'!R4-'Base Price Charges - Credits'!$U$2),IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3,0))


    It's bold and underlined where the to many arguments is coming into play

    Re: TO many arguments


    If you Break it down by If formula you have


    IF(D4="",""


    IF(AND(Data!BO4="TRUE",Data!H4=7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4+'Base Price Charges - Credits'!R4-'Base Price Charges - Credits'!$U$2)


    IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3


    The red shows the if TRUE, the blue shows the if FALSE. The 0 doesn't come into play as the formula is complete after the last if FALSE result.

    Re: TO many arguments


    You are looking at it wrong


    First Formula:
    IF(D4="",""


    Says if D4 is blank, then blank else move to the next nested formula - The way you have it saying is there is no argument, if D4 = true else false

    Re: TO many arguments


    You're right sorry, try this at the end, you don't sem to have closed the last if statement.

    IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3    ),0)


    Re: TO many arguments


    You have to delete the ) from here


    =IF(D4="","",IF(AND(Data!BO4="TRUE",Data!H4=7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4+'Base Price Charges - Credits'!R4-'Base Price Charges - Credits'!$U$2),IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3,0))


    So it look like this
    =IF(D4="","",IF(AND(Data!BO4="TRUE",Data!H4=7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4+'Base Price Charges - Credits'!R4-'Base Price Charges - Credits'!$U$2,IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3,0)))

    Re: TO many arguments


    Same error, I ended up just splitting it into a helper cell and adding them together :/ not ideal but it works

    Re: TO many arguments


    Actually, the 2nd one you posted works -- it's not calculating right but I can figure out where that is off. Thanks Rooster!

Participate now!

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

Register Yourself Login