# Equation for amount minus the percentage.

PCLIVE
Guest
Posts: n/a

 19th Sep 2008
I know this is more math than Excel, but I thought someone may know the
equation. Once I know the equation, I can do the formula with no problem.

In a PayPal type example, let's say I charge someone \$100 for a service and
PayPal charges a 2.9% transaction fee.
That's a total of \$102.90.

So how can I determine how much more to charge someone so that after the
percentage fee has been subtracted, I will end up with the desired amount of
\$100?

If I charge \$102.90, then the transaction fee is now \$2.98 and the the
difference is \$99.92 (but I need it to be \$100, for this example)

Does anyone know of an equation that will determine this regardless of the
initial charge amount?

Thanks.
Paul

--

PCLIVE
Guest
Posts: n/a

 19th Sep 2008
For 2.9%, this seems to work, but I'm not sure if there are any limitations.

=100+(100*2.987%)

This equates to \$102.99 of which 2.9% of that is \$2.99. When subtracted,
that gives me the desired amount of \$100.
Is there a way to figure this out regardless of the percentage fee.

Thanks,
Paul

--

"PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
news:(E-Mail Removed)...
>I know this is more math than Excel, but I thought someone may know the
>equation. Once I know the equation, I can do the formula with no problem.
>
> In a PayPal type example, let's say I charge someone \$100 for a service
> and PayPal charges a 2.9% transaction fee.
> That's a total of \$102.90.
>
> So how can I determine how much more to charge someone so that after the
> percentage fee has been subtracted, I will end up with the desired amount
> of \$100?
>
> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
> difference is \$99.92 (but I need it to be \$100, for this example)
>
> Does anyone know of an equation that will determine this regardless of the
> initial charge amount?
>
> Thanks.
> Paul
>
> --
>
>
>

Bernard Liengme
Guest
Posts: n/a

 19th Sep 2008
