Volume and pricing calculations

K

Karen

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?
 
R

Ron Coderre

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.
 
Top