Sign (Returns the sign of a number for Mathematical Purpose)

What Does It Do?

This function tests a value to determine whether it is positive or negative.

If the value is positive the result is 1.

If the value is negative the result is -1.

If the value is zero 0 the result is 0.

Syntax

=SIGN(CellToTest)

The CellToTest can be a cell or a calculation.

Formatting

No special formatting is needed.