calculate

allows performing math operations in cells

void calculate(string math, [string page] );

math	string	the operation to be calculated
page	string	optional, the sheet to call the math operation from

Example

// sums up the value of the cell A1 from the current sheet
// and the value of the cell A1 from Sheet1
$$("ssheet").calculate("SUM(A1, Sheet1!A1)");
 
// sums up the values of cells A1 and B1 from Sheet2
$$("ssheet").calculate("SUM(A1, B1)", "Sheet2")

Related samples

Calculate API

Details

You can omit the "=" sign in the beginning of the calculated expression: SUM(A1, Sheet1!A1) works the same as =SUM(A1, Sheet1!A1).