how to increase value in several cells by a percentage

[Guest]

I want to increase the dollar value in several cells on the same worksheet by
a certain percent. I want to be able to do this annually with the percent
possibly changing. This is to be used for price increases.

 

[Frank Kabel]

Hi
try the following (e.g. for a 5% increase)
- put 1.05 in an empty cell and copy this cell
- select your dollar values
- goto 'Edit - Paste Special' and choose 'Multiply'

 

[kkknie]

Type the percentage somewhere in your spreadsheet and add 100% to it.
(I.e. for a 10% increase type 1.10 or 110%).
Select the percentage and Copy.
Select all of the values you wish to increase (hold down Ctrl key t
select multiple).
Right click on one one of the selected cells and select Paste Special.
Under the operation buttons, select multiply.
Hit OK and you are done.

 

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("B1")) Is Nothing Then
For Each cell In Range("A1:A100")
If cell.Value <> "" And IsNumeric(cell.Value) Then
cell.Value = cell.Value + Target.Value
End If
Next cell
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

 

[BenjieLop]

In any unused cell, enter your multiplier. For example, if your
percentage increase is 5%, enter "1.05" (without the quotes) in this
unused cell.

Copy this cell (Ctrl C)

Highlight the range that you want to change

Go to: Edit/Paste Special/Multiply

Click OK

I want to increase the dollar value in several cells on the same
worksheet by
a certain percent. I want to be able to do this annually with the
percent
possibly changing. This is to be used for price increases.