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?

  • 4 July 2022
  • 1 reply
  • 18 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

Userlevel 3
Badge +7

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

Reply