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.


OperatorDescription

+

Add together two numeric values
-Subtract two numeric values
*Multiply two numeric values
/Divide two numeric values


Sample Usage

Valid ExamplesInvalid 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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article