Jul 02 2021 01:55 AM
PayPal is changing their fee calculation (was 2.9%+$0.30, becoming 2.89%+$0.49)
Aside from the fact that it seriously eats into my profit margin >:( I need to adjust my spreadsheet with all my product costs & pricing. As is, I have the fee deducted from each item individually, but I was wondering if there's a way to set the fee formula in a single cell, then reference that cell in the formula in all other cells. That way, if the fee changes again, I only have to change that one cell with the fee formula instead of changing every profit margin cell across the entire sheet.
Here's my standard formula for calculating profit margin:
=(N9-K9)-((N9*0.029)+0.3)
N=sell price
K=my cost
Jul 02 2021 02:34 AM