Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Reverse Fees Linear Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roddy - 27 May 2008 18:54 GMT
I have Excel 2002, and came across a website that has a PayPal/eBay
calculator.  I needed an exact dollar amount, but forgot about the fees that
would be charged. I told my sister that I knew the percentage and additional
fee PayPal charged for receiving money which is: 2.9% plus .30 cents of the
total being received.

She came up with a linear formula which works perfectly where I can figure
what to charge so I can end up with the exact amount I needed. I came across
a few websites that have an online calculator in which you enter the amount
you want, and also tells you how much to chatge so you end up with the amount
you want after all fees.

My Question: Is there a simple way of entering a formula in Excel 2002 to do
this?
Signature

In God''s Harmony

David Biddulph - 27 May 2008 20:33 GMT
=(A2+0.3)/(1-2.9%)
--
David Biddulph

>I have Excel 2002, and came across a website that has a PayPal/eBay
> calculator.  I needed an exact dollar amount, but forgot about the fees
[quoted text clipped - 17 lines]
> do
> this?
Roddy - 27 May 2008 21:20 GMT
Thanks David. Sure looks easy when you put it like that!
Signature

In God''s Harmony

> =(A2+0.3)/(1-2.9%)
> --
[quoted text clipped - 21 lines]
> > do
> > this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.