View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
keith metcalfe keith metcalfe is offline
external usenet poster
 
Posts: 1
Default how do i get excel to use data in a table based on the result of a

i have a table set up that uses a sales price to caluclate a levy based on
various formula's for 5 ranges. i have then set up a calculation table which
returns a result between 1 and 5 depending on the result of the calculations.
i want to autmatically have that result entered into the table which shows
the selling price in the row next to the selling price, but can't figure a
way to do this, i currently manually enter the cell reference to the result
of the calculation based on the rsult it returns (1-5), any suggestions?