The excel "Sign" formula indicates if the value of a cell is positive, negative, or zero. The Sign formula does this by displaying a '1' for a positive value higher than zero. Displays a '-1' for negative values below zero. Also displays '0' for values equal to zero. So, =SIGN(2) will display a value of 1. =SIGN(0) will display a value of 0. Finally =SIGN(-7) will display a value of -1.
Saturday, January 12, 2013
Subscribe to:
Post Comments (Atom)
www.cineclouds.com. Powered by Blogger.
Popular Posts
Blog Archive
-
▼
2013
(40)
-
▼
January
(16)
- Combine formula
- PERMUT formula
- Random number formula
- Random number genarator formula for specific range
- PI Area formula
- PI diameter formula
- PI circumference formula
- PI formula
- SIGN formula
- Truncate to zero decimal place formula
- Truncate minus 2 decimal places
- Truncate back minus 1 decimal place
- Truncate to 1 decimal place formula
- Convert Number to Words (Indian Format)
- Truncate to 2 decimal places formula
- RAND formula rounded to 0 decimal place
-
▼
January
(16)
0 comments:
Post a Comment