# Round to the next decimal range

#### Frédéric LE GUEN

Last Updated on 09/07/2023
Reading time: 2 minutes

This article will explain how to round your figures to the next decimal range (10 cents, 25 cents, 50 cents, ...)

## 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 example of rounding precision using data from column A and precision from row 1. The formula has been build with mixed references to write the formula only once for whole table.

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

## Round to tenth, hundredth

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

This trick will be the solution 😉

## 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 the next decimal range

Reading time: 2 minutes
Last Updated on 09/07/2023

This article will explain how to round your figures to the next decimal range (10 cents, 25 cents, 50 cents, ...)

## 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 example of rounding precision using data from column A and precision from row 1. The formula has been build with mixed references to write the formula only once for whole table.

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

## Round to tenth, hundredth

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

This trick will be the solution 😉

## 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

{"mobile_concate":{"mobile-menu":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/mobile-menu.min.css"},"tf_base":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/base.min.css","v":"7.3.1"},"themify_common":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify.common.min.css","v":"7.3.1"},"builder-styles-css":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/themify-builder-style.min.css","v":"7.3.1"},"tb_tbp":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.min.css","v":"3.1.2"},"tf_theme_site-logo":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.min.css","v":"7.1.4"},"tf_theme_site-description":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-description.min.css","v":"7.1.4"},"tf_search_form":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.min.css","v":"7.3.1"},"tb_featured-image":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.min.css","v":"7.3.1"},"tb_divider":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/divider.min.css","v":"7.3.1"},"tb_post-content":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.3.1"},"wp-block-library":{"s":"https:\/\/www.excel-exercise.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"6.3.1"},"tb_comments":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/modules\/comments.min.css","v":"3.1.2"},"tb_text":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.3.1"},"theme-style":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/style.min.css","v":"7.1.4"},"themify-media-queries":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/media-queries.min.css","v":"7.1.4","m":"(max-width:1200px)"}}