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:
Please Login or Register to view this content.
BSB
Hi,
Not sure whether the price is variable but with the number of users in A1 try
Formula:Please Login or Register to view this content.
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