Microsoft Excel Functions & Formulas

Use the SIGN function to check for the sign

of a number

Excel provides the SIGN function to check the sign of a number.

This function returns 1 if the number is positive, 0 if the number is

0, and -1 if the number is negative. If the user enters text instead of

a number, the SIGN function returns the error code #VALUE!.

SIGN(number)

number: Any real number.

4

To check for the sign of a number:

1. In cells A2:A10 list numbers or text.

2. Select cells B2:B10 and type the following formula:

=IF(ISERROR(SIGN(A2)),"",SIGN(A2)).

3. Press <Ctrl+Enter>.

Note: The same result for numeric values can also be

generated by combining IF functions. Use this formula:

=IF(A1>0;1;IF(A2<0;-1;0)). ...