that formula does come out correct but it still displays the $0.30
and yes I messed up, I am trying to make a spreadsheet for selling items on Ebay and I am trying to get the paypal fee. their fee is %2.9 of the total +$.30.
so I want to get %2.9 of a number and then add $.30 to that. sorry I confused myself.
This is what I have:
$ item sold for - C2
$ shipping - D2
buyer payment total - E2 formula is "=SUM(C2:D2)"
paypal fee - J2 formula is "=E2*0.029+0.3"
and this setup creates the correct fee but If I copy the formula down to the cells below it is displays $0.30 into every cell.
Bookmarks