Paypal Fees Excel Help!

RachyD_3

Is someone out there good with Excel? This is driving me crazy!

I'm trying to create a column that shows the Paypal fees for each item sold.
Column F shows the value of the sold item. Sometimes this = 0 though when the row is recording a value spent.
I can't figure out how to get a cell to add 3.9% +0.2 to the value in F? EXCEPT when F?=0

I tried =IF(F3>0, [*0.039+0.2], ["0"]) and get an error message saying 'the name entered isn't valid'

Can anyone point me in the right direction?

I_wanna_live_for_free

Hi I've just gone to my spreadsheet and my formula is

=((F10+M10)*0.034)+0.2

F is the sold price and M is the postage I charge.

Hope this helps...

the_lunatic_is_in_my_head

=SUM(F1/100)*3.4+0.2

If F is zero then the formula will also show zero so an exception isn't required.

No_Eye_Deer

I use =SUM(M20:N20)*(0.034)+(0.2)
M20 is ebay item sold price N20 is postage. I separate them as M20 can be used to calculate ebay fees

Just had a little play, you could try something like
=IF(F52=0, 0, SUM(F52)*0.034+0.2)

the-mango

I have a spreadsheet all set up for all the fees etc if you want me to send it to you? Just send me a pm.

Strapped

RachyD wrote: »

Is someone out there good with Excel? This is driving me crazy!

I'm trying to create a column that shows the Paypal fees for each item sold.
Column F shows the value of the sold item. Sometimes this = 0 though when the row is recording a value spent.
I can't figure out how to get a cell to add 3.9% +0.2 to the value in F? EXCEPT when F?=0

I tried =IF(F3>0, [*0.039+0.2], ["0"]) and get an error message saying 'the name entered isn't valid'

Can anyone point me in the right direction?

You have missed out the cell reference for the true condition; it should be F3*0.034+0.2 and also, you don't need the square brackets, or the " " around zero for the false condition.

I'm on OpenOffice so the syntax is slightly different but hope you get my gist.

Try =IF(F3>0,F3*0.039+0.2,0)

Although note that it's bad practice to put numbers in a formula. Better to use variables and then reference those variables (eg name two cells at the top of the sheet as "PayPal percentage" and "PayPal fixed amount per transaction" and use these names in the equation instead of 0.034 and 0.2 - then if PayPal change their charging structure, you only have to update two cells in the spreadsheet and not wherever there is a formula.

RachyD_3

Thanks everyone - off to try them all now!