next up previous contents index
Next: ROW Up: A. Function Reference Previous: RMS   Contents   Index


ROUND

Syntax: ROUND(X, N)

X = a numeric value
N = the number of decimal places or whole numbers, between -15 and 15

ROUND 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.

Examples:

ROUND(PI(), 2) = 3.14

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

ROUND(1234.5678, -2) = 1200

Excel function: ROUND


next up previous contents index
Next: ROW Up: A. Function Reference Previous: RMS   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003