{"id":380774,"date":"2021-12-13T22:00:40","date_gmt":"2021-12-13T19:00:40","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-round-numbers-in-google-sheets\/"},"modified":"2021-12-13T22:00:40","modified_gmt":"2021-12-13T19:00:40","slug":"how-to-round-numbers-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-round-numbers-in-google-sheets\/","title":{"rendered":"#How to Round Numbers in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a32afee5c9f5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a32afee5c9f5\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-round-numbers-in-google-sheets\/#Use_the_ROUND_Function_in_Google_Sheets\" >Use the ROUND Function in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-round-numbers-in-google-sheets\/#Use_the_ROUNDUP_Function\" >Use the ROUNDUP Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-round-numbers-in-google-sheets\/#Use_the_ROUNDDOWN_Function\" >Use the ROUNDDOWN Function<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Round Numbers in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When working with decimal values, you may want to round those numbers up or down. Most often it\u2019s necessary with values containing many decimal points. Google Sheets gives you handy functions for rounding your numbers the way you want.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_ROUND_Function_in_Google_Sheets\"><\/span>Use the ROUND Function in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The simplest <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/447024\/how-to-find-data-in-google-sheets-with-vlookup\/\">function in Google Sheets for this task is the <code>ROUND<\/code> function. The syntax for the function is <code>ROUND(value, places)<\/code> where <code>value<\/code> is required, and <code>places<\/code> is optional. You can use a number for the value or a cell reference. Let\u2019s look at some examples.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find Data in Google Sheets with VLOOKUP<\/em><\/strong><\/p>\n<p>To round the number 15.567 up to a whole number, you would simply enter it as the first argument without the number of places. This is because the places argument is zero by default. By using the following formula, the result is 16.<\/p>\n<pre>=ROUND(15.567)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771054\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundDefault-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the default ROUND function\" width=\"500\" height=\"174\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to round that same number one decimal place, enter the following formula and press Enter. The result is 15.6.<\/p>\n<pre>=ROUND(15.567,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771053\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundOne-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round one decimal place\" width=\"500\" height=\"162\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Maybe you want to round your number to the left of the decimal point instead of to the right. You can use a negative number for the places argument. You would enter the following formula to round that number one place on the left for a result of 20.<\/p>\n<pre>=ROUND(15.567,-1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771052\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundNegative-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round to the left of the decimal\" width=\"500\" height=\"167\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use cell references as the value for the <code>ROUND<\/code> function and it works the same way. To round the decimal number in cell <code>A1<\/code>, you would enter the following formula and press Enter.<\/p>\n<pre>=ROUND(A1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771056\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundCellReference-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round a cell reference value\" width=\"600\" height=\"158\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Add an argument for the number of decimal places just like when entering a value. To round the same value in cell <code>A1<\/code> one decimal place, you would use the following formula.<\/p>\n<pre>=ROUND(A1,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771055\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundCellReferenceOne-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round a cell reference value one place\" width=\"600\" height=\"158\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_ROUNDUP_Function\"><\/span>Use the ROUNDUP Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to make sure you\u2019re always rounding your number up, you can use the <code>ROUNDUP<\/code> function in Google Sheets. The syntax is <code>ROUNDUP(value, places)<\/code> just like the <code>ROUND<\/code> function. The value is required and can be a number or cell reference. The places argument is optional and defaults to zero.<\/p>\n<p>To round the number 15.567 up, you can simply enter the following formula and press Enter. The result is 16.<\/p>\n<pre>=ROUNDUP(15.567)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771057\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundupDefault-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the default ROUNDUP function\" width=\"500\" height=\"165\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To round the same number one decimal place, for a result of 15.6, you would use the following formula.<\/p>\n<pre>=ROUNDUP(15.567,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771058\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundupOne-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round up one decimal place\" width=\"500\" height=\"160\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Just the like <code>ROUND<\/code> function, you can use a negative number for the places argument to round to the left of the decimal point. And you can use a cell reference if you prefer. With 15.567 in cell <code>A1<\/code>, this formula gives us a result of 20.<\/p>\n<pre>=ROUNDUP(A1,-1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771059\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RoundupNegative-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round up to the left of the decimal\" width=\"600\" height=\"152\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_ROUNDDOWN_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Use the ROUNDDOWN Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One more variant of the <code>ROUND<\/code> function you may find useful is for always rounding down. This is the <code>ROUNDDOWN<\/code> function in Google Sheets, and the syntax is the same as the others, <code>ROUNDDOWN(value, places)<\/code>.<\/p>\n<p>To round our number 15.567 down, we would enter the following formula and press Enter. The result is 15.<\/p>\n<pre>=ROUNDDOWN(15.567)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771062\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RounddownDefault-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the default ROUNDDOWN function\" width=\"500\" height=\"158\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To round the same number down to one decimal place, we would enter one for the number of places for a result of 15.5.<\/p>\n<pre>=ROUNDDOWN(15.567,1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771061\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RounddownOne-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round down one decimal place\" width=\"500\" height=\"152\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Again, you can use a negative number for the places argument and use cell references like with the other functions here. With 15.567 in cell <code>A1<\/code>, this formula gives us a result of 10.<\/p>\n<pre>=ROUNDDOWN(A1,-1)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-771060\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/RounddownNegative-GoogleSheetsRoundNumbers.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Round down to the left of the decimal\" width=\"600\" height=\"157\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Rounding numbers in your spreadsheet doesn\u2019t have to be a struggle or even take extra time. Just keep these Google Sheets functions in mind.<\/p>\n<p>For additional help with functions, take a look at how to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/449861\/how-to-use-the-google-sheets-if-function\/\">use the IF function along with the AND and OR functions in Google Sheets.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/771049\/how-to-round-numbers-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Round Numbers in Google Sheets&#8221; When working with decimal values, you may want to round those numbers up or down. Most often it\u2019s necessary with values containing many decimal points. Google Sheets gives you handy functions for rounding your numbers the way you want. Use the ROUND Function in Google Sheets The simplest&#8230;<\/p>\n","protected":false},"author":1,"featured_media":380775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-380774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/380774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=380774"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/380774\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/380775"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=380774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=380774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=380774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}