Ampersands Appearing in Formulas

Justinian

Well-known Member
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

Well-known Member
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(&).
 
Last edited:

RoryA

MrExcel MVP, Moderator
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

Well-known Member
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

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

Some videos you may like

This Week's Hot Topics

Top