David has given you the exact answer.
But if you cannot do that math, let Solver do it
In A1 enter text "Price", in B1 "PayPal", in C1 "I get"
In A2 enter any number (say 100),
in B2 enter =ROUND(2.9%*A2,2)
in C2 enter =A2-B2
Now have Solver (or Goal Seek) make C2 equal 100 by varying A2.
I get 102.99 (same as David's rounded value)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
news:(E-Mail Removed)...
>I know this is more math than Excel, but I thought someone may know the
>equation. Once I know the equation, I can do the formula with no problem.
>
> In a PayPal type example, let's say I charge someone \$100 for a service
> and PayPal charges a 2.9% transaction fee.
> That's a total of \$102.90.
>
> So how can I determine how much more to charge someone so that after the
> percentage fee has been subtracted, I will end up with the desired amount
> of \$100?
>
> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
> difference is \$99.92 (but I need it to be \$100, for this example)
>
> Does anyone know of an equation that will determine this regardless of the
> initial charge amount?
>
> Thanks.
> Paul
>
> --
>
>
>

PCLIVE
Guest
Posts: n/a

 19th Sep 2008
Thanks David,

Your reply wasn't there when I replied to myself. The reason replied to
myself is because I had stumbled across an equation that appeared to be
working. I didn't want to double post.

I like your solution. I can't believe how simple it was. That's a lot
simpler than my:

=A1+(A1*2.9866117404737%)

Thanks again,
Paul

--

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:-(E-Mail Removed)...
> You seem to be replying to yourself, rather than to anyone else, but you
>
> If you want to replace 2.9% by a percentage in A2 the formula becomes
> =A1/(1-A2)
> --
> David Biddulph
>
> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
> news:(E-Mail Removed)...
>> For 2.9%, this seems to work, but I'm not sure if there are any
>> limitations.
>>
>> =100+(100*2.987%)
>>
>> This equates to \$102.99 of which 2.9% of that is \$2.99. When subtracted,
>> that gives me the desired amount of \$100.
>> Is there a way to figure this out regardless of the percentage fee.
>>
>> Thanks,
>> Paul
>>
>>
>> --
>>
>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>> news:(E-Mail Removed)...
>>>I know this is more math than Excel, but I thought someone may know the
>>>equation. Once I know the equation, I can do the formula with no
>>>problem.
>>>
>>> In a PayPal type example, let's say I charge someone \$100 for a service
>>> and PayPal charges a 2.9% transaction fee.
>>> That's a total of \$102.90.
>>>
>>> So how can I determine how much more to charge someone so that after the
>>> percentage fee has been subtracted, I will end up with the desired
>>> amount of \$100?
>>>
>>> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
>>> difference is \$99.92 (but I need it to be \$100, for this example)
>>>
>>> Does anyone know of an equation that will determine this regardless of
>>> the initial charge amount?
>>>
>>> Thanks.
>>> Paul
>>>
>>> --
>>>
>>>
>>>

>>
>>

>
>

PCLIVE
Guest
Posts: n/a

 22nd Sep 2008
David,

You're formula was great. Now for one additional value that I mistakenly
ommitted.
In direct relation to PayPal, there is a \$0.30 transaction fee. Is there a
way to fit this into the formula? At first I thought:
=A1/(1-2.9%)+.30

However, that result is off by one cent. I already know how to do it in
Goal Seek, but I was wondering if this can be equated within the formula.

My specific example uses \$10.00
Transaction fee is \$0.30

The total needed up front is \$10.61. Can I somehow figure in the
transaction fee?

Thanks,
Paul

--

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:-(E-Mail Removed)...
> You seem to be replying to yourself, rather than to anyone else, but you
>
> If you want to replace 2.9% by a percentage in A2 the formula becomes
> =A1/(1-A2)
> --
> David Biddulph
>
> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
> news:(E-Mail Removed)...
>> For 2.9%, this seems to work, but I'm not sure if there are any
>> limitations.
>>
>> =100+(100*2.987%)
>>
>> This equates to \$102.99 of which 2.9% of that is \$2.99. When subtracted,
>> that gives me the desired amount of \$100.
>> Is there a way to figure this out regardless of the percentage fee.
>>
>> Thanks,
>> Paul
>>
>>
>> --
>>
>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>> news:(E-Mail Removed)...
>>>I know this is more math than Excel, but I thought someone may know the
>>>equation. Once I know the equation, I can do the formula with no
>>>problem.
>>>
>>> In a PayPal type example, let's say I charge someone \$100 for a service
>>> and PayPal charges a 2.9% transaction fee.
>>> That's a total of \$102.90.
>>>
>>> So how can I determine how much more to charge someone so that after the
>>> percentage fee has been subtracted, I will end up with the desired
>>> amount of \$100?
>>>
>>> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
>>> difference is \$99.92 (but I need it to be \$100, for this example)
>>>
>>> Does anyone know of an equation that will determine this regardless of
>>> the initial charge amount?
>>>
>>> Thanks.
>>> Paul
>>>
>>> --
>>>
>>>
>>>

>>
>>

>
>

David Biddulph
Guest
Posts: n/a

 22nd Sep 2008
Well you haven't made it clear at what stage you deduct the transaction fee,
and at what stage you now calculate the other percentage fee, but to get
that answer you may want something like
=(A1+0.3)/(1-2.9%)

In that case, if you start from your original selling price, and first
deduct the 2.9% that would leave\$10.30, and then you could knock off the 30
cents to leave you with \$10.00.
--
David Biddulph

"PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
news:%(E-Mail Removed)...
> David,
>
> You're formula was great. Now for one additional value that I mistakenly
> ommitted.
> In direct relation to PayPal, there is a \$0.30 transaction fee. Is there
> a way to fit this into the formula? At first I thought:
> =A1/(1-2.9%)+.30
>
> However, that result is off by one cent. I already know how to do it in
> Goal Seek, but I was wondering if this can be equated within the formula.
>
> My specific example uses \$10.00
> Transaction fee is \$0.30
>
> The total needed up front is \$10.61. Can I somehow figure in the
> transaction fee?
>
> Thanks,
> Paul
>
>
>
> --
>
> "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
> news:-(E-Mail Removed)...
>> You seem to be replying to yourself, rather than to anyone else, but you
>>
>> If you want to replace 2.9% by a percentage in A2 the formula becomes
>> =A1/(1-A2)
>> --
>> David Biddulph
>>
>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>> news:(E-Mail Removed)...
>>> For 2.9%, this seems to work, but I'm not sure if there are any
>>> limitations.
>>>
>>> =100+(100*2.987%)
>>>
>>> This equates to \$102.99 of which 2.9% of that is \$2.99. When
>>> subtracted, that gives me the desired amount of \$100.
>>> Is there a way to figure this out regardless of the percentage fee.
>>>
>>> Thanks,
>>> Paul
>>>
>>>
>>> --
>>>
>>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>>> news:(E-Mail Removed)...
>>>>I know this is more math than Excel, but I thought someone may know the
>>>>equation. Once I know the equation, I can do the formula with no
>>>>problem.
>>>>
>>>> In a PayPal type example, let's say I charge someone \$100 for a service
>>>> and PayPal charges a 2.9% transaction fee.
>>>> That's a total of \$102.90.
>>>>
>>>> So how can I determine how much more to charge someone so that after
>>>> the percentage fee has been subtracted, I will end up with the desired
>>>> amount of \$100?
>>>>
>>>> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
>>>> difference is \$99.92 (but I need it to be \$100, for this example)
>>>>
>>>> Does anyone know of an equation that will determine this regardless of
>>>> the initial charge amount?
>>>>
>>>> Thanks.
>>>> Paul
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>

PCLIVE
Guest
Posts: n/a

 22nd Sep 2008
That's it:
=(A1+0.3)/(1-2.9%)

I had actually tried that but I forgot about the fact that the order of
operators would not first add .3 to A1 without the parenthesis. I put them
there and it works.

Thanks again for the help.
Paul

--

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:48d7c3b7\$(E-Mail Removed)...
> Well you haven't made it clear at what stage you deduct the transaction
> fee, and at what stage you now calculate the other percentage fee, but to
> get that answer you may want something like
> =(A1+0.3)/(1-2.9%)
>
> In that case, if you start from your original selling price, and first
> deduct the 2.9% that would leave\$10.30, and then you could knock off the
> 30 cents to leave you with \$10.00.
> --
> David Biddulph
>
> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
> news:%(E-Mail Removed)...
>> David,
>>
>> You're formula was great. Now for one additional value that I mistakenly
>> ommitted.
>> In direct relation to PayPal, there is a \$0.30 transaction fee. Is there
>> a way to fit this into the formula? At first I thought:
>> =A1/(1-2.9%)+.30
>>
>> However, that result is off by one cent. I already know how to do it in
>> Goal Seek, but I was wondering if this can be equated within the formula.
>>
>> My specific example uses \$10.00
>> Transaction fee is \$0.30
>>
>> The total needed up front is \$10.61. Can I somehow figure in the
>> transaction fee?
>>
>> Thanks,
>> Paul
>>
>>
>>
>> --
>>
>> "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
>> news:-(E-Mail Removed)...
>>> You seem to be replying to yourself, rather than to anyone else, but you
>>>
>>> If you want to replace 2.9% by a percentage in A2 the formula becomes
>>> =A1/(1-A2)
>>> --
>>> David Biddulph
>>>
>>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>>> news:(E-Mail Removed)...
>>>> For 2.9%, this seems to work, but I'm not sure if there are any
>>>> limitations.
>>>>
>>>> =100+(100*2.987%)
>>>>
>>>> This equates to \$102.99 of which 2.9% of that is \$2.99. When
>>>> subtracted, that gives me the desired amount of \$100.
>>>> Is there a way to figure this out regardless of the percentage fee.
>>>>
>>>> Thanks,
>>>> Paul
>>>>
>>>>
>>>> --
>>>>
>>>> "PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>I know this is more math than Excel, but I thought someone may know the
>>>>>equation. Once I know the equation, I can do the formula with no
>>>>>problem.
>>>>>
>>>>> In a PayPal type example, let's say I charge someone \$100 for a
>>>>> service and PayPal charges a 2.9% transaction fee.
>>>>> That's a total of \$102.90.
>>>>>
>>>>> So how can I determine how much more to charge someone so that after
>>>>> the percentage fee has been subtracted, I will end up with the desired
>>>>> amount of \$100?
>>>>>
>>>>> If I charge \$102.90, then the transaction fee is now \$2.98 and the the
>>>>> difference is \$99.92 (but I need it to be \$100, for this example)
>>>>>
>>>>> Does anyone know of an equation that will determine this regardless of
>>>>> the initial charge amount?
>>>>>
>>>>> Thanks.
>>>>> Paul
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post FSPH Microsoft Word Document Management 5 23rd Jun 2009 08:22 PM Rockbear Microsoft Excel Worksheet Functions 3 10th Oct 2008 09:49 AM =?Utf-8?B?U29jYWwgQW5hbHlzdCBsb29raW5nIGZvciBoZWxw Microsoft Excel Misc 2 12th May 2006 07:17 PM =?Utf-8?B?TXMgRXF1YXRpb24=?= Microsoft Word Document Management 1 24th Dec 2004 03:45 AM =?Utf-8?B?VmF1Z2hhbg==?= Microsoft Excel Worksheet Functions 5 4th Jul 2004 11:20 PM

Features