# automated price calculation with no. of user dependent pricing

1. ## automated price calculation with no. of user dependent pricing

Hey guys,

so I've been trying to figure out a way to automatically get my final price calculated for a product which has a number of user dependent pricing.

As you can see in the table the price goes down the more user rights are purchased. Yet, the next cheaper price applies only to the number of users above the break.
This means that for example if someone has licensed:

180 user rights, its (15 x 90€ + 35 x 80€ + 50 x 65€ x 80 x 55€) x 12 to get the yearly final price
260 user rights, its (15 x 90€ + 35 x 80€ + 50 x 65€ x 100 x 55€ + 60 x 45) x 12 to ge the yearly final price

SO my goal is to have two fields, one in which I enter a user number so that the second field what then tell me the yearly final price. Now my problem is (granted, Im no expert in Excel) is that I dont know which formula to use for this. I tried some variations of If clauses with the field being < or > than the "From" fields, but nothing really worked out...

Any help is greatly appreciated!!

Thanks,

Dan
[Office 2013]
table.png

2. ## Re: automated price calculation with no. of user dependent pricing

the attached works with a helper column;

3. ## Re: automated price calculation with no. of user dependent pricing

With A1 is user number

B1 is expected yearly final price:

``Please Login or Register  to view this content.``

4. ## Re: automated price calculation with no. of user dependent pricing

hey thanks so much for the quick replies.
I'm using AlanY's approach for now,still figuring out bebo's

There are currently 1 users browsing this thread. (0 members and 1 guests)