How to Round to the Nearest 10 Cents in Excel (4 Methods)

The Product List table contains ID No., Item and Price columns. We can see in the Price column the price is up to 2 decimal places. Here, we will use 4 different methods in the Price column to round to the nearest 10 cents.

Excel Round to Nearest 10 Cents

Method 1 – Round to the Nearest 10 Cents Using the MROUND Function

Steps:

Enter the following formula in cell E5:

=MROUND(D5,0.1)

Formula Breakdown

Here, MROUND returns a number rounded to the desired multiple.
D5 is the required value to round.
0.1 is multiple to round to the nearest 10 cents.

Therefore, MROUND(D5,0.1) rounds D5, which is 12.57, to the nearest multiple of 0.1 and returns 12.60.

Press ENTER.

Excel Round to Nearest 10 Cents

We can see the result in cell E5.

Drag down the formula with the Fill Handle tool.

Finally, we can see the result in the column Rounded to 10 Cents.

Excel Round to Nearest 10 Cents

Method 2 – Use the FLOOR Function to Round to the Nearest 10 Cents

Steps:

Enter the following formula in cell E5:

=FLOOR(D5,0.1)

Formula Breakdown

Here, the FLOOR function rounds numbers down to the nearest multiple of significance.
D5 contains the number we want to round.
0.1 is the multiple to which we want to round.

Therefore, FLOOR(D5,0.1) rounds the value of cell D5, which is 12.57, down to the nearest multiple of 0.1 and returns an output of 12.50.

Pess ENTER.

We can see the result in cell E5.

Drag down the formula with the Fill Handle tool.

Finally, we can see all the prices rounded to 10 cents in the Rounded to 10 Cents column.

Excel Round to Nearest 10 Cents

Method 3 – Round to Nearest 10 Cents Employing CEILING Function

Steps:

Enter the following formula in cell E5:

=CEILING(D5,0.1)

Formula Breakdown

Here, the CEILING function returns a number, rounded up, away from zero to the multiple of nearest significance.
D5 contains the number we want to round up.
0.1 is the multiple to which we want to round.

Therefore, CEILING(D5,0.1) rounds the value in cell D5, which is 12.57, up to the nearest multiple of 0.1, resulting in 12.60.