View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mad mad is offline
external usenet poster
 
Posts: 5
Default Formulas to Numbers

I am using Excel 2003
I have a price table for each of our products. Ex: Product #xxx - 1 item
cost $100. Price B for 2-5 items cost (=100*.95%), Price C for 5-25 items
cost (=Price B * .80%) ect. Most of the cells have formulas based on another
cell. I want to copy this whole chart as just plain numbers and not as
formulas. Hopefully then I will be able to create a new chart based on the
old numbers by increaseing the old numbers by a % number.
I used to know how to do this, but I have forgotten. Can anyone help me???

Aurora