Round Function

Rounds a floating-point number to the nearest integer.

Round (number)

Parameters

Number  -  (Input, expression, Required)

If a string is passed, it is first converted to numeric form. If a non-numeric value is passed, Error is returned

Return Value

The nearest integer to the specified value.

Examples

Round (1)	Returns 1
Round (4.4)	Returns 4
Round (4.5)	Returns 5
Round (-4.4)	Returns -4
Round (“-4.5”)	Returns -5
Round (Null)	Returns Error
Round (Error)	Returns Error

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

Functions | Abs function | Atn function | Cos function | Exp function | Fix function | Int function | Log function | Max function | Min function | Rnd function | Round function | Sgn function | Sin function | Sqr function | Tan function

---

© 2004-2021 looksoftware. All rights reserved.