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
--
|