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.

Example

Sign(-3)

  • Returns -1

  • All negative numbers return the result -1

Sign(3745)

  • Returns 1

  • All positive numbers return 1.

Last updated

Was this helpful?