Function Index

Sign

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.