Help with calculation

[TLAngelo]

I am creating a simple spreadsheet to calculate my earnings from an online
business I have. I am having trouble with calculating my Paypal fees which
are 2.9% + .30 cents for each transaction. So I tried to take the selling
price plus the shipping price and multiply it times the 2.9% plus .30 cents,
but it won't work. My paypal fee of .30 cents is in H4 and the 2.9% is in
H5, the selling price is in column E and the shipping is in column K, so this
is what I tried, @sum(e8+k8*h5+h4). It returns $8.37... I don't think that's
right since the selling price was $8.00 and the shipping was 2.50!

It's probably a dumb error, but I can't figure it out!

Thanks in advance for your help!

Tania

 

[smartin]

I am creating a simple spreadsheet to calculate my earnings from an online
business I have. I am having trouble with calculating my Paypal fees which
are 2.9% + .30 cents for each transaction. So I tried to take the selling
price plus the shipping price and multiply it times the 2.9% plus .30 cents,
but it won't work. My paypal fee of .30 cents is in H4 and the 2.9% is in
H5, the selling price is in column E and the shipping is in column K, so this
is what I tried, @sum(e8+k8*h5+h4). It returns $8.37... I don't think that's
right since the selling price was $8.00 and the shipping was 2.50!

It's probably a dumb error, but I can't figure it out!

Thanks in advance for your help!

Tania

How about
=(E8+K8)*H5+H4

http://en.wikipedia.org/wiki/Order_of_operations

 

[Gord Dibben]

Break it down into chunks.

=E8+K8 returns 10.50

=(E8+K8)*.H5 returns .3045

=((E8+K8)*H5)+H4 returns .6045 which I believe are the fees.


Gord Dibben MS Excel MVP