Excel formula to find total price based on the range of users

[BBS90]

Hello

I am trying to calculate a price matrix per user based on the number of users. 

If there are 5 users, the price for each of 5 users is 20
If there are 8 users, the price for 1st 5 users is 20, then for the rest 3 users is 18. The total will be the sum of both

It seems tricky for me to calculate if there are more than 5 users, as prices vary based on the number of users. If there are 20 users, there is a need to consider 4 price ranges and so on. 

https://we.tl/t-PlnDJyrkb3 

Any help will be highly appreciated

[#2 · Accepted solution]

@BBS90 

See the attached version.

[#3]

I have a query. I see that the equation works, but when I insert 6 instead of giving me the sum of 118, I get a sum of 120. the same is applicable when I insert 7,8.  But when I insert 10,20,30 etc I get the correct sum.

I am sorry that, yet to understand complete logic

Thanks a lot for your help