Re: Reverse Fees Linear Formula
- From: "David Biddulph" <groups [at] biddulph.org.uk>
- Date: Tue, 27 May 2008 20:33:25 +0100
=(A2+0.3)/(1-2.9%)
--
David Biddulph
"Roddy" <Roddy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:076DD10C-174B-4022-9F65-77DE0FF7BAEC@xxxxxxxxxxxxxxxx
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?
--
In God''s Harmony
.
- Follow-Ups:
- Re: Reverse Fees Linear Formula
- From: Roddy
- Re: Reverse Fees Linear Formula
- Prev by Date: Right-click --> "Open as read only" option for a .xls from Windows...
- Next by Date: Re: vlookup more than 2 range
- Previous by thread: Right-click --> "Open as read only" option for a .xls from Windows...
- Next by thread: Re: Reverse Fees Linear Formula
- Index(es):
Relevant Pages
|
