Excel Online [Office Script] - How to handle double quotes in Office Script?

[kchuphone]

Hi,
I am trying to use Office Script to update a table with formula but am not sure how to handle double quotes.
For simplicity: here is the formula I want to set all cells in column 12 to: =if(L2="sample","yes","no")

I tried the following but the double quote is not interpreted appropriately . I tried using CHAR(34) but was unsuccessful. Please kindly assist.

function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
selectedSheet.getCell(1, 12).setFormula("=if(L2="sample","yes","no");

}

 

[Micron]

In Access vba I would either use embedded single quotes but I suspect that won't work in Excel formula.
I think the approach is to just double up on the doubles?

"=if(L2=""sample"",""yes"",""no"")

 

[davesexcel]

It looks like quotes are treated differently.
I used the script recorder and came up with this.

  selectedSheet.getRange("F1").setFormulaLocal("=IF(L2=\"sample\",\"yes\",\"no\")");
//your line would be entered as this
selectedSheet.getCell(1, 12).setFormula("=if(L2=\"sample\",\"yes\",\"no\")");