Summary
This video looks at the function behaviour of lifting.
EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Lifting
Excel functions are of different types, they expect either single or multiple values.
Arguments which expect a single value are known as scalar arguments.
Lifting occurs when a scalar argument is provided with multiple values in a range or array.
Scalar lifting applies to all Excel functions.