Inserting a formula in Excel

[astog]

Good afternoon,

I am using the MS Excel VBO to set a cell value in Excel. I would like to enter an "IF" formula, =IF(AI2>AH2,"Yes","_"), but it will not allow me to because of the double quotes. Can anyone help me out on how I would do this using Blue Prism. Thanks in advance for any help with this.

 

[renaldooo]

Do a macro file, and type this code into. After that MS Excel VBO -> Run macro action

Worksheets.Range("X" & i).Formula = "=IFERROR(IF(AI2>AH2,"YES",""error"")"