ROUND(X, N)

 

Description

This function returns X rounded to the number of decimal places specified by N if N is positive; otherwise, it returns X rounded to the nearest integer number of N significant digits.

 

Parameters

 

X

A numeric value.

 

N

The number of decimal places or whole numbers between -15 and 15.

 

Examples

 

ROUND(PI(), 2) = 3.14

 

ROUND(COS(60), 2) = -0.95

 

ROUND(1234.5678, -2) = 1200