Help With Formula

[RestricteD]

Hello i have setup a worksheet that will help me track my ebay selling
In this i have a paypal fees listing which is based on the total pric
of the item im selling.

In G5 i have the formula =sum(C5:F5) of course the date in C5 - F
calculates the total amount. In E5 i need to enter a formula that wil
calculate my paypal fees, when i enter it i get an error about circula
formula. The method to calculate my paypal fees is G5*3.4%+0.20 whic
gives the error.If anyone has any ideas it would be gratefully recieve
and used.


Thanks In Advanc

 

[gary brown]

Change
G5*3.4%+0.20
to
(C5+D5+F5)*3.4%+0.20

I believe that you are not charged PayPal fees on your
PayPal fees. This is what your current formula is doing
and why you are getting an error. Changing the formula as
I just showed will calculate fees of 3.4% plus $.20 on
your sales, assuming C5, D5 and F5 are components of your
sales such as C5=cost, D5 = shipping and handling and F5
being your personal mark-up.
HTH,
Gary Brown