Hi All!
I'm trying to create a calculator that would calculate the total pricing for an account based on a graduated tier pricing model. We charge a license fee per user, and the more users you have, the cheaper your per user pricing.
For example, if we charge $100 per user for 1-50 users, $50 per user for 51-250 users, and $25 per user for 251+ users. However, if someone has 51 users, they don't suddenly begin paying $50*51 users. Instead, they pay $100*50 + 1*50, because they have 1 user in the new tier.
I found many solutions to calculate the price based on the number of users, but I can't figure out how to keep the pricing cumulative. I tried an IF formula but seemed to have messed it up, since I believe it's just multiplying the first pricing tier X the total # of users.
Can anyone help me? Thank you very much in advance!
Bookmarks