{"id":6084,"date":"2021-03-18T06:32:44","date_gmt":"2021-03-18T05:32:44","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6084"},"modified":"2024-03-22T18:43:25","modified_gmt":"2024-03-22T17:43:25","slug":"round-off-numbers-with-excels-round-formula","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/","title":{"rendered":"4 Best Ways to Round Off Numbers with Excel\u2019s ROUND Formula"},"content":{"rendered":"<p>Excel&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Round Off Formula (ROUND)<\/a>\u00a0can be used to remove decimal points from your data.<\/p>\n<p>Apart from making your data more presentable, it also makes the numbers easier to read and understand at first glance.<\/p>\n<p>Excel offers 4 different variations of the ROUND Formula.\u00a0 Let&#8217;s look at each of these in-depth with our Step By Step Examples &amp; Free Practice Workbook.<\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/#ROUND_Function\" title=\"ROUND Function\">ROUND Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/#ROUNDUP_Function\" title=\"ROUNDUP Function\">ROUNDUP Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/#ROUNDDOWN_Function\" title=\"ROUNDDOWN Function\">ROUNDDOWN Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/#MROUND_Function\" title=\"MROUND Function\">MROUND Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"ROUND_Function\"><\/span><span style=\"color: #339966;\"><a id=\"round-function\"><\/a><span style=\"color: #ff0000;\">ROUND Function<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Rounds a number to the nearest decimal based on your specified number of digits<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=ROUND(<span style=\"color: #ff0000;\"><span style=\"color: #339966;\"><span style=\"color: #0000ff;\">number, <span style=\"color: #008000;\">num_digits<\/span><\/span><\/span><\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=ROUND(<span style=\"color: #0000ff;\">the number<\/span>, <span style=\"color: #008000;\">number of decimal places to round off<\/span>)<\/p>\n<hr \/>\n<p>Ever had the need to round off numbers?<\/p>\n<p>I do it all the time in my financial calculations. For example, if I need to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-percentage-excel\/\" target=\"_blank\" rel=\"noopener\">calculate percentage<\/a> discounts and it gives me a number such as $47.4189349, rounding it off to $47.40 (round off to 1 decimal place) makes it so much more presentable!<\/p>\n<p>In Excel, it&#8217;s very easy to do that with the\u00a0<strong>ROUND formula!<\/strong><\/p>\n\n<h4>Follow the<strong>\u00a0step-by-step tutorial<\/strong> on Excel Round off Formula and <strong>download this Excel workbook<\/strong>\u00a0to practice along:<\/h4>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/ROUND-FORMULA-1.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/AVERAGE.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">ROUND-FORMULA-1.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>We need to <strong>enter the <em>ROUND\u00a0<\/em>function<\/strong>:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=ROUND(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6087\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-01.jpg\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"457\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-01.jpg 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-01-300x108.jpg 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The ROUND arguments:<\/p>\n<h3><em><strong><span style=\"color: #0000ff;\">number<\/span><\/strong><\/em><\/h3>\n<p><strong>What is the number we want to round off?<\/strong><\/p>\n<p><em>Reference <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dollar-sign-in-excel\/\" target=\"_blank\" rel=\"noopener\">the cell<\/a> that contains the number:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=ROUND<\/span><span style=\"color: #0000ff;\">(B9,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-02-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6091\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-02-1.jpg\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"457\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-02-1.jpg 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-02-1-300x104.jpg 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><\/p>\n<h3><em><strong><span style=\"color: #0000ff;\">num_digits<\/span><\/strong><\/em><\/h3>\n<p><strong>Round off to how many digits?<\/strong><\/p>\n<p><em>Reference the cell that contains the number of digits:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=ROUND<\/span><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">(B9,<\/span>\u00a0C9)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6089\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-03.jpg\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"457\" height=\"164\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-03.jpg 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-03-300x108.jpg 300w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Do the same for the rest of the cells by dragging the <strong>ROUND\u00a0<\/strong>formula all the way down using the left mouse button.<\/p>\n<p>Now you are able to Excel round off formula with a different number of places!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6090\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-04.jpg\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"486\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-04.jpg 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/ROUND-FORMULA-04-300x120.jpg 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Note:<\/strong> A <strong>negative sign<\/strong> before the rounding digit indicates<strong> how many places to the left of the decimal point should the number be rounded<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Screenshot-2021-03-18-at-4.57.33-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23029\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Screenshot-2021-03-18-at-4.57.33-PM.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"449\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Screenshot-2021-03-18-at-4.57.33-PM.png 449w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Screenshot-2021-03-18-at-4.57.33-PM-300x219.png 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ROUNDUP_Function\"><\/span><span style=\"color: #339966;\"><a id=\"roundup-function\"><\/a><span style=\"color: #ff0000;\">ROUNDUP Function<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>ROUNDUP Function is used to <strong>round the number up to the number of decimal points<\/strong> written.<\/p>\n<p><em>For the ROUND function, if the number is less than 5 it is rounded down but for ROUNDUP it will always round up the numbers.<\/em><\/p>\n<p>For Example &#8211;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #339966;\">=ROUNDUP(104.1,0)<\/span><\/h3>\n<p>If you want to round up 104.1 to zero decimal places, ROUNDUP will provide the result as 105!<\/p>\n<p>&nbsp;<\/p>\n<p>If the argument for the number of decimal points is<\/p>\n<ul>\n<li><strong>Positive numbers<\/strong> &#8211; Excel will round to the right of the decimal point<\/li>\n<li>Negative <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-negative-red-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener\">numbers &#8211; Excel<\/a> will round to the left of the decimal point<\/li>\n<li><strong>Zero<\/strong> &#8211; Excel will round to the nearest 1.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>We will show how to Excel round off formula using ROUNDUP below:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Enter the<strong> roundup formula<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=ROUNDUP(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-363.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23261\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-363.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"590\" height=\"326\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-363.png 590w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-363-300x166.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Select the cell whose <strong>amount needs to be rounded<\/strong><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=ROUNDUP(<\/span>B9,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-364.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23262\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-364.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"590\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-364.png 590w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-364-300x167.png 300w\" sizes=\"(max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Select the cell that contains the <strong>digits up to which the number needs to be rounded<\/strong>.<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">=ROUNDUP(B9,<\/span>C9)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-365.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23263\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-365.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"601\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-365.png 601w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-365-300x164.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p><em>The number of digits that the number needs to be rounded up to is entered here. It can be entered in a cell and the cell can be selected, or the <strong>digit can directly be written in the formula<\/strong>.<\/em><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Copy-Paste the <strong>formula down<\/strong> to the remaining cells.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-367.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23264\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-367.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"594\" height=\"326\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-367.png 594w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-367-300x165.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p>As the formula is entered, the result gives the amount rounded up to the given decimal points<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ROUNDDOWN_Function\"><\/span><span style=\"color: #339966;\"><span style=\"color: #ff0000;\"><a id=\"rounddown-function\" style=\"color: #ff0000;\"><\/a>ROUNDDOWN Functio<\/span>n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another variation is ROUNDDOWN that<strong> rounds down the number to the desired number<\/strong> of decimal places.<\/p>\n<p>Here, the steps are the same except for selecting the ROUNDDOWN function instead of the ROUNDUP function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-368.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23265\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-368.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"586\" height=\"322\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-368.png 586w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-368-300x165.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/a><\/p>\n<p>For the amount 1584.66, the ROUNDUP formula provided the result as 1585 but ROUNDDOWN has provided the result as 1584!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"MROUND_Function\"><\/span><span style=\"color: #339966;\"><a id=\"mround-function\"><\/a><span style=\"color: #ff0000;\">MROUND Function<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It <strong>rounds the number to the nearest multiple of a number given<\/strong>. It will round the number up or down depending on the nearest multiple provided in the formula.<\/p>\n<p>For example, this function can be used to;<\/p>\n<ul>\n<li>Round a price to the nearest multiple of 3<\/li>\n<li>Round a price to the nearest 0.05<\/li>\n<li>Round a time to the nearest 30 minutes.<\/li>\n<\/ul>\n<p>Let us take an example and Excel round off formula to the nearest multiple:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Enter the MROUND formula<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=MROUND<\/span><span style=\"color: #0000ff;\">(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-342.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23212\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-342.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"660\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-342.png 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-342-300x150.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Enter the<strong> first argument<\/strong> i.e. the number that should be rounded.<\/p>\n<h3 style=\"text-align: center;\">=MROUND(<span style=\"color: #0000ff;\">B9,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-343.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23213\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-343.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"604\" height=\"325\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-343.png 604w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-343-300x161.png 300w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Enter the <strong>second argument<\/strong> i.e. the multiple that the provided number should be rounded to.<\/p>\n<h3 style=\"text-align: center;\">=MROUND(B9,<span style=\"color: #0000ff;\">C9)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-344.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23214\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-344.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"612\" height=\"350\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-344.png 612w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-344-300x172.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/a><\/p>\n<p>Excel will round the number 157.764 to the nearest multiple of 5 i.e. 160!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-345.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23215\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-345.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"609\" height=\"335\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-345.png 609w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-345-300x165.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Copy-paste the formula below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-347.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23216\" title=\"Round Off Numbers with Excel's ROUND Formula\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-347.png\" alt=\"Round Off Numbers with Excel's ROUND Formula\" width=\"600\" height=\"334\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-347.png 600w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-347-300x167.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p>This completes our tutorial on how to round off numbers in Excel!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff0000;\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are <strong>numerous ways to Round off formula<\/strong> in Excel and present the value in the best way possible. So whatever your requirements, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> has a way.<\/p>\n<p>Be sure to<strong> understand the difference<\/strong> and <strong>choose the right one to prevent unexpected results<\/strong>.<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener\">10 + 1 Ways to Round Numbers in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/descriptive-statistics-in-excel\/\" target=\"_blank\" rel=\"noopener\">A Comprehensive Guide to Descriptive Statistics in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/standard-deviation-in-excel\/\" target=\"_blank\" rel=\"noopener\">How to Calculate Standard Deviation in Excel: A Detailed Tutorial<\/a><\/li>\n<\/ul>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel&#8217;s Round Off Formula (ROUND)\u00a0can be used to remove decimal points from your data. Apart from making your data more presentable, it also makes the numbers easier to read and understand at first glance. Excel offers 4 different variations of the ROUND Formula.\u00a0 Let&#8217;s look at each of these in-depth with our Step By Step [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,289],"tags":[142,238],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6084"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6084"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6084\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17189"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}