Forum Discussion
Can you use the formula in one cell as a variable in formulas in other cells?
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 pr...
Yes, you could put those values in separate cells, then name the cells using the name box in the top left of the worksheet (or use name manager under formulas tab). So, if you named the cells PPFeeVar and PPFeeFix (or whatever your preference), then your formula is:
=(N9-K9)-((N9*PPFeeVar)+PPFeeFix)
If you have lambda feature (or if/when you get it), then you could set up a lambda to do the calculation and just pass the sell price to your lambda formula (I don't have that feature, so can't tell you how to set it up).
=(N9-K9)-((N9*PPFeeVar)+PPFeeFix)
If you have lambda feature (or if/when you get it), then you could set up a lambda to do the calculation and just pass the sell price to your lambda formula (I don't have that feature, so can't tell you how to set it up).