Formulas to Numbers

M

MAD

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
 
E

Eduardo

Hi,
select the range, copy, go to where you want to paste the information, paste
special, values
 
J

Jacob Skaria

and to increase by a % (say by 10% )

--type 1.1 in a unused cell and copy the cell (not the cell content)
--Select the range of numbers to be increased.
--Right click>Paste special>select 'Multiply' >Hit OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top