Hi!
Need some help with a formula to calculate a discount.
20% off all items EXCEPT the highest value item. Where 2 items are same value, only 1 gets the discount. Here's my example:
[td]price[/td]
[td]discount[/td]
This seems to work when there's no duplicates: =IF(A2=MAX(A2:A4),0,A2*0.2)
But I can't get this to work when there's 2 items with the same highest value.
Any tips on how I can get this working?
Need some help with a formula to calculate a discount.
20% off all items EXCEPT the highest value item. Where 2 items are same value, only 1 gets the discount. Here's my example:
40 | 8 |
100 | 0 |
100 | 20 |
60 | 12 |
[td]discount[/td]
This seems to work when there's no duplicates: =IF(A2=MAX(A2:A4),0,A2*0.2)
But I can't get this to work when there's 2 items with the same highest value.
Any tips on how I can get this working?