@

[alliswell]

Hi everybody

I have seen @ this sign in many formulas in excel. Can anybody explain in depth where and how it is used and what for with several examples. What is the use of @ this sign

Thanks and regards

 

[MARK858]

Reading material (take your pick):

Implicit intersection: use of @ sign in Excel formulas

The tutorial covers Excel implicit intersection in full detail: what it is, how it behaves in Excel 365 and older version, what the @ symbol means in formulas and exactly how it works.

www.ablebits.com

Implicit Intersection

Implicit Intersection describes a formula behavior in Excel where many values are reduced to a single value. Typically, it happens when a range or array is passed into a formula meant to display a single result in a single cell.

exceljet.net

Implicit intersection operator: @ - Microsoft Support

Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic...

support.microsoft.com