Ampersands Appearing in Formulas

[Justinian]

I have recently been experiencing something I have not seen in my fifteen years of working with Excel: @ signs are appearing in my workbooks formulas directly after the = sign. For example:

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=@IF(COUNTA(C6:AG6)=0,"",IF(COUNTIF(C6:AG6,"?*"),SUM(IF(LEFT(C6:AG6&"|",2)="S|",8,IF(1-(C6:AG6=""),IF(LEFT(C6:AG6)="S",REPLACE(C6:AG6,1,1,"")+0))))))

Why are ampersands being inserted into my formulas?
[/FONT]

 

[jmacleary]

Hi there. The @ is new notation in Excel 2010 and onwards replacing [#This Row] from Excel 2007. It is used to shorten formulas inside named tables referencing cells in the same row. It is also (I think) a compatibility option with lotus 123.

PS Its an 'at symbol' not ampersand(&).

 

[RoryA]

When the @ symbol appears before a function, it's because the function uses implicit intersection, and this doesn't fit with the new dynamic array formulas (@ is actually a replacement for the briefly introduced SINGLE function).

 

[Justinian]

Weird. I have been using this version of Excel for a few months now but only in the last two or three weeks did these @ symbols start appearing. Why is that?

 

[RoryA]

It's new functionality and it gets rolled out gradually, depending on what update channel you're on.

 

[Justinian]

Ok, thank you.

 

[Peter_SSs]

Some more information here too.

 

[Justinian]

Some more information here too.

Thank you.