Round, Roundup, RoundDown, MRound Formula in MS Excel

 Round, Roundup, RoundDown, MRound Formula in MS Excel

The ROUND, ROUNDUP, ROUNDDOWN, and MROUND formulas in MS Excel are used to round numbers to a specified number of decimal places or to the nearest multiple of a specified number.

The syntax of the ROUND formula is as follows:

ROUND(number, [num_digits])

Where:

• number: The number to be rounded.
• [num_digits]: Optional. The number of digits to which you want to round the number. If this argument is omitted, the number is rounded to 0 decimal places.

For example, the following formula would round the number 12.3456 to 2 decimal places:

=ROUND(12.3456, 2)

The syntax of the ROUNDUP formula is as follows:

ROUNDUP(number, [num_digits])

Where:

• number: The number to be rounded.
• [num_digits]: Optional. The number of digits to which you want to round the number. If this argument is omitted, the number is rounded to 0 decimal places.

For example, the following formula would round the number 12.3456 up to 2 decimal places:

=ROUNDUP(12.3456, 2)

The syntax of the ROUNDDOWN formula is as follows:

ROUNDDOWN(number, [num_digits])

Where:

• number: The number to be rounded.
• [num_digits]: Optional. The number of digits to which you want to round the number. If this argument is omitted, the number is rounded to 0 decimal places.

For example, the following formula would round the number 12.3456 down to 2 decimal places:

=ROUNDDOWN(12.3456, 2)

The syntax of the MROUND formula is as follows:

MROUND(number, multiple)

Where:

• number: The number to be rounded.
• multiple: The multiple to which you want to round the number.

For example, the following formula would round the number 12.3456 to the nearest multiple of 0.05:

=MROUND(12.3456, 0.05)