Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: percent formula

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Nagoya, Japan
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello, I'm new to Excel and am creating a personal database of my music CDs. There are two price columns, E1 and F1. E1 is the price of the CD when bought 'used', while F1 is the 'new' price. I'd like to calculate how much (in terms of percent) I save when buying the used version. That is, what formula do I use to find out what percent of F1 is E1? Thank you very much in advance!

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-25 04:19, claireworks wrote:
    Hello, I'm new to Excel and am creating a personal database of my music CDs. There are two price columns, E1 and F1. E1 is the price of the CD when bought 'used', while F1 is the 'new' price. I'd like to calculate how much (in terms of percent) I save when buying the used version. That is, what formula do I use to find out what percent of F1 is E1? Thank you very much in advance!
    In G1 enter: =IF(F1,E1/F1,0)


  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try entering this formula into the cell where you want the result:

    =100-G3/H3 %

    That should give you the difference as a percentage

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    the %age of F1 of E1 is simply E1/F1 formatted as a percentage

    Bought 10
    Now 14

    is 71%

    Savings in terms of the new price will just be 1-this %age result : 29%

    or =1-(e1/f1), again, formatted to a %age



    _________________
    Hope this helps,
    Chris


    [ This Message was edited by: Chris Davison on 2002-02-25 05:40 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Nagoya, Japan
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wow, this messageboard is simply great! I learned a lot just by reading other people's posts, and now that I decided to ask a question, I got all the answers I need, in less than 24 hours. Thanks so much!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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