Results 1 to 5 of 5

Thread: Percenatges in excel

  1. #1
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013

    Lightbulb Percenatges in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, could someone help? I have an excel sheet where I want to be able to add a % as a GP to a cell that looks at a buying cost and adds the percentage in another cell. IE 100 would become 125 with 20% GP. So 100 in A1 20% in B1 and then 125 would appear in C1. C1 would have the formula in. The % would need to be various different ones according to what was needed. Can anyone help me?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    How does 100 + 20% equate to 125 rather than 100?

  3. #3
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    Its when you talk about gross profit rather than mark up. 120 is 20% mark up rather then GP. 100 + 20% GP is 125. Any ideas how I can achieve this result? I used to have a formula which worked in my last job so I know it can be done,

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Okay, use

    =A1/(1-B1)

  5. #5
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    Bob,

    Thanks for that very much, I've tried for a long time to work that out, new t was a simple thing, but.......?

Posting Permissions

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