Υπολογισμός προμήθειας για αντιπρόσωπο John Smith

Κανόνες

1) If Sales >= 20000, then 4% commission

2) If Sales >= 5000 and < 20000, then 5% commission

3) If Sales >= 1 and < 5000, then 6% commission

D3 cell function

=IF(C3>=$G$3;$H$3;IF(C3>=$G$4;$H$4;$H$5))*C3

D4 cell function

=IF(C4>=$G$3;$H$3;IF(C4>=$G$4;$H$4;$H$5))*C4

D5 cell function

=IF(C5>=$G$3;$H$3;IF(C5>=$G$4;$H$4;$H$5))*C5

D6 cell function

=IF(C6>=$G$3;$H$3;IF(C6>=$G$4;$H$4;$H$5))*C6