In the example show, cells F5:F7 contain this multi-cell array formula: The first range results in an array with 3 items. The second range results in an array with only 1 item. Broadcasting occurs when the second array is resized to contain 3 items, {2;2;2}, to match the dimensions of the first array {2;4;6}: Notice Excel simply repeats the value 2 during the operation. Broadcasting only occurs when the value to copy is unambiguous. When it’s not clear what value to copy, Excel will use #N/A. For example, if we multiply {2;4;6;8}*{2;2}, the second array needs to be re-sized, but because it’s not possible to know what values to use for third and fourth elements, Excel fills with #N/A: Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
