Hi

We have a SAAS product that up to 1000 users will be £99 per month, this means if they have 100 users, 500 users or 1000 users the price is still £99 per month.

But once they go over 1000 users then the price goes up, so for example 1100 users would be £109 per month i.e. 10% more...

What I need is the cell formula or formatting that will show this figure based on the input cell of users ?

Can anyone help and thanks so much

Mike