View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Christopher King[_2_] Christopher King[_2_] is offline
external usenet poster
 
Posts: 6
Default Calculating a total controlled by multiple variables?

Maybe you need to look at the problem differently: think of the discount as
a percent reduction from a base price. Then, you could look up the percent
reduction in one table (sort of a one-dimensional table), and look up the
base price in the table you already have. Multiply them together, and you've
got the price.
Does that help?
Chris