How do I set up a formula for greater than but less than in Excel

M

Marcel

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.
 
T

Trevor Shuttleworth

I am sure there's a better way but it's not come to mind yet. Assuming you
have a row for each person and that row has a cell containing the date and
time they signed up, I'd sort the rows by date/time and add a helper column
which you add a counter from 1 to whatever. Then you can have a formula for
the discount:

=IF(counter<50,25%,IF(counter<100,15%,IF(counter<150,10%,0)))

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top