Round to 10, 25, or 50 cents with Excel

Round to 10, 25, or 50 cents with Excel
Last Updated on 01/08/2023
Reading time: 2 minutes

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)

Example round decimal number

Round by decimal

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

Originial values to round

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

Multiply the original values by 100

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

=ROUNDUP(B2*100; -1)

Round up the value

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 10 cents

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

Round up to the next 25 cents

Rounded up to the next 50 cents

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

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

Round up to the next 50 cents

Round to tenth, hundredth

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

Example to round to the tenth or hundredth

Leave a Reply

Your email address will not be published. Required fields are marked *

Round to 10, 25, or 50 cents with Excel

Reading time: 2 minutes
Last Updated on 01/08/2023

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)

Example round decimal number

Round by decimal

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

Originial values to round

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

Multiply the original values by 100

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

=ROUNDUP(B2*100; -1)

Round up the value

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 10 cents

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

Round up to the next 25 cents

Rounded up to the next 50 cents

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

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

Round up to the next 50 cents

Round to tenth, hundredth

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

Example to round to the tenth or hundredth

Leave a Reply

Your email address will not be published. Required fields are marked *