The SIGN function returns an absolute value that has the magnitude x and the sign of y.
Format
Arguments definition
|
A real number or a function that returns a real number |
|
A real number or a function that returns a real number |
Formulation
Example
ex1) Function : SIGN(-4.7,1.2)
Result : 4.7
ex2) Function : SIGN(5.3,-6.5)
Result : -5.3
ex3) Function : SIGN(-2.5,-5.2)
Result : -2.5