
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:
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:
Note:
See also
SIGN
in the Complex