View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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

--