MATH
Formulas / MATHPerform common mathematical calculations.
=
Examples
Need help with Formulas?
Summary
The MATH function in Sourcetable makes calculations easy by allowing users to quickly add, divide, multiply, and subtract numeric values. The AutoSum feature simplifies the process even further by automatically totaling a series of values.
- The MATH function can perform addition, subtraction, multiplication, division, and other operations.
- The MATH function can be used to calculate results for complex equations and formulas.
- The MATH function can be used to calculate averages, exponents, and other mathematical operations.
- The MATH function can also be used to calculate the square root and other roots of a number.
- The MATH function can also be used to calculate logarithms and trigonometric functions.
Frequently Asked Questions
What is the MATH function?
The MATH function is a Sourcetable feature that can be used to automate calculations or to mimic the behavior of a calculator. It can be used to sum a series of values, copy formulas into adjacent cells, and to replicate calculator keys.
What tasks can be completed with the MATH function?
- Sum a series of values
- Copy formulas into adjacent cells
- Mimic calculator keys
How do I use the MATH function?
To use the MATH function, select the cell in which you would like to enter the desired formula. Then press the ‘fx’ button to the left of the formula bar to open the INSERT FUNCTION dialog box. Select the desired function from the list and follow the on-screen instructions.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV