The SIGN function accepts a number. If the number is negative, SIGN returns a negative one. If the number is zero, SIGN returns a zero. If the number is positive, SIGN returns a positive one.
The SIGN function has the following format:
SIGN(number)
The SIGN function accepts the following parameter:
number (number)
The SIGN function returns a number: -1, 0, or +1.
Return_value=SIGN(-40)
Return_value=-1
Return_value=SIGN(0)
Return_value=0
Return_value=SIGN(999)
Return_value=1
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |