Skip to main content
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
  • 229 views
S
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
    Forum|alt.badge.img+10
    • 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
    R
    Terms & ConditionsCookie settingsAccessibility statement