252
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 263).
To Next Page
Loading...
