excelrocksmysocks
New Member
- Joined
- Dec 13, 2016
- Messages
- 1
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)))))
=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)))))