How should you include a parameter or fixed variable in a cell operation or function?

Question

Accepted Answer

Enter the value of the variable / parameter into a cell that is then referenced appropriately in any cell formulae that require it

Answer

None of the above

Answer

Enter the value of the variable / parameter directly into the cell formula

Answer

Pre-process all your data to include the variable / parameter operating on it in the tabulation of the original data

Crowdly