+ Reply to Thread
Results 1 to 6 of 6

I need a Formula to calculate an adjusted price that includes a commission

  1. #1
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Question I need a Formula to calculate an adjusted price that includes a commission

    Example:
    A base price of $225 can not be adjusted to include a 15% commission by simply adding 15% of $225 ($33.75 + 225 = 258.75)
    because 15% of $258.75 would be a commission of $38.81 and NOT $33.75 as was allowed.

    I know there must be a formula to do this but I'm having no luck finding it.

    Any assistance would be greatly appreciated!

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    606

    Re: I need a Formula to calculate an adjusted price that includes a commission

    I'm not following what you are asking. Are you saying that $225 is that price including 15% commission and you want to know what that commission amount is?

    Maybe something here might be what you need:
    =225/1.15 or =225/115% *Result = 195.65
    =258.75/1.15 *Result = 225
    =258.75/1.15*.15 *Result = 33.75

    I hope one of these might help.
    Last edited by Beamernsw; 12-13-2015 at 01:39 AM.

  3. #3
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: I need a Formula to calculate an adjusted price that includes a commission

    Thanks for your reply. No, $225 is the base price without commission. I was looking for a formula that would adjust that price to include a 15% commission.

    I think I have the formula worked out now so all that's left is to format it for Excel. I'm hoping someone can help.

    First I need to subtract 1 from the commission percentage ie. (1 - .15 = .85)
    Then use that result as C in the formula below:
    BP / C = AP ie. $225 / (1 - .15) = $264.70

    BP is Base Price
    C is commission
    AP is Adjusted Price

    I don't need the following in Excel but just to prove the formula above:
    $264.70 - 15% = 225
    Last edited by imaquila; 12-13-2015 at 02:14 PM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,681

    Re: I need a Formula to calculate an adjusted price that includes a commission

    A2 = Base price
    B2= Commission (formatted as %)
    in C2 (Adjusted Price)

    =A2/(1-B2)

  5. #5
    Registered User
    Join Date
    01-17-2012
    Location
    Pacific Northwest
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: I need a Formula to calculate an adjusted price that includes a commission

    Thanks so much John! I was trying to make it much more complicated than that!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,681

    Re: I need a Formula to calculate an adjusted price that includes a commission

    Thank you for the feedback.

    If your problem has been answered could you please mark thread as SOLVED ("Thread Tools" at top of first post)

+ 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. [SOLVED] Excel 2013 wants to calculate Sales Price , If cost price exits and wants change SP
    By Bitto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 12:49 PM
  2. Replies: 4
    Last Post: 04-23-2015, 10:38 AM
  3. [SOLVED] Formula to Calculate commission over certain amount
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 02:36 PM
  4. [SOLVED] Formula to calculate commission based on sliding scale
    By Excel Dumbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2013, 10:52 PM
  5. Replies: 2
    Last Post: 05-24-2012, 05:49 AM
  6. Replies: 2
    Last Post: 04-13-2012, 08:22 AM
  7. calculate commission $ based on total sold and commission percent
    By blondeindenver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 10:05 PM

Tags for this Thread

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