Volume and pricing calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multi-level pricing schedule and I want to calculate each month's
cost based on the volume times the appropriate pricing tier. The IF
statement is restricted to 7 sub-set statements and my pricing levels exceed
seven. How can I accomplish the calculation?
 
From your post, it seems like you could build a table of your pricing tiers
and us a VLOOKUP function to return what you're looking for. See if that
works for you. Let us know if you need more help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tiered Pricing Formulae - is this possible? 3
Formula to return value from multiple sheets if volume matched 2
alternatives to embedded ifs 6
Percentage Increase 13
Calculating the Median Price Sold 3
What's the best way to set this formula up? 0
Latest Purchase Price 3
Calculating sales commission that changes based on a sales volume 2

Back
Top