View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 5
Default 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