+ Reply to Thread
Results 1 to 2 of 2

increasing a range of cells by a percentage but need to add the percentage on to original

  1. #1
    Registered User
    Join Date
    01-13-2013
    Location
    liverpool.england
    MS-Off Ver
    Excel 2010
    Posts
    1

    increasing a range of cells by a percentage but need to add the percentage on to original

    Hi, i am trying to increase a range of cells by say 10%, then add this percentage on to that range of cells to show new price.

    I know how to use a single cell and set by 10% and use paste special and mulitiply, but how do I add this percentage on to original figure.

    for example

    10.00 x 10% = 1.00 ( i need to show the figure in the box as 11.00
    11.00 x 10% = 1.10 (i need to show the figure in the box as 12.10
    12.00 and so on
    13.00 and so on

    is there a formula to do this

    any help much appreciated.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: increasing a range of cells by a percentage but need to add the percentage on to origi

    hi lammie26, welcome to the forum. since you know about paste special & multiply, why not put in 110% or 1.1 in a cell to copy instead of 10%. there's no formula to replace original figure. you could do it in a separate cell though. like if data is in A1, try this in B1:
    =A1*1.1

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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