Can you use the formula in one cell as a variable in formulas in other cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-2509931%22%20slang%3D%22en-US%22%3ECan%20you%20use%20the%20formula%20in%20one%20cell%20as%20a%20variable%20in%20formulas%20in%20other%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2509931%22%20slang%3D%22en-US%22%3E%3CP%3EPayPal%20is%20changing%20their%20fee%20calculation%20(was%202.9%25%2B%240.30%2C%20becoming%202.89%25%2B%240.49)%3CBR%20%2F%3E%3CBR%20%2F%3EAside%20from%20the%20fact%20that%20it%20seriously%20eats%20into%20my%20profit%20margin%20%3CLI-EMOJI%20id%3D%22lia_angry-face%22%20title%3D%22%3Aangry_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%20%26nbsp%3BI%20need%20to%20adjust%20my%20spreadsheet%20with%20all%20my%20product%20costs%20%26amp%3B%20pricing.%26nbsp%3B%20As%20is%2C%20I%20have%20the%20fee%20deducted%20from%20each%20item%20individually%2C%20but%20I%20was%20wondering%20if%20there's%20a%20way%20to%20set%20the%20fee%20formula%20in%20a%20single%20cell%2C%20then%20reference%20that%20cell%20in%20the%20formula%20in%20all%20other%20cells.%26nbsp%3B%20That%20way%2C%20if%20the%20fee%20changes%20again%2C%20I%20only%20have%20to%20change%20that%20one%20cell%20with%20the%20fee%20formula%20instead%20of%20changing%20every%20profit%20margin%20cell%20across%20the%20entire%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EHere's%20my%20standard%20formula%20for%20calculating%20profit%20margin%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3D(N9-K9)-((N9*0.029)%2B0.3)%3CBR%20%2F%3E%3CBR%20%2F%3EN%3Dsell%20price%3C%2FP%3E%3CP%3EK%3Dmy%20cost%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2509931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2510015%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20you%20use%20the%20formula%20in%20one%20cell%20as%20a%20variable%20in%20formulas%20in%20other%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510015%22%20slang%3D%22en-US%22%3EYes%2C%20you%20could%20put%20those%20values%20in%20separate%20cells%2C%20then%20name%20the%20cells%20using%20the%20name%20box%20in%20the%20top%20left%20of%20the%20worksheet%20(or%20use%20name%20manager%20under%20formulas%20tab).%20So%2C%20if%20you%20named%20the%20cells%20PPFeeVar%20and%20PPFeeFix%20(or%20whatever%20your%20preference)%2C%20then%20your%20formula%20is%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3D(N9-K9)-((N9*PPFeeVar)%2BPPFeeFix)%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20have%20lambda%20feature%20(or%20if%2Fwhen%20you%20get%20it)%2C%20then%20you%20could%20set%20up%20a%20lambda%20to%20do%20the%20calculation%20and%20just%20pass%20the%20sell%20price%20to%20your%20lambda%20formula%20(I%20don't%20have%20that%20feature%2C%20so%20can't%20tell%20you%20how%20to%20set%20it%20up).%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply
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).