LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,311
Default Equation for amount minus the percentage.

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

--



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set total amount for an equation..... hln Excel Discussion (Misc queries) 5 July 24th 08 06:21 AM
Need the minus amount to show txheart Excel Discussion (Misc queries) 3 April 18th 08 02:30 AM
FIND PERCENTAGE AMOUNT FOR 5 DEPT. FROM ONE WHOLE AMT XCL KARLOSS/QUEENS Excel Worksheet Functions 1 September 17th 06 07:11 PM
Percentage value of amount Jay Excel Worksheet Functions 7 August 24th 06 05:01 AM
how to color code a cell in excel if amount reaches a minus Pat Mineard Excel Discussion (Misc queries) 5 June 16th 05 03:48 PM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"