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

--