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

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

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

Hi Errol,

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

Judith
--
Hope this helps


"Errol" wrote:

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

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

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

"Errol" wrote:

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

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

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

"Errol" wrote:

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

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

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

On Sep 23, 4:29*pm, Errol wrote:
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

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

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!




"Errol" wrote:

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

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

See this:

http://contextures.com/xlDataEntry04.html

Includes a video demonstration.

--
Biff
Microsoft Excel MVP


"Errol" wrote in message
...
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