Skip to main content
S
sangam 7313
Cadet | Tier 2
July 4, 2022
Question

I am setting cell formula using excel advance package, but my cell formula has $ in it and its showing error in automation anywhere. How to set cell formula using $ in excel formulas?

  • July 4, 2022
  • 1 reply
  • 252 views
I am setting cell formula using excel advance package, but my cell formula has $ in it and its showing error in automation anywhere. How to set cell formula using $ in excel formulas?

    1 reply

    Ashwin A.K
    Ashwin A.K
    Navigator | Tier 3
    July 8, 2022

    Hi @sangam nath​ ,

     

    Dollar signs are treated as variable initializations, so to use dollar signs, you have to escape it by adding another one i.e.

     

    =$$A$$1+A2

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
      Terms & ConditionsAccessibility statement