Forum Discussion
how-to turn off the <@> symbol insert
i am programmatically inserting the following formula; =IF(RC[1]>0,RC[1],INDEX(distTTKitTKCtValue,MATCH(1,(RC[-1]=distTTKitTkCtTT)*(RC[-29]=distTTKitTKCtRMId),0))) microsoft is automatically adding...
Why it is added is here Implicit intersection operator: @ - Office Support (microsoft.com)
You may try this setting
if helps
Option turned off (not checked) still have the @ when using ".Formula"...
By the way with ".Formula2" I still have a "NAME" error until I manually go into the formula and just escape my change...