excel help...percentage!

Discussion in 'General Chat' started by Deadringers, Aug 30, 2013.

  1. Deadringers

    Deadringers
    Well-known Member

    Joined:
    Jul 14, 2008
    Messages:
    9,833
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    Herts
    Ratings:
    +1,800
    hi all,

    It's been a long week and my mind has gone blank!

    Trying to get the % of profit between 2 numbers.

    e.g:
    I buy x for 21 and sell x for 41.

    difference is 21 which is profit but what formula do I put in excel for it to work out that as a % of my buying price?
     
  2. MaturityDodger

    MaturityDodger
    Well-known Member

    Joined:
    Feb 21, 2011
    Messages:
    3,805
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    133
    Location:
    Near Slough
    Ratings:
    +604
    where b=buy price, s=sell price, p=profit, m=profit margin

    p = s-b
    m = p/b

    so therefore
    m = (s-b)/b

    which is the same as
    m = (s/b)-(b/b)
    m = (s/b)-1

    if I've understood your question correctly.
    Then you can either use excel's % format, or multiply by 100 to turn it into a percentage.
     
    Last edited: Aug 30, 2013
  3. Deadringers

    Deadringers
    Well-known Member

    Joined:
    Jul 14, 2008
    Messages:
    9,833
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    Herts
    Ratings:
    +1,800
    Thanks that's it!

    *** it really is a slow day today! :(
     
  4. PU6HY

    PU6HY
    Well-known Member

    Joined:
    Nov 30, 2007
    Messages:
    6,791
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    Cardiff, Wales
    Ratings:
    +1,155
    The selling price should be net selling price so take the vat off the selling price too.
     
  5. Mr Incredible

    Mr Incredible
    Distinguished Member

    Joined:
    Dec 2, 2003
    Messages:
    23,877
    Products Owned:
    2
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    The Fylde Coast
    Ratings:
    +13,512
    Perhaps you were confused with the fact that the difference is actually 20, not 21!! :devil:
     
  6. Deadringers

    Deadringers
    Well-known Member

    Joined:
    Jul 14, 2008
    Messages:
    9,833
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    Herts
    Ratings:
    +1,800
    see a very long week at work! :facepalm:
     

Share This Page

Loading...
  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.
    Dismiss Notice