Forum Discussion

BBS90's avatar
BBS90
Copper Contributor
May 03, 2023
Solved

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

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 2...
excel
Formulas and Functions
  • BBS90's avatar
    BBS90
    Copper Contributor
    May 03, 2023

    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

Resources