SIGN Function (Functions in Excel)
Value | Positive or Negative | |
10 | 1 | =SIGN(C4) |
20 | 1 | =SIGN(C5) |
0 | 0 | =SIGN(C6) |
-10 | -1 | =SIGN(C7) |
-20 | -1 | =SIGN(C8) |
What Does It Do ? |
This function tests a value to determine whether it is positive or negative. |
If the value is positive the result is 1. |
If the value is negative the result is -1. |
If the value is zero 0 the result is 0. |
Syntax |
=SIGN(CellToTest) |
The CellToTest can be a cell or a calculation. |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment