Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Volume and pricing calculations
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? |
#2
|
|||
|
|||
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. -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|