Rounding to the Nearest Tenth or hundredth with a single formula, it's possible with Excel

**The ROUND function**The ROUND function is known for rounding to the n

^{th}decimal**Use the second argument with a negative number**That's the Secret! For rounding to the nearest Tenth of Hundredth, you simply have to write a negative number for the second argument.

## The typical application of the ROUND function

The ROUND function is extensively utilized in Excel. Its primary purpose is to round a number to a designated number of digits. The syntax for the ROUND function is as follows:

=ROUND(number, decimal)

- "
" is your original number**Number** - "
" is the number of decimal places you want to keep**Decimal**

You can input any value, even 0, if you prefer not to include any digits in the output.

## Rounding to the nearest tenth, hundredth, thousandth

The method for rounding to the nearest ten is straightforward. Simply utilize the same function but with a negative value for the decimal argument. 😮😮😮

For example, when rounding to the nearest tenth, you would input -1 as the second argument of the function.

=ROUND(1234,-1) =>1230

Adjust the parameter to -2 for rounding to the nearest hundred.

=ROUND(1234,-2) =>1200

Or -3 for rounding to the nearest thoushandth

=ROUND(1234,-3) =>1000

## The function MROUND

An alternative method for rounding to the nearest ten, five, etc. involves utilizing the MROUND function. The "M" in MROUND stands for Multiple, allowing you to specify the desired multiple to round to.

For instance, if you aim to round to the nearest tenth, you would input 10 as the second argument.

=MROUND(1234,10) =>1230

Alternatively, round to the nearest five by using 5.

=MROUND(1234,5) =>1235