How to work out 3 different %
 

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

How to work out 3 different %
 

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

"Sam" wrote:

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