Rouge Excel Formula

[chet645]

All, I use a fairly sophisticated financial model to project cash flow for investments, and I've recently noticed that somehow the "@" symbol has shown up in a significant amount of the formulas (80%+) in the workbook. Calculations in the workbook seem unaffected by the addition. I thought I would see if anyone has experienced something similar and what the cause might be. Would be great if there is an easy way to remove the symbol as well.

Here is an example: $D740*@IF($E740="Pro Rata @ Deliveries",N$563,IF(AND($F740<=@INDEX_MONTH,@INDEX_MONTH<=$G740),IF($I740="Manual (%)",Assumptions!AM226,IF($I740="Manual ($)",Assumptions!AM226/Assumptions!$E226,IF($I740="Ratably",1/$H740,IF($I740="S Curve",INDEX(TABLE_SCURVE_1,$H740+1,(YEAR(@INDEX_MONTH)-YEAR($F740))*12+(MONTH(@INDEX_MONTH)-MONTH($F740))+2)))))))

Thanks in advance for your help. Really appreciate this community.

Regards,

Chet

 

[fhqwgads]

excel's formula language changed in a recentish update and automatically changed everyone's formulas
supposedly your formulas should work the same but some people are reporting that the @ is breaking their workbooks. the best way to remove it seems to be to ctrl H replace the @ symbols with nothing
i dont know exactly how the @ symbol works in formulas and trying to search anything related to it is impossible

 

[DRSteele]

It seems to be a glitch. This article is all I could find of any relevance - the first part went on about Tables, but the latter part insinuates that a problem arose after the new calculation engine was included in 365, especially Insider with the dynamic array functionality. Just replace all the @ with nothing.

Believe it or not, the @ symbol was the original way to begin a formula in early spreadsheet software but was long ago replaced by the = sign. The @ symbol has risen like a phoenix, seemingly.

 

[fhqwgads]

finally found relevant info

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.

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.office.com

 

[chet645]

Thanks, all. I feel a little better now that I know what is going on. My workbook seems unaffected, so I won't worry about it for now.