Forum Discussion

kent_culpepper's avatar
kent_culpepper
Copper Contributor
Apr 06, 2021

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...
excel
Formulas and Functions
Macros and VBA
  • CodeKiller's avatar
    CodeKiller
    Copper Contributor
    May 28, 2025

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

  • kent_culpepper's avatar
    kent_culpepper
    Copper Contributor
    Apr 06, 2021

    SergeiBaklan 

    Thanks for reply. Yes, I read that article before posting. There was another similar post that suggested the turning off of an option but it was not obvious to me which option. I will go ahead and try that setting.

     

    In the meantime, I found a work-around that seemed to work.. which was using the "FILTER" variation of the formula which, yes still adds the @ symbol. But actually returns the expected result, instead of an error. So, its all very interesting.

     

    Thanks!

Resources