I would like to know the purpose of the symbol "@" in a worksheet formula or function e.g. =[@[Unit Price]]*[@[Quantity in Stock]]

Yes, as liezelbais identified, the "@" is a "structured reference" notation. But, in the current context, using the @ limits rows returned from the new "dynamic array" feature to a single row. This is used to prevent the new #Spill error

.

Implicit intersection operator: @ (Prevents #Spill error)

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

The implicit intersection operator was introduced as part of substantial upgrade to Excel's formula language to support dynamic arrays. Dynamic arrays bring significant new calculation ability and functionality to Excel.

Excel's upgraded formula language is almost identical to the old language, except that it uses the @ operator to indicate where implicit intersection could occur, whereas the old language did this silently. As a result, you may notice @'s appear in some formulas when opened in dynamic array Excel. It's important to note that your formulas will continue to calculate the same way they always have.

.

**Dynamic array formulas in non-dynamic aware Excel      (**non-365)

https://support.office.com/en-us/article/Dynamic-array-formulas-in-non-dynamic-aware-Excel-696e164e-306b-4282-ae9d-aa88f5502fa2

In September, 2018 we introduced several new functions in a family of functions called dynamic arrays. These functions will automatically populate a range, or array, and eliminate the need for legacy Ctrl+Shift+Enter (CSE) array formulas. When opening a workbook authored in dynamic array Excel in an older version of Excel, there are some compatibility considerations.

.  *  Floating Totals for Spill Ranges?

.  *  The Problem: Spill Ranges Change Size

.  *  The Solution: The Overflowing Spill Range?

.  *  The Explanation: Total Rows for Spill Ranges

.  *  Step 1: Write the Formulas

.  *  Step 2: Apply Conditional Formatting

.  *  Additional Uses

.  *  Alternate Solutions

.

@ Dynamic array formulas in Excel 365 

https://exceljet.net/dynamic-array-formulas-in-excel

Dynamic Arrays are the biggest change to Excel formulas in years. Maybe the biggest change ever. This is because Dynamic Arrays let you easily work with multiple values at the same time in a formula. For many users, it will be the first time they understand and use array formulas.

This is a big upgrade and welcome change. Dynamic Arrays will solve some really hard problems in Excel, and fundamentally change the way worksheets are designed and constructed.

. *  8 New functions:

.    *  FILTER          Filter data and return matching records

.    *  RANDARRAY Generate array of random numbers

.    *  SEQUENCE   Generate array of sequential numbers

.    *  SORT             Sort range by column

.    *  SORTBY        Sort range by another range or array

.    *  UNIQUE         Extract unique values from a list or range

.    *  XLOOKUP      Modern replacement for VLOOKUP

.    *  XMATCH        Modern replacement for the MATCH function

.  *  Spilling - one formula, many values

.  *  Spill range reference

.  *  Massive simplification of existing formulas

.  *  The power of one (formula)

.  *  Chaining functions

.  *  Native behavior

.  *  dynamic arrays work with all formulas not just functions.

.  *  With the rollout of dynamic arrays, the word "array" is going to pop up much more often

.  *  Array operations become important

.  *  New and old array formulas

.  *  “Implicit Intersection” when using the @ character

.

6 New dynamic array functions in Excel

https://exceljet.net/lessons/new-dynamic-array-functions-in-excel

In this video, we'll quickly review new Dynamic Array functions in Excel. 

With the introduction of dynamic array formulas, Excel includes 6 brand new functions that directly leverage dynamic array behavior.

.

@ Excel 2016-Excel Dynamic Arrays Straight to the Point (365) -Bill Jelen, MrExcel (download free: V2e 2019 02 05) (downloaded) Mr Excelhttps://www.mrexcel.com/products/excel-dynamic-arrays-straight-to-the-point/****

Hi Divine-Touch,

This is Liezel, an Independent Advisor and a Microsoft user like you. I’ll be glad to help you with your concern/issue.

The @ is a new notation in Excel 2010 replacing [#This Row] from Excel 2007. The at symbol is used to shorten formulas inside named tables referencing cells in the same row. More info on this thread: https://superuser.com/questions/501691/what-doe...

and also here: https://support.microsoft.com/en-us/office/usin...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

I hope this information helps. Please don't hesitate to reply if you have follow-up concerns.