+ Reply to Thread
Results 1 to 8 of 8

How to add a profit margin to a total?

  1. #1
    Registered User
    Join Date
    02-16-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    13

    How to add a profit margin to a total?

    Hi Everyone,

    just wondering how I can automatically add a margin, say 15% to the total of a row.

    For example,
    f G

    21 plumbing $2500 $375
    22 landscaping $3200 $480
    23 Kitchen $7200 $1080


    The way I have it at the moment is that column G is =(f21)*.15
    which only gives me 15% of f21, but i would like to know f21 plus 15% as a total $2875.

    I know this is really basic, but I can't quite work it out!

    Many thanks for your help.

    Scott.

  2. #2
    Registered User
    Join Date
    02-16-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to add a profit margin to a total?

    Sorry, when I posted this, my rows were squashed!
    Meant to be like this

    ...................................f ................G

    21........plumbing ..........$2500......... $375
    22 .......landscaping ......$3200......... $480
    23 .......Kitchen............ $7200........ $1080

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: How to add a profit margin to a total?

    Hi Scott- Paste this in G21 and copy down:
    =F21*1.15

    Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
    Last edited by leelnich; 08-22-2017 at 07:21 PM.

  4. #4
    Registered User
    Join Date
    08-22-2017
    Location
    RI, USA
    MS-Off Ver
    Office 2010
    Posts
    5

    Re: How to add a profit margin to a total?

    In G21, =F21*1.15

  5. #5
    Registered User
    Join Date
    02-16-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to add a profit margin to a total?

    Hi Lee, and blue_shadow,

    many thanks, spot on!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to add a profit margin to a total?

    Profit is measured on sales, not cost. If you want 15% profit, divide by (1-15%).

    E.g., for $100 cost, the price would be $117.65
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: How to add a profit margin to a total?

    True!...though I took OP to mean a 15 % MARKUP. Not seein' the word "profit" there.
    OOPS! Just saw that profit is mentioned in the TITLE. Nice catch, shg!
    Last edited by leelnich; 08-22-2017 at 09:07 PM.

  8. #8
    Registered User
    Join Date
    02-16-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to add a profit margin to a total?

    Sorry, I should have just said 15% mark up to make it less confusing.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. help with a profit margin formula please
    By lynchburgbull in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2016, 07:47 AM
  2. Price determined by Profit Margin
    By johntyjohnson in forum Excel General
    Replies: 6
    Last Post: 08-31-2015, 02:59 PM
  3. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  4. [SOLVED] Profit margin formulas
    By Allgermanparts in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-25-2013, 06:30 AM
  5. easy one - margin % from revenue and profit?
    By equinox101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2013, 05:52 AM
  6. Need Backwards Profit Margin Formula
    By waywrdchld in forum Excel General
    Replies: 7
    Last Post: 04-14-2009, 09:56 AM
  7. Profit Margin Trend
    By uplink600 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 11:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1