Forum Discussion
Why do I Get an "@" automatically at the beginning of each formula?
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))
In opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2
As for @ in most cases you may safely remove it or simply ignore, more about this is here https://support.office.com/en-us/article/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
7 Replies
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.
It looks like formula was created in Excel with Dynamic Arrays, and you use it in pre-DA Excel. Is that the case?
SergeiBaklan 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
In opposite, Excel with Dynamic Arrays is beta https://support.office.com/en-us/article/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2
As for @ in most cases you may safely remove it or simply ignore, more about this is here https://support.office.com/en-us/article/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
- Please, has anyone seen something like this? thank you
