# Round to 10, 25, or 50 cents with Excel

Last Updated on 04/05/2024

How to round to 10, 25, or 50 cents in Excel? This article will explain the techniques and the formulae.

## Standard use of the ROUND function

In Excel, there are 3 functions to round your number to a specified number of digits.

• ROUND
• ROUND.INF (to round to the lowest decimal places)
• ROUNDUP (to round to the next decimal places)

For example, here we have several examples of rounding precision using data from column A and precision from row 1. The formula has been built with mixed references to write the formula only once for the whole table.

=ROUND(\$A2;B\$1)

## Round by decimal

In the following table, we have the figure we want to round to the next decimal range.

### Round up to the next 10 cents

First of all, we need to transform our numbers so that we no longer have decimals. And this is very easily obtained by multiplying our values ​​by 100.

= B2*100

Then, we will round to the next ten using the following formula

=ROUNDUP(B2*100; -1)

And of course, don't forget to divide this result by 100 (the same number as the initial multiplication) to have the result you expect.

=ROUNDUP(B2*100;-1)/100

### Round up to the next 25 cents

Here, the principle is exactly the same but here we will multiply by 40. Because 1000/25 = 40

=ROUNDUP(B2*40;-1)/40

### Rounded up to the next 50 cents

This time, we will take as a multiplier 1000/50 = 20

=ROUNDUP(B2*20;-1)/20

## Round to tenth, hundredth

But with these functions, you can also round by tenth, hundredth, or thousandth.

# Round to 10, 25, or 50 cents with Excel

Last Updated on 04/05/2024

How to round to 10, 25, or 50 cents in Excel? This article will explain the techniques and the formulae.

## Standard use of the ROUND function

In Excel, there are 3 functions to round your number to a specified number of digits.

• ROUND
• ROUND.INF (to round to the lowest decimal places)
• ROUNDUP (to round to the next decimal places)

For example, here we have several examples of rounding precision using data from column A and precision from row 1. The formula has been built with mixed references to write the formula only once for the whole table.

=ROUND(\$A2;B\$1)

## Round by decimal

In the following table, we have the figure we want to round to the next decimal range.

### Round up to the next 10 cents

First of all, we need to transform our numbers so that we no longer have decimals. And this is very easily obtained by multiplying our values ​​by 100.

= B2*100

Then, we will round to the next ten using the following formula

=ROUNDUP(B2*100; -1)

And of course, don't forget to divide this result by 100 (the same number as the initial multiplication) to have the result you expect.

=ROUNDUP(B2*100;-1)/100

### Round up to the next 25 cents

Here, the principle is exactly the same but here we will multiply by 40. Because 1000/25 = 40

=ROUNDUP(B2*40;-1)/40

### Rounded up to the next 50 cents

This time, we will take as a multiplier 1000/50 = 20

=ROUNDUP(B2*20;-1)/20

## Round to tenth, hundredth

But with these functions, you can also round by tenth, hundredth, or thousandth.