View Single Post
  #1   Report Post  
Karen
 
Posts: n/a
Default 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?