1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Percentages in Excel

Discussion in 'Other PC Software' started by jaford6, 2005/04/11.

Thread Status:
Not open for further replies.
  1. 2005/04/11
    jaford6

    jaford6 Inactive Thread Starter

    Joined:
    2004/04/22
    Messages:
    11
    Likes Received:
    0
    I need some help with a formula for marking up a column of dollar amounts by a set percentage. I have a rather large column of prices that I need to change.
    Any help is appreciated!
     
    jaford6,
    #1
  2. 2005/04/11
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,315
    Likes Received:
    252
    Can you be more specific?

    Do you have a number that is $5.00 for example and you want to change it to $5.00 + 5%?
     
    Steve R Jones,
    #2


  3. to hide this advert.

  4. 2005/04/11
    jaford6

    jaford6 Inactive Thread Starter

    Joined:
    2004/04/22
    Messages:
    11
    Likes Received:
    0
    Yes. It is a price sheet for a customer and we have has an increase of say 5%. So, if the price is $5.00, I want to plug in a formula to increase all the prices by 5%, so the $5.00 item would be $ 5.25.
     
    jaford6,
    #3
  5. 2005/04/11
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    One way simple (?) way of doing this .....

    Insert a new column adjacent to the column listing the prices

    In the new cell adjacent to the first price insert the formula ....

    "=A1*1.05 " - without the quotes - where A1 is the cell reference for the first cell which contains a price and *1.05 increases the value by 5%

    Fill down the new column and delete or hide the original prices column
     
    PeteC,
    #4
  6. 2005/04/11
    jaford6

    jaford6 Inactive Thread Starter

    Joined:
    2004/04/22
    Messages:
    11
    Likes Received:
    0
    Thanks Pete, that worked just great.
    Thanks for your help! :)
     
    jaford6,
    #5
  7. 2005/04/11
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    You're welcome :)
     
    PeteC,
    #6
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...