Hi All,
Gooddays
Im new here and i need your valuable guidance
I have a sets of list here:
Cash Back % Cash Back Max Amount
5% 280
8% 480
10% 680
A B C D
1 cashback% Max Cashback Purchased Amount Cashback Amount
2 5% 280 6000 280 =IF(A2=5%,MIN(280,(SUM(C2*A2))))
3 8% 480 6500 480 =IF(A3=8%,MIN(480,(SUM(C3*A3))))
4 10% 680 7000 680 =IF(A4=10%,MIN(680,(SUM(C4*A4))))
I got each of the single formula, but im not able to mix all 3 condition together which i wish under one formula for all 3 conditions
Thank for the helps in advance
Bookmarks