formula to increase a number by 10%?

[ruffridder9]

hi,
could someone please tell me the formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.

thanks.

[VBA Noob]

Hi,

All in one cell

=20+(20*10%)

or pointing to a cell ref. Assumes A1 has the value 20

=A1+(A1*10%)

If you just want the % try

=A1*10%

VBA Noob

[ruffridder9]

thanks for ur help mate it worked theres one more thing i wanted 2 know is there a function in excel to do this or do i have to manually type the formula?

[ruffridder9]

is there a function in excel to increase a a number by 10% or do i have to manually type the formula?

[daddylonglegs]

If you have a range of numbers (or even a single one) that you want to increase by 10% you can do this.

Type 1.1 in an unused cell and copy that cell.

Select range of numbers to be increased. Edit > Paste Special > multiply > OK

[Raiby]

If you have a range of numbers (or even a single one) that you want to increase by 10% you can do this.

Type 1.1 in an unused cell and copy that cell.

Select range of numbers to be increased. Edit > Paste Special > multiply > OK

Hi

The problem with this method is that all the numbers are multiplied by themselves
Example, the range
1 2 3
4 5 6

becomes
1 4 9
16 25 36

You can't chose the multiplication. Then i suggest this solution. It's a macro
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
For i = 1 To 30
'If you have 30 lines
For j = 1 To 10
'If you have 10 columns
Cells(i, j) = Cells(i, j) + Cells(i, j) * 0.5
Next j
Next i
End Sub

In this case, all numbers are multiplies by 0,5.

[daddylonglegs]

The problem with this method is that all the numbers are multiplied by themselves

This is a well-established method for changing a range of numbers. If you tried and it didn't work then I suggest you aren't following the instructions as above. If correctly impemented then these numbers

1 2 3
4 5 6

will become these

1.1 2.2 3.3
4.4 5.5 6.6

i.e. a 10% increase as requested

[loumf]

What you probably did was copy the original cells instead of just the cell containing 1.1.

1. put 1.1 in an unused cell
2. select it and hit ctrl-c
3. select the range of numbers you want to bump up by 10%
4. Choose Edit->Paste Special...
5. Choose Multiply and OK
6. You can get rid of the 1.1 if you want

[Raiby]

This is a well-established method for changing a range of numbers. If you tried and it didn't work then I suggest you aren't following the instructions as above. If correctly impemented then these numbers

1 2 3
4 5 6

will become these

1.1 2.2 3.3
4.4 5.5 6.6

i.e. a 10% increase as requested

Hi

I'm sorry. You're right. I have made a mistake.

[davesexcel]

you can use copy paste
if you have values in one column and you want to multiply it by another range Say E1 is the # to multiply by ....in this case 1.1
A1:A10 are the values you want to increase
select E1 and copy
select A1:A10
choose paste special
Select Multiply
you could use your macro recorder to get this to work at a press of a button