I have an excel spreadsheet with several PayPal payements in a column. I want account for the paypal fee; which is 2.9%+.30cents per transaction. How do I do that?


Assuming your data is in cell A1, enter the following formula in cell B1:

= (A1 * .029) + .3

This will put the paypal fee in the cell B1.

If you want to show the total amount of the transaction after paypal takes its fee, use this formula:

= A1 - ((A1 * .029) + .3)
| improve this answer | |

In a new column you could have a formula like:

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.