Math/Calculation (ADD, SUBTRACT, DIVIDE, MULTIPLY)

Modified on Tue, 30 Apr at 11:58 AM

Introduction

Returns the minute component of a specific time, in numeric format.

Operator	Description
+	Add together two numeric values
-	Subtract two numeric values
*	Multiply two numeric values
/	Divide two numeric values

Sample Usage

Valid Examples	Invalid Examples
number_column + 12	Text_column + 12
number_column / number_2_column
IF(Number Column = 2, 2," ")*1

Notes

You can nest mathematical functions within other functions to create more complex formulas. Make sure to close each set of parentheses properly to avoid errors.
Mathematical equations must have a numerical input and cannot return text or date data types. To change a data type, visit here.

See Also

SUM

SUMBY

RAND

MAXBY

MINBY

ROUND

Still having issues? Contact us at support@gigasheet.com