In Microsoft Excel, the SIGN quantity is a math and trigonometry function that returns the signal of a quantity. The SIGN function returns 1 if the quantity is constructive, zero if the quantity is 0, and -1 if the quantity is damaging.
What’s Excel Signal method?
The method for the SiGN function is SiGN(quantity). The syntax for the Signal quantity is under:
Quantity: Any actual quantity. It’s required.
How to use the Excel SIGN function
Observe the steps under to use the SGN function in Excel:
- Launch Microsoft Excel.
- Create a desk or use an present desk out of your recordsdata.
- Place the method into the cell you need to see the outcome.
- Press the enter Key.
Launch Microsoft Excel.
Create a desk or use an present desk out of your recordsdata.
Place the method =SIGN(A2) into the cell you need to see the outcome
Press the Enter key to see the outcome.
Drag the fill deal with down to show the outcome for the different numbers in the desk.
There are two different strategies to use the SIGN function.
Methodology one is to click on the fx button on the high left of the Excel worksheet.
An Insert Function dialog field will seem.
Inside the dialog field in the part, Choose a Class, choose Math and Trigonometry from the record field.
In the part Choose a Function, select the SIGN function from the record.
Then click on OK.
A Function Arguments dialog field will open.
In the Quantity entry field, enter into the entry field cell A2.
Then click on OK.
Methodology two is to click on the Formulation tab, then click on the Math and Trigonometry button in the Function Library group.
Then choose SIGN from the drop-down menu.
A Function Arguments dialog field will open.
Now learn: How to create a Bar or Circle Progress Chart in Excel
We hope this tutorial helps you perceive how to use the SIGN function in Microsoft Excel.
