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
Assuming the number of users is in cell A1:
?Formula:
=IF(A1<=1000,A1*99,A1*109)
BSB
Hi,
Not sure whether the price is variable but with the number of users in A1 try
Formula:=MAX(99,99+A1-1000*10%)
If not upload an example workbook and manually enter some example results for differing numbers of users and prices if relevant.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try this.
Assuming A1 has the number of users.
=INDEX({99;109},MATCH(A1-0.001,{0;1000},1))
Last edited by NeedForExcel; 05-04-2016 at 05:21 AM.
Cheers!
Deep Dave
Perfect and thanks all :-)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Done and thanks Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks