Equation for amount minus the percentage.
 

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

--

Equation for amount minus the percentage.
 

=A1/(1-2.9%)
--
David Biddulph

"PCLIVE" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

You seem to be replying to yourself, rather than to anyone else, but you may
not have read my reply where I said =A1/(1-2.9%)

If you want to replace 2.9% by a percentage in A2 the formula becomes
=A1/(1-A2)
--
David Biddulph

"PCLIVE" wrote in message
...
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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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
...
You seem to be replying to yourself, rather than to anyone else, but you
may not have read my reply where I said =A1/(1-2.9%)

If you want to replace 2.9% by a percentage in A2 the formula becomes
=A1/(1-A2)
--
David Biddulph

"PCLIVE" wrote in message
...
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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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
...
You seem to be replying to yourself, rather than to anyone else, but you
may not have read my reply where I said =A1/(1-2.9%)

If you want to replace 2.9% by a percentage in A2 the formula becomes
=A1/(1-A2)
--
David Biddulph

"PCLIVE" wrote in message
...
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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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" wrote in message
...
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
...
You seem to be replying to yourself, rather than to anyone else, but you
may not have read my reply where I said =A1/(1-2.9%)

If you want to replace 2.9% by a percentage in A2 the formula becomes
=A1/(1-A2)
--
David Biddulph

"PCLIVE" wrote in message
...
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" wrote in message
...
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

--

Equation for amount minus the percentage.
 

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
...
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" wrote in message
...
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
...
You seem to be replying to yourself, rather than to anyone else, but you
may not have read my reply where I said =A1/(1-2.9%)

If you want to replace 2.9% by a percentage in A2 the formula becomes
=A1/(1-A2)
--
David Biddulph

"PCLIVE" wrote in message
...
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" wrote in message
...
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

--