{"id":1338,"date":"2018-07-04T10:30:49","date_gmt":"2018-07-04T10:30:49","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1338"},"modified":"2023-11-03T13:33:58","modified_gmt":"2023-11-03T13:33:58","slug":"roundup","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/roundup\/","title":{"rendered":"ROUNDUP function"},"content":{"rendered":"\n

The Excel ROUNDUP function is a mathematical function that allows you to round a number up to a specified number of decimal places. It is particularly useful when you want to ensure that the rounded number is always greater than or equal to the original number.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

ROUNDUP(number, num_digits)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
number<\/strong><\/td>The number you want to round up.<\/td><\/tr>
num_digits<\/strong><\/td>The number of decimal places to which you want to round the number. This is an optional argument. If omitted, it defaults to 0.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to Use<\/h2>\n\n\n\n

The Excel ROUNDUP function is straightforward to use. Here are some examples to help you understand how it works:<\/p>\n\n\n\n

Example 1:<\/strong> Round up a number to the nearest whole number.<\/p>\n\n\n\n

=ROUNDUP(12.34, 0)<\/code><\/pre>\n\n\n\n
This formula rounds up the number 12.34 to the nearest whole number, resulting in 13.<\/p>\n\n\n\n
Example 2:<\/strong> Round up a number to one decimal place.<\/p>\n\n\n\n
=ROUNDUP(8.567, 1)<\/code><\/pre>\n\n\n\n
Here, we round up 8.567 to one decimal place, which gives us 8.6.<\/p>\n\n\n\n
Example 3:<\/strong> Round up a number to three decimal places (Optional).<\/p>\n\n\n\n
=ROUNDUP(99.12345, 3)<\/code><\/pre>\n\n\n\n
Using the optional num_digits argument, we round up 99.12345 to three decimal places, resulting in 99.124.<\/p>\n\n\n\n
Example 4:<\/strong> Omitting the num_digits argument (defaults to 0).<\/p>\n\n\n\n
=ROUNDUP(55.99)<\/code><\/pre>\n\n\n\n
If you don’t provide the num_digits argument, the function defaults to rounding the number to the nearest whole number. In this case, it rounds up 55.99 to 56.<\/p>\n\n\n\n
Remember that the ROUNDUP function always ensures that the rounded number is greater than or equal to the original number. This is especially useful in financial calculations where you want to avoid underestimating values.<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
The ROUNDUP function is one of the rounding functions in Excel, and it complements other functions like ROUND and ROUNDDOWN. It’s essential to understand the specific requirements of your calculations to choose the right rounding function for your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
The Excel ROUNDUP function is a mathematical function that allows you to round a number up to a specified number of decimal places….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nROUNDUP function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ROUNDUP function\" \/>\n<meta property=\"og:description\" content=\"The Excel ROUNDUP function is a mathematical function that allows you to round a number up to a specified number of decimal places....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T10:30:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T13:33:58+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ROUNDUP function\",\"datePublished\":\"2018-07-04T10:30:49+00:00\",\"dateModified\":\"2023-11-03T13:33:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\"},\"wordCount\":289,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\",\"name\":\"ROUNDUP function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T10:30:49+00:00\",\"dateModified\":\"2023-11-03T13:33:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/roundup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/roundup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ROUNDUP function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ROUNDUP function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/roundup\/","og_locale":"en_US","og_type":"article","og_title":"ROUNDUP function","og_description":"The Excel ROUNDUP function is a mathematical function that allows you to round a number up to a specified number of decimal places....","og_url":"https:\/\/officetuts.net\/excel\/functions\/roundup\/","article_published_time":"2018-07-04T10:30:49+00:00","article_modified_time":"2023-11-03T13:33:58+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ROUNDUP function","datePublished":"2018-07-04T10:30:49+00:00","dateModified":"2023-11-03T13:33:58+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/"},"wordCount":289,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/","url":"https:\/\/officetuts.net\/excel\/functions\/roundup\/","name":"ROUNDUP function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T10:30:49+00:00","dateModified":"2023-11-03T13:33:58+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/roundup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/roundup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ROUNDUP function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1338"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1338"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1338\/revisions"}],"predecessor-version":[{"id":16557,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1338\/revisions\/16557"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}