And then there is the Round function:
ROUND(X, N)
Description
Returns X rounded to the number of decimal places specified by N (when N is positive); it returns X rounded to a whole number when N is negative.
Parameters
X A numeric value
N the number of decimal places or whole numbers, between -15 and 15
Example
ROUND(PI, 2) = 3.14
ROUND(COS(60), 2) = -0.95
ROUND(1234.5678, -2) = 1200
Previous Topic
Index
