Implicit Intersection

Implicit Intersection describes a formula behavior in Excel where many values are reduced to a single value.

In other words, entering a formula with control + shift + enter disables implicit intersection.

For example, if same formula above is entered in cell D9, the result is #VALUE.

This makes it possible to create formulas that manipulate multiple values input as ranges.

This @ symbol is called the implicit intersection operator, and itdisablesarray behavior.

In other words, it tells Excel you want asinglevalue.

This behavior only occurs in dynamic array versions of Excel.