View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcel Marcel is offline
external usenet poster
 
Posts: 6
Default How do I set up a formula for greater than but less than in Excel

I have three scenarios. The first is up to the first 50 people that sign up
get a 25% discount, the next 50 get a 15% discount and the third 50 people
that sign up get a 10% discount. I have set up a time frame by month and a
cumulative row to capture all the people that sign up. As people sign up, I
need to know if I have reached my threshholds so I can apply the right
discount. I have tried the "If" condition but I am not exactly sure how to
apply it on multiple options. Thanks for your help.