View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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

--