Broadcasting occurs when Excel calculates on arrays of different sizes. The smaller array is expanded to the size of the larger array to enable calculation based on relative position.

★ FREE: MODERN EXCEL FORMULAS COURSE ★
Want to get the free Modern Excel Formulas course?

Go to:
https://exceloffthegrid.com/modern-excel-formulas/

★ SAVE TIME WITH EXCEL? ★
Join our Excel Academy https://exceloffthegrid.com/

#excel #excelformula #exceltips