The square brackets are used for structured references, which make it easier to reference data in named tables (which you can create by going to Insert → Table). The @ is 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. The inner square brackets are only needed because your bar ...
In Excel 365 builds that already have the new Dynamic Array formulas, all formulas are treated as array formulas by default. The @ sign is used to prevent the new default array behavior of a function if it is not wanted in that particular formula. If the same workbook is opened in a non DA version of Excel, it will not be visible. If the @ sign is entered into non DA versions of Excel, it will ...
microsoft excel - @ in the beginning of a formula - Super User
How to add a line break to the output of a formula in Excel?
How do you write an Excel formula that will paste a specific value in a ...
Excel table inserting old formula in new rows. How can I reset to the ...
Is there an Excel formula to identify special characters in a cell?
Excel Formula To Get Last Non Zero or Not Blank Value in Column And ...
Is there a function in Excel that will allow me to actually evaluate that string as if it were a formula? This would be helpful for another project where I would like to be able to write 'dynamic' formulas in Excel.