GAS:setFormula括号或引号丢失了吗? [英] GAS : setFormula parenthesis or quotes missing?

问题描述

如果我想把L2 = M2放进去，就行了:

If I want to put L2 = M2 , this works :

for(var j = 2; j< = sheetold.getLastRow(); j ++){

for (var j = 2; j<=sheetold.getLastRow(); j++){

sheetold.getRange(["L"] + [(j)]).setFormula('= ["M"] + [(j)]');

sheetold.getRange(["L"]+[(j)]).setFormula('=["M"]+[(j)]');

但是，如果我想要以下L2 =(M2/P2)，则会被阻止(可能是括号或引号放在我的那一边?):

But if I want the following L2 = (M2/P2), I am blocked (possibly some parenthesis or quotes misplaced on my part ??) :

sheetold.getRange(["L"] + [(j)]).setFormula('= ["M"] + [(j)]/["P"] + [(j)]');

sheetold.getRange(["L"]+[(j)]).setFormula('=["M"]+[(j)]/["P"]+[(j)]');

预先感谢;)

推荐答案

您不需要那么多的方括号"[]"或括号.

You don't need so many square brackets "[]" or parentheses.

尝试一下:

for (var j = 2; j<=sheetold.getLastRow(); j++){
  sheetold.getRange("L"+j).setFormula('=(M'+j+'\/P'+j+')'); }

这篇关于GAS:setFormula括号或引号丢失了吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！