ROUND(<num>,<dec.pts>)
This function rounds off a supplied number to the specified number of
decimal places (d.p.).
Eg. Round 66.65 to 1 d.p.
Use:
ROUND(66.65,1) = 66.7
Round 34.56784 to 2 d.p.
Use:
ROUND(34.56784,2) = 34.57
This function is also capable of rounding off to a specified number of
significant figures (s.f.). To do this, simply put a negative sign on the
second argument.
Round 32345 to the nearest thousand.
Use:
ROUND(32345,-2) = 32000
Round 3405.63475 to 6 s.f.
Use:
ROUND(3405.63475,-6) = 3405.63
See also:
INT, FLOOR, CEILING, TRUNCATE, FRAC
SIGN(<num>)
Another function designed more for programmers, returning a value of
+1, 0 or -1 depending on whether the number supplied is positive,
zero or negative.
Eg.
SIGN(-45) = -1
See also:
XPON, MANT
Note:
See also SIGN in the Complex group of functions (page 187).
176
To Next Page
Loading...
