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

--