How to work out 3 different %

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I am stuck here trying to slove how I would work out 3 different discounts

one is the order is over 250 the discount is 15%
two is the order is over 200 the discount is 10%
three is the order is over 150 the discount is 5%

I was wonder if anyone could please help me come up with a formula
 
Sam,

With your order amount in A1, this returns the discount %

=LOOKUP(A1,{0,151,201,251},{0,0.05,0.1,0.15})

Mike
 
Back
Top