Results 1 to 4 of 4

Thread: Reverse calculate margin
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Reverse calculate margin

    First time poster and desperate for help!

    I work in sales spend a lot of my time working out selling prices for my team and me. As a sanity check, I use a spreadsheet (I call my Margin Calculator) to enter all costs and then, depending on the client, the final selling price rather than pen and paper. My Excel skills are good enough for this basic task. But, and here it comes, a former colleague set up a formula for me to reverse calculate the margin, which has somehow been deleted out of my master copy and now I, for the life of me, cannot work out how the former colleague did the formula.

    In my Margin Calculator I have one formula to work out margin (in percentage):

    =1-(1/D3)

    D3 is the cell where I add the markup, e.g.

    1.25 = 20%
    1.30 = 23% etc

    I used to have a formula to do the reverse calculation, i.e. a cell where I could enter a percentage value and the cell below would generate the markup for me, e.g.

    I would put 20% into cell D7, and the formula in cell D6 would display 1.25.

    I know this should not be this hard, but I am stumped and have other members of my sales team breathing down my neck for an updated spreadsheet that works.

    Please help!! What is the formula??

    Thanks!

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse calculate margin

    Hi,

    What about =1/(1-D7)

    Hope this will help

  3. #3
    New Member
    Join Date
    Dec 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse calculate margin

    Thank you so much!!

  4. #4
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Reverse calculate margin

    You are welcome ...

Some videos you may like

User Tag List

Tags for this Thread

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
  •