# Revision history [back]

You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1")


You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1")
sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1"))


Edit: Sorry - forgot a )

You need to set it as a formula:

sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1"))
sheet.getCellByPosition(3,16).setFormula("=IF(B17="";"";1)")


Edit: Sorry - forgot a ) - this time for sure