Custom functions can be tailored to specific needs Using variables in custom functions streamlines workflows and reduces errors Creating Formulas in Excel with LAMBDA Watch this video on YouTube.

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Excel Solver employs the generalized reduced gradient algorithm 7; a discussion of the mathematical formalism is beyond the scope of this protocol but can be found elsewhere 8.