Forum Discussion
VitorT
Sep 18, 2019Copper Contributor
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";"E...
- Sep 18, 2019
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
dakuhlke
Nov 07, 2019Copper Contributor
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.