MathLevel: IntermediateAvailable in: Excel 2007+

SIGN returns 1 for positive, −1 for negative and 0 for zero — neat for direction arrows and counting gains vs losses.

Syntax

=SIGN(number)

Examples

Example 1

=CHOOSE(SIGN(C2-B2)+2, "▼", "–", "▲")

Up/down/flat arrow versus last month.

Example 2

=SUMPRODUCT(--(SIGN(D2:D100)=1))

Count of positive changes.

Related functions

ABS · IF

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.