Back to Function Index

SIGN()

Overview

SIGN() determines the sign of a number, returning -1 for negative numbers, 0 for zero, and 1 for positive numbers. This function is useful for mathematical operations, conditional logic, and data analysis where you need to determine the sign of a value.

Function Format

SIGN(number)

Return Value

SIGN() returns an integer (-1, 0, or 1)

Examples

// Negative number
SIGN(-42) = -1

// Zero
SIGN(0) = 0

// Positive number
SIGN(33) = 1

// Additional examples
SIGN(-0.5) = -1
SIGN(0.0) = 0
SIGN(100) = 1

Notes

• Important behaviors:
  • Returns -1 for negative numbers
  • Returns 0 for zero
  • Returns 1 for positive numbers
  • Works with both integers and decimals
• Common use cases include:
  • Mathematical operations
  • Conditional logic
  • Data analysis
  • Sorting and filtering
  • Direction determination
• The function is useful for:
  • Sign determination
  • Value classification
  • Mathematical calculations
  • Data processing

See Also

• ABS()
• ROUND()
• FLOOR()
• CEILING()