In Microsoft Excel, the SIGN number is a math and trigonometry function that returns the sign of a number. The SIGN function returns 1 if the number is positive, zero if the number is 0, and -1 if the number is negative.
What is Excel Sign formula?
The formula for the SiGN function is SiGN(number). The syntax for the Sign number is below:
Number: Any real number. It is required.
How to use the Excel SIGN function
Follow the steps below to use the SGN function in Excel:
- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the enter Key.
Launch Microsoft Excel.
Create a table or use an existing table from your files.
Place the formula =SIGN(A2) into the cell you want to see the result
Press the Enter key to see the result.
Drag the fill handle down to display the result for the other numbers in the table.
There are two other methods to use the SIGN function.
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Math and Trigonometry from the list box.
In the section Select a Function, choose the SIGN function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Number entry box, input into the entry box cell A2.
Then click OK.
Method two is to click the Formulas tab, then click the Math and Trigonometry button in the Function Library group.
Then select SIGN from the drop-down menu.
A Function Arguments dialog box will open.
Now read: How to create a Bar or Circle Progress Chart in Excel
We hope this tutorial helps you understand how to use the SIGN function in Microsoft Excel.
