Nested IF functions error message

[excelrocksmysocks]

My nested if function returns the error message "too many arguments" even though there are only 4. If someone can help edit my function that'd be great.

This is my final formula
=IF((AND(B$1<=150,$A2<=100)),(16.88*$A2+20.99*B$1)-(8.7*$A2+11.51*B$1),IF((AND(B$1>=150,$A2>=100)),(16.88*$A2+20.99*B$1)-(8.7*$A2+11.51*B$1)),IF((AND(B$1>150,$A2<100)),((16.88*$A2+20.99*350+(MIN(B$1-150,100-$A2))*0.42*20.99)-(8.7*$A2+11.51*B$1)),IF((AND(B$1<150,$A2>100)),((16.88*100+20.99*B$1+(MIN($A2-100,150-B$1))*0.75*16.88)-(8.7*$A2+11.51*B$1)))))​

 

[Anand Sharma]

Hi

Try using below formula and change the result multiplication and adding values as I changed structure of formula only

=IF(AND(B$1<=150,$A2<=100), ((16.88*$A2)+(20.99*B$1)) - ((8.7*$A2)+(11.51*B$1)),
IF(AND(B$1>=150,$A2>=100), ((16.88*$A2)+(20.99*B$1)) - ((8.7*$A2)+(11.51*B$1)),
IF(AND(B$1>150,$A2<100), ((16.88*$A2)+(20.99*B$1)) - ((8.7*$A2)+(11.51*B$1)),
IF(AND(B$1<150,$A2>100), ((16.88*$A2)+(20.99*B$1)) - ((8.7*$A2)+(11.51*B$1)), ""))))

 

[LateralThinker]

Try this
=IF(AND(B$1<=150,$A2<=100),(16.88*$A2+20.99*B$1)-(8.7*$A2+11.51*B$1),
IF(AND(B$1>=150,$A2>=100),(16.88*$A2+20.99*B$1)-(8.7*$A2+11.51*B$1),
IF(AND(B$1>150,$A2<100),((16.88*$A2+20.99*350+(MIN(B$1-150,100-$A2))*0.42*20.99)-(8.7*$A2+11.51*B$1)),
IF(AND(B$1<150,$A2>100),((16.88*100+20.99*B$1+(MIN($A2-100,150-B$1))*0.75*16.88)-(8.7*$A2+11.51*B$1))))))