1. ## How to add percentage in a cell?

Hi,

I want to know how I can make that when I import a number let say in cell B2 it should update the number to the number plus the percentage that I set example: if I put in B2 the number 100 and I set it to add 10% to any number it should update the number in cell B2 to 110. Everything in one cell without using two cells.

Is it possible to do? If yes how?

Thank You

2. Possible but requires a VBA solution employing the Worksheet_Change Event

Code:
```Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim tRow As Long
If Target.Column = 2 Then
tRow = Target.Row
Range("B" & tRow) = Range("B" & tRow) * 1.1
End If
End Sub```

3. Welcome to the forum!

If you want to do it manually:
1. Copy 1.1 from a cell.
2. Select cells to multiply the copied 1.1.
2. Paste > Paste Special > Multiply

4. I should try this code? Where can I change the percentage amount?

5. I want it should go automatically

6. 1.1*100=110%, 110-100=10%. So...