Calculation Using Tiered Pricing

[Bazzza67]

Hi board members

I am trying to create a formula whereby if I enter a user number in a reference cell, 100 for example, Excel uses
the below tiered pricing to calculate a monthly fee.

100 users should return a result of £13,340.00

9 @ £150
15 @ £150
50 @ £135
26 @ £115

User Tier
1-9 users__________£150.00
10-24 users________£150.00
25-74 users________£135.00
75-249 users_______£115.00
250-500 users______£110.00
501-750 users______£110.00
751-1000 users_____£110.00

Thank you in anticipation!

 

[Joe4]

Try this (I color coded each part, so it should be easier to see how it is working):
=(MIN(A1,24)*150)+(MAX(MIN(50,A1-24),0)*135)+(MAX(MIN(175,A1-74),0)*115)+(MAX(A1-249,0)*110)

 

[Bazzza67]

That's excellent Joe4, thank you so much!

 

[Joe4]

You are welcome!
If you break each section down, hopefully it makes sense.