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!
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.
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.
A2 = Base price
B2= Commission (formatted as %)
in C2 (Adjusted Price)
=A2/(1-B2)
Thanks so much John! I was trying to make it much more complicated than that!
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks