fbpx
Select Page

Returns the sign of a number: -1 if negative, 1 if positive, 0 if zero.

Usage

Sign(<number>)

number (required) The number or column of numbers to return the sign of.

Examples

Sign(-3)
  • Returns -1
  • All negative numbers return the result -1
Sign(3745)
  • Returns 1
  • All positive number return 1.

More About Math Functions

These functions return well-known mathematical constants or implement common arithmetic functions.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.