[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
When working in Excel, sometimes you need to use values that are a little less precise. For example, if you\u2019re working with the average prices of products, you probably don\u2019t need them to be accurate to 7 decimal places. The same is probably true of the results of many other calculations. Luckily, Microsoft Excel has three related functions to help you with this: ROUND, ROUNDUP, and ROUNDDOWN. You can specify exactly how you want a number rounded, including rounding to the left of the decimal point or the nearest multiple of any multiple of 10.<\/p>\n
In this guide, you\u2019ll learn about Microsoft Excel\u2019s ROUND function, as well as the related functions ROUNDUP and ROUNDDOWN. You will learn how to use them to round numbers to fewer decimal places, to whole numbers, to the nearest multiple of ten and beyond, as well as to one decimal place to the left of the decimal point. Each example is worked out step-by-step, so you can see how the different options affect the results.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”round-formula-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The syntax for Excel\u2019s ROUND function is ROUND(number; num_digits). It has two required parameters: the number you want to round and the number of decimals to which you want to round it. For example, you can round 1.932 to two decimals as follows: ROUND(1.932; 2) = 1.93.<\/p>\n
The screenshots in this guide use European regional settings, so the arguments are separated by semicolons and decimals are shown with a comma (1,93). With US or UK settings, separate the arguments with commas instead: ROUND(1.932, 2).<\/p>\n
The ROUND function rounds to the nearest whole number: decimal values in the 0 – 4 range are rounded down, while those in the 5 – 9 range are rounded up. However, if you need to ensure that it rounds in a specific direction, you can use the ROUNDUP or ROUNDDOWN functions, both of which have the same parameters as ROUND. ROUNDUP rounds away from zero, and ROUNDDOWN towards zero.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-round-a-number-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To round a number in Excel, use the ROUND(number; num_digits). For \u2018number\u2019, type the number you want to round. For \u2018num_digits\u2019, type the number of decimal places you want. Using “0” will round to the nearest integer, while negative numbers will round to the left of the decimal point. You can find the ROUND function under Formulas > Maths & Trig > ROUND.<\/p>\n
1.<\/strong> Click on an empty cell and go to Formulas > Maths & Trig > ROUND. Alternatively, type in the name of the function after the equal sign.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-maths-trig-menu.webp” alt=”How to round off numbers in Excel \u2014 Formulas > Maths & Trig menu with ROUND, ROUNDDOWN, and ROUNDUP” title_text=”Formulas > Maths & Trig menu with ROUND, ROUNDDOWN, and ROUNDUP” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add the number you want to round as the first parameter in the \u2018Formula Builder\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-formula-builder-number.webp” alt=”How to round off numbers in Excel \u2014 Formula Builder with 1,932 as the number to round” title_text=”Formula Builder with 1,932 as the number to round” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add a positive integer under \u2018Num_digits\u2019 to specify the number of decimal places you want in the result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-num-digits.webp” alt=”How to round off numbers in Excel \u2014 Formula Builder with Num_digits set to 2″ title_text=”Formula Builder with Num_digits set to 2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Click \u2018Done\u2019 to see the results.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-result.webp” alt=”How to round off numbers in Excel \u2014 1,932 rounded to 1,93″ title_text=”1,932 rounded to 1,93″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”examples-of-how-to-use-the-round-functio” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Below, you have examples showing the different rounding options available with ROUND, ROUNDUP, and ROUNDDOWN.<\/p>\n The examples below illustrate how ROUND works with positive and negative values. Moreover, you can see and compare the results of ROUNDUP and ROUNDDOWN.<\/p>\n 1.<\/strong> In separate cells, type in the values of the numbers you want to round. In this case, I will use the positive and negative values of the same numbers.<\/p>\n The same approach works for any function that returns a number, for example a SUMIF total<\/a> or a SUMPRODUCT<\/a> result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-numbers.webp” alt=”Excel ROUND function \u2014 positive and negative numbers typed in a column” title_text=”Positive and negative numbers typed in a column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In an empty cell, type the ROUND function and select the first value you want to round. Add a semicolon and type the number of decimal places you want to round to.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-two-decimals.webp” alt=”Excel ROUND function \u2014 ROUND(A2;2) rounding to two decimal places” title_text=”ROUND(A2;2) rounding to two decimal places” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Grab the fill handle and drag it down to the last value. As you can see, the first and third values are rounded down – towards zero – while the second and fourth are rounded up – away from zero.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-two-decimals-results.webp” alt=”Excel ROUND function \u2014 ROUND results for positive and negative numbers” title_text=”ROUND results for positive and negative numbers” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Repeat steps 2 and 3 for the ROUNDUP and ROUNDDOWN functions. As you can see, ROUNDUP has rounded up all the values, while ROUNDDOWN has rounded down.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-roundup-rounddown.webp” alt=”Excel ROUND function \u2014 ROUND, ROUNDUP, and ROUNDDOWN results side by side” title_text=”ROUND, ROUNDUP, and ROUNDDOWN results side by side” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the instructions below to round numbers to the nearest integer. I will use the same values as before to better illustrate the effect.<\/p>\n 1.<\/strong> In an empty cell, type the ROUND function. Select the cell with the number to round and use “0” for the \u2018num_digits\u2019 parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-whole-number.webp” alt=”Round to the nearest whole number in Excel \u2014 ROUND(A2;0) typed in the cell” title_text=”ROUND(A2;0) typed in the cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Grab the fill handle and drag it down to the last number.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-whole-number-results.webp” alt=”Round to the nearest whole number in Excel \u2014 ROUND results filled down the column” title_text=”ROUND results filled down the column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Repeat steps 1 and 2 with the ROUNDUP and ROUNDDOWN functions. As you can see, the results are quite different in this case. With 0 as the second parameter, ROUNDUP always rounds up to the nearest whole number and ROUNDDOWN always rounds down.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-whole-number-up-down.webp” alt=”Round to the nearest whole number in Excel \u2014 ROUNDUP and ROUNDDOWN with 0 decimal places” title_text=”ROUNDUP and ROUNDDOWN with 0 decimal places” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the steps below to see how rounding to the left of the decimal point affects the values.<\/p>\n 1.<\/strong> Type the ROUND function and select the first value. For the second parameter, use a negative integer. In this case, I will use “-1” to get the nearest multiple of ten.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-negative-digits.webp” alt=”Round to the left of the decimal point in Excel \u2014 ROUND(A2;-1) typed in the cell” title_text=”ROUND(A2;-1) typed in the cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Grab the fill handle and drag it down to the last value.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-negative-digits-results.webp” alt=”Round to the left of the decimal point in Excel \u2014 ROUND results to the nearest ten” title_text=”ROUND results to the nearest ten” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Repeat steps 1 and 2 with ROUNDUP and ROUNDDOWN.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-negative-up-down.webp” alt=”Round to the left of the decimal point in Excel \u2014 ROUNDUP and ROUNDDOWN to the nearest ten” title_text=”ROUNDUP and ROUNDDOWN to the nearest ten” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to round the results of other functions, you can wrap the ROUND function around it. Below, I will use the AVERAGE function on a set of values and wrap the ROUND function around it.<\/p>\n 1.<\/strong> Type the ROUND function, and after the parenthesis, type in the function name: in this case, AVERAGE.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-round-average.webp” alt=”Excel ROUND with AVERAGE \u2014 AVERAGE typed inside the ROUND function” title_text=”AVERAGE typed inside the ROUND function” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Select the range of values for which you want the average and close the parenthesis.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-average-range.webp” alt=”Excel ROUND with AVERAGE \u2014 range A2:A11 selected for the average” title_text=”Range A2:A11 selected for the average” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add a semicolon and type the number of decimal places you want to round to. Close the parenthesis and press \u2018Enter\u2019 to see the results.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-average-digits.webp” alt=”Excel ROUND with AVERAGE \u2014 2 decimal places added to the formula” title_text=”2 decimal places added to the formula” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> As you can see below, the average value without rounding has 8 decimal places.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/excel-round-function-average-compared.webp” alt=”Excel ROUND with AVERAGE \u2014 rounded average next to the unrounded average” title_text=”Rounded average next to the unrounded average” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Excel ROUND function lets you round numbers in any way you want, including to the left of the decimal point. By default, the function rounds down decimals from zero to four, while decimals from five to nine are rounded up. However, you can use the ROUNDUP and ROUNDDOWN functions to choose the direction in which the number is rounded.<\/p>\n You now know how to use the ROUND function in Microsoft Excel, as well as the related functions ROUNDUP and ROUNDDOWN, to specify the direction in which it’s rounded. You also know how to use the different options available for the num_digits parameter. Using positive integers allows you to specify the number of decimal places you want to be returned, and using zero rounds to the nearest integer, while negative integers round to the left of the decimal point.<\/p>\n Google Sheets has the same three functions, so the ROUND formula in Google Sheets<\/a> works just as described here. For other functions worth learning, see the top 10 Excel functions<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a arredondar n\u00fameros no Excel com ROUND, ROUNDUP e ROUNDDOWN (ARRED, ARREDONDAR.PARA.CIMA e ARREDONDAR.PARA.BAIXO), com qualquer n\u00famero de casas decimais ou para o inteiro mais pr\u00f3ximo.<\/p>","protected":false},"author":2,"featured_media":262396,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[],"class_list":["post-262377","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262377"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262396"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Examples of how to use the ROUND function in Excel<\/h2>\n
Round to 2 decimal places, with positive and negative numbers<\/h3>\n
Round to the nearest whole number<\/h3>\n
Round to the left of the decimal point<\/h3>\n
Round the result of another function<\/h3>\n
Conclusion<\/h2>\n