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.
Showing posts with label excel sign formula. Show all posts
Showing posts with label excel sign formula. Show all posts
Saturday, January 12, 2013
Subscribe to:
Posts (Atom)