Hi,
thanks for your question.
Yes, the documentation on the math/formula functionality is pretty sparse at the moment, but I’ll be working to improve that in the future.
But it’s not really difficult, and it works very similar to Excel:
A formula starts with an = and then contains a mathematical expression, in which you can also reference values from other cells, by using their cell name. Here are two basic examples:
=A1+B3
will sum the cells A1 and B3.
=AVERAGE(C3:C10)
will calculate the average value of the cells from C3 through C10.
Other math functions that can be used are
sin, sinh, arcsin, asin, arcsinh, asinh, cos, cosh, arccos, acos, arccosh, acosh, tan, tanh, arctan, atan, arctanh, atanh, sqrt, abs, ln, log, exp, floor, ceil, average, max, min, mod, pi, power, round, sum, rand_int, rand_float
So, for the total sum of a column, you would use something like
=SUM(B2:B15)
in the cell B16 for example.
Does that help?
Regards,
Tobias
