Summary
This video looks at broadcasting, which is an array behaviour when performing calculations on arrays.
EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Broadcasting
Broadcasting is an array behaviour that occurs where arrays of varying sizes are used in calculation.
The smaller array is expanded to the size of the larger array to enable calculation to occur based on relative position.
Where the values to broadcast are unclear, Excel uses #N/A.