How to increase the value of the cell by some percent

D

Deepwater

I am trying to increase the value of cells by certain percentage.
example i have a worksheet with some data in cells C6 to F20 with
different numbers. i want to increase all the cells by 5% , is it
possible?.


Thanks in advance.
 
J

jc94321

Suppose Column A has the values.
Set Column B = A*(1+Percent)
Find a cell somewhere, name it Percent.
If you only want one column, then hide column A.

There may be other ways to do this, but this was the easiest thing I
could think of.
 
B

Bob Phillips

In a spare cell, enter 105%
Copy that cell

Select all the cells to increase
Go to Edit>Pastespecial
Click the Multiply button
OK

Clear the original 105% cell.
 
Top