#### excelrocksmysocks

##### New Member

- Joined
- Dec 13, 2016

- Messages
- 1

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)))))