 # 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!