How to increase all values in my spreadsheet by 10% automatically

  • Thread starter Thread starter Errol
  • Start date Start date
E

Errol

If I have entered in all my values and formulas into a worksheet and I want
to increase all these values by 10%, how do I go about doing this?

Cheers
 
Hi Errol,

Type 1.1 into a cell and copy it. Highlight all your figures and right click
+ Paste Special + Multiply.

Judith
 
You could run a sub:

For Each C In Worksheets("sheet1").Range("A1:Z1000")
If C.Value <> "" Then
C.Value = C.Value + C.Value / 10
End If
Next
 
Hi,

In an empty cell enter 1.1 and copy it

Select the values to increase and then
Edit|Paste special - select 'Multiply'
Ok
delete the cell with 1.1 in

Mike
 
You can change the values by putting 1.1 in an empty cell somewhere
(this is equivalent to 110%), selecting that cell and clicking on
<copy>. Then you should select all the values in your sheet (not the
formulae) and then Edit | Paste Special | Values (check) | Multiply
(check) | OK then <Esc>. You can delete the 1.1 from the original
cell.

Some of your formulae may not work in the same way if you do this. If,
for example, you had a formula like:

=IF(A1<10,do_something,do_something_else)

and A1 used to contain 9.5 so that the do_something was actioned, then
increasing A1 by 10% will cause the do_something_else to be actioned.

Hope this helps.

Pete
 
Errol, there could be a variety of ways of doing this depending upon how you
have constructed your Workbook but here is a simple possible solution:-

1 10% 0.1
2 10% 0.2
3 10% 0.3
4 10% 0.4
5 10% 0.5

The above info was entered into cells A1:C5.

Please hit Yes if my comments have been helpful to you.

Thanks!
 
Back
Top