Help!!! Percentage excel question

[nmccarty82]

I have to upgrade a pricing sheet, increasing all numbers by 4%. I want to know how to add the percentage to each number and have that same cell equal the TOTAL. Already know how to copy, paste special, the value, then multiply but that only gives me the 4% increase number in that cell, I need the total of the existing cell with the percentage increase.
Example: one cell has the number 10,000 in it, but need to add 4% making it 10,400 in that same cell. Can anyone help me? I have over 2000 numbers to change.

 

[timfritsch]

Excel User Tip: Change cell values using Paste Special


Tim

 

[Smitty]

Welcome to the Board!

Use 1.04 and Paste Special-->Multiply.

HTH,

 

[nmccarty82]

I do appreciate the help, but when I use 1.04 in a separate cell, copy, paste special, the cell changes to only the 4% number not the total, I need the whole number in that same cell

UPDATE! Im thankful for your help, and it worked. SOrry guys, thanks again