+ Reply to Thread
Results 1 to 5 of 5

Super newb question

  1. #1
    Registered User
    Join Date
    09-05-2006
    Posts
    1

    Super newb question

    I need to know how to get excel to add 10% to a number i put into a cell

    Any help appreciated
    thanks

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi

    say A1 has 100 then enter this in B1

    =A1*10%

    Which will return 10

    If you want to add the 10% to the 100 then you would use

    =A1+(A1*10%)

    VBA Noob

  3. #3
    Registered User
    Join Date
    09-04-2006
    Posts
    9
    Hi

    click on help - a side window will open - type percent in the box - click offline help in the dropdown menu - yep you guessed it click the green arrow Read through the results.

    The offline help is really good works for thicko's like me with quite basic search words.

    Tip ! you have 4 search words % add percent percentage if one word for what you are looking for does not work look for another which is relivant usually works

    Tiler

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612
    Put
    =A1*1.1
    in a blank cell, replacing the A1 with the cell you want increased
    Ben Van Johnson

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Lightbulb

    Here's a macro you could use
    enter 1.10 into A1

    Run the Macro

    it selects the Value from A1
    then Multiplies the values in column B


    Sub TenPercent()

    Range("A1").Select
    Selection.Copy
    range("B1:B25").Select
    Selection.PasteSpecial Paste:=xlAll, Operation:=xlMultiply, SkipBlanks:= _
    False, Transpose:=False
    Range("A1").Select
    Application.CutCopyMode = False
    End Sub
    Last edited by davesexcel; 09-05-2006 at 11:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1