SOLVED
Home

Why do I Get an "@" automatically at the beginning of each formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-861624%22%20slang%3D%22en-US%22%3EWhy%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861624%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%20The%20formula%20works%20perfectly%20but%20it%20automatically%20creates%20the%20%22%40%22%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3D%40IF(ISBLANK(H265)%3BIF(%40BDS(%24C265%3BI%241%3B%22Dir%3DV%22%3B%22EndCol%3D2%22%3B%22EndRow%3D1%22%3B%22cols%3D2%3Brows%3D1%22)%3D%22%23N%2FA%20Field%20Not%20Applicable%22%3B%22-%22%3BBDS(%24C265%3BI%241%3B%22Dir%3DV%22%3B%22EndCol%3D2%22%3B%22EndRow%3D1%22%3B%22cols%3D2%3Brows%3D1%22))%3BBDP(%24H265%3B%24B%241))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861635%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861635%22%20slang%3D%22en-US%22%3EPlease%2C%20has%20anyone%20seen%20something%20like%20this%3F%20thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861636%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411282%22%20target%3D%22_blank%22%3E%40VitorT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20formula%20was%20created%20in%20Excel%20with%20Dynamic%20Arrays%2C%20and%20you%20use%20it%20in%20pre-DA%20Excel.%20Is%20that%20the%20case%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861642%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20prompt%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20a%20mixed%20formula%20with%20external%20(Bloomberg%20excel%20add-in)%20and%20excel%20forulas%20in%20it%20-%20arrays%20I%20guess%3F%3CBR%20%2F%3Efor%20the%20Pre-DA%20thing%2C%20does%20this%20means%20this%20is%20pre-release%2C%20beta%20version%20testing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861669%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411282%22%20target%3D%22_blank%22%3E%40VitorT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20opposite%2C%20Excel%20with%20Dynamic%20Arrays%20is%20beta%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%26nbsp%3B%40%20in%20most%20cases%20you%20may%20safely%20remove%20it%20or%20simply%20ignore%2C%20more%20about%20this%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fimplicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fimplicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861711%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861711%22%20slang%3D%22en-US%22%3ETks%20Sergei%2C%20those%20links%20helped%20a%20lot.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20all%2C%20I%20rolled%20back%20my%20Office%20to%20Pre-DA%20by%20going%20to%20File%26gt%3BAccount%26gt%3Boffice%20Insider%26gt%3Bunsubscribe%3CBR%20%2F%3E%3CBR%20%2F%3Ethen%20I%20updated%20Office%3CBR%20%2F%3E%3CBR%20%2F%3Eand%20Lastly%20I%20Removed%20and%20reinstalled%20my%20Excel%20Add-in%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861743%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411282%22%20target%3D%22_blank%22%3E%40VitorT%3C%2FA%3E%26nbsp%3B%2C%20I%20see%2C%20so%20you%20created%20your%20formulas%20in%20Insiders%20version%20and%20now%20see%20in%20regular%20one.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-993334%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20do%20I%20Get%20an%20%22%40%22%20automatically%20at%20the%20beginning%20of%20each%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-993334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411282%22%20target%3D%22_blank%22%3E%40VitorT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Vitor%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20issue%20and%20it%20was%20breaking%20my%20formula%20functions.%20See%20post%20below.%20However%20I%20noticed%20that%20Excel%20stopped%20automatically%20inserting%20the%20%22%40%22%20symbol%20without%20any%20new%20updates%20that%20I%20know%20of.%20Still%20version%201910.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FImplicit-intersection-operator-breaking-my-formulas%2Fm-p%2F928020%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FImplicit-intersection-operator-breaking-my-formulas%2Fm-p%2F928020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
VitorT
New Contributor

Why do I Get an "@" automatically at the beginning of each formula? The formula works perfectly but it automatically creates the "@":


=@IF(ISBLANK(H265);IF(@BDS($C265;I$1;"Dir=V";"EndCol=2";"EndRow=1";"cols=2;rows=1")="#N/A Field Not Applicable";"-";BDS($C265;I$1;"Dir=V";"EndCol=2";"EndRow=1";"cols=2;rows=1"));BDP($H265;$B$1))

7 Replies
Please, has anyone seen something like this? thank you

@VitorT 

It looks like formula was created in Excel with Dynamic Arrays, and you use it in pre-DA Excel. Is that the case?

@Sergei Baklan Thanks for the prompt response.

 

It is a mixed formula with external (Bloomberg excel add-in) and excel forulas in it - arrays I guess?
for the Pre-DA thing, does this means this is pre-release, beta version testing?

 

Thank you

Tks Sergei, those links helped a lot.

In all, I rolled back my Office to Pre-DA by going to File>Account>office Insider>unsubscribe

then I updated Office

and Lastly I Removed and reinstalled my Excel Add-in

@VitorT , I see, so you created your formulas in Insiders version and now see in regular one. 

@VitorT 

 

Hi Vitor, 

 

I have the same issue and it was breaking my formula functions. See post below. However I noticed that Excel stopped automatically inserting the "@" symbol without any new updates that I know of. Still version 1910. 

 

https://techcommunity.microsoft.com/t5/Excel/Implicit-intersection-operator-breaking-my-formulas/m-p... 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies