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
Bookmarks