The math function allows users to create new columns of data with arithmetic operations. You can find the Arithmetic function under Tools > Calculations.
Users can add, subtract, multiply, divide, or raise exponential column values by either numbers, or by another column’s values.
To do so, simply select the column you wish to operate on (column data must be in number format), select the operation you want to execute on the column, and enter the number or column you want to use as the operand. If you select a column as the operand then operations will be done row by row.
Selecting a column of numbers, then the “+” operator, and a second column of numbers will add the two columns together row by row.
See this video for more information on using the calculations function in Gigasheet!