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.