Totals
The bottom line totals the columns.
Calculations
Calculated fields start with =.
Use any JavaScript operators like = PI / 2
References
Refer to any other cell with its column and row like =A3
Specify a rectangular range with syntax like =max(A3:B3)
Two ranges can be separated by a comma.
&
Use & to add words. i.e. =A3 & " hours"
Example JavaScript Math functions
- SUM(123, A3) Total of numbers in the range, or list.
- abs(X) Absolute value
- min(A1:A5) Smallest value of a range or list.
- floor(X) largest integer less than or equal to X
- random() Random number between 0 and 1
- sin(X) sine. cosine and tangent are also available.
Example Math constants
- PI 3.14
- E Euler's constant 2.718
All the functions and constants from the browser's Math library are available.
See MDN doc
Errors
If you see #Error in a field it means there was something wrong with the calculation. You can hover over the field to see an error message. Also use the Developer's Tools (F12) to see the error in the console log.