Results 1 to 6 of 6

Thread: How to add percentage in a cell?

  1. #1
    Neophyte Jakes0029's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    16.0.6742.2048

    Question How to add percentage in a cell?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    194
    Articles
    0
    Excel Version
    2019
    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. #3
    Conjurer Kenneth Hobson's Avatar
    Join Date
    Mar 2014
    Location
    Tecumseh, OK
    Posts
    136
    Articles
    0
    Excel Version
    365
    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. #4
    Neophyte Jakes0029's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    16.0.6742.2048
    I should try this code? Where can I change the percentage amount?

  5. #5
    Neophyte Jakes0029's Avatar
    Join Date
    Sep 2019
    Posts
    3
    Articles
    0
    Excel Version
    16.0.6742.2048
    I want it should go automatically

  6. #6
    Conjurer Kenneth Hobson's Avatar
    Join Date
    Mar 2014
    Location
    Tecumseh, OK
    Posts
    136
    Articles
    0
    Excel Version
    365
    1.1*100=110%, 110-100=10%. So...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •