Graph Software for Scientists and Engineers

ROUND(number,num_digits)

Rounds a number to a specified number of digits.

number is the value to round.

num_digits specifies the number of digits to which you want to round number.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
If num_digits is 0, then number is rounded to the nearest integer.
If num_digits is less than 0, then number is rounded to the left of the decimal point.

ROUND(2.15, 1) = 2.2
ROUND(2.149, 1) = 2.1
ROUND(-1.475, 2) = -1.48
ROUND(21.5, -1) = 20

See also:

MROUND
Trigonometric and General Math Functions

$
195.
00
 
RUNS ON
Windows 10,
Windows 8,
Windows 7, 2008,
Vista, XP, NT,
ME, 2003, 2000,
Windows 98, 95
Copyright © 2023-2024 ARA