How to add percentage in a cell?

Jakes0029

New member
Joined
Sep 6, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
16.0.6742.2048
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
 
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
 
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
 
I should try this code? Where can I change the percentage amount?
 
I want it should go automatically
 
Back
Top