I have google spreadsheet and a function for it to calculate some values basing on first 3 cells in a row.
My problem is that this function returns multiple values which shold be placed in multiple cells in current row.
function test(arg1, arg2, arg3) {
return [arg1 + 1, arg2 + 1, arg3 + 1];
}
For example. How i tell it to put values from array to different cells?
setValues()documentation - TheMaster