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