SIGN function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Returns the sign of a number

Syntax

SIGN(number) The SIGN function syntax has the following arguments:
• Number Required. Any real number.

Example

=SIGN(10)
=SIGN(4-4)
=SIGN(-0.00001)

Microsoft Support Page

https://support.microsoft.com/en-us/office/sign-function-109c932d-fcdc-4023-91f1-2dd0e916a1d8

Back to Functions