Learn How to Use Microsoft Excel SIGN Function

Microsoft Excel SIGN Function

The main function of the Microsoft Excel SIGN function is to get the sign of a given number. That implies, with the help of the SIGN function you can able to return the sign of the number in the form of +1, -1, or 0. It should be noted that if the number is positive, the SIGN function returns 1. If the number is negative, the SIGN function returns -1. If the number is zero, SIGN returns 0. So, with the help of the SIGN function, you can able to get the sign of the number in the form of +1, -1, or 0.

Return Value of SIGN Function

The return value will be +1 if positive, -1 if negative and 0 if zero.

Syntax of SIGN Function

=SIGN(number)

Where the arguments:

• number: This is the number of which you want to get the sign.

How to Use Microsoft Excel SIGN Function?

So we know that Microsoft Excel SIGN function you can able to get the sign of a given number. That implies, with the help of the SIGN function you can able to return the sign of the number in the form of +1, -1, or 0. It should be noted that if the number is positive, the SIGN function returns 1. If the number is negative, the SIGN function returns -1. If the number is zero, SIGN returns 0. So, with the help of the SIGN function, you can able to get the sign of the number in the form of +1, -1, or 0.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel