Hi all, I'm trying to write an Office Script within Excel. I have a string parameter setting_config I have defined, and I want to use it within an IF statement, ie. IF setting_config = "Y", then "Y" else blank.
It appears that a regular IF formula in Office Script where the IF statement is based upon a cell looks something like this:
selectedSheet.getRange("B4").setFormulaLocal("=IF(A4=\"y\",\"y\",\"n\")");
Does anyone know how I should replace the A4 with my parameter setting_config?
Thank you!
It appears that a regular IF formula in Office Script where the IF statement is based upon a cell looks something like this:
selectedSheet.getRange("B4").setFormulaLocal("=IF(A4=\"y\",\"y\",\"n\")");
Does anyone know how I should replace the A4 with my parameter setting_config?
Thank you!