ROUND, ROUNDUP and ROUNDDOWN functions.Rounding of numbers and rounding up and down.(Microsoft Excel)

Japanese version.

ROUND series functions round numbers to the specified number of digits.

How it works

ROUND function

=ROUND(number,num_digits)
NameOmissionExplanation
numberRequired fieldsSpecify the number to be rounded.
num_digitsRequired fieldsSpecifies the number of digits to be rounded.
If it is a positive number, it is rounded to the negative digits; if it is a negative number, it is rounded to the positive digits.

ROUNDUP function

=ROUNDUP(number,num_digits)
NameOmissionExplanation
numberRequired fieldsSpecify the number to be rounded up.
num_digitsRequired fieldsSpecifies the number of digits of the result to be rounded up.
If it is a positive number, it is rounded up to a negative digit; if it is a negative number, it is rounded up to a positive digit.

ROUNDDOWN function

=ROUNDDOWN(number,num_digits)
NameOmissionExplanation
numberRequired fieldsSpecify the number to be rounded down.
num_digitsRequired fieldsSpecifies the number of digits of the result to be rounded down.
If it is a positive number, it is rounded up to a negative digit; if it is a negative number, it is rounded down to a positive digit.

Argument 2: Number of digits

The following, followed by 3 and -3 and so on.

SpecifyNumber of digits
-2100
-110
01
11/10
21/100

Demonstrate

The following is an example of the pattern of values given for the arguments and the results.

Spill

If you specify range of cells in string, it will be a Spill.

---

Links

Microsoft Excel Functions Math & Trig