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 number return 1.

Was this page helpful?
Yes No