Syntax<\/h3>\n
ROUND(value, [places])<\/strong><\/p>\n Please note that the\u00a0<\/span>places<\/strong>\u00a0parameter can also be negative. In such cases,\u00a0the values are rounded at the specified number of digits to the left of the decimal point.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let\u2019s go right ahead and try the formula on the Google Sheets application. This should reinforce our understanding of the formulas. Please consider the following screenshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/ROUND-formula-Illustration-Frame-1.webp” alt=”ROUND Formula in Google Sheets: Usage” title_text=”round-formula-usage” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As is the case with almost all the Google Sheets formulas, both parameters of the ROUND formula accepts direct numeric values as well as cell references.<\/p>\n The very first example uses 0 for the\u00a0<\/span>places<\/strong>\u00a0<\/span>parameter. This indicates that the formula should ignore all the values after the decimal point, and then round off the number as per the\u00a0<\/span>standard norms<\/a>. The values 1, 2, and 3 for\u00a0<\/span>places<\/strong>\u00a0<\/span>parameter results in one, two, and three values after the decimal point. We illustrate this in the examples in rows 3, 4 and 5.<\/p>\n It gets interesting when we start using the negative values for the places parameter. A value of -1 for the\u00a0<\/span>places<\/strong>\u00a0<\/span>parameter gets us one zero at the end, after rounding off the tenth place. But, there won\u2019t be any decimal point in the output. Similarly, a value of -2 on the second parameter gets us two zeros at the end, after rounding off the hundredth place.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal values after the decimal point than desired. And our requirement may be such that we need to confine the rational values to the desired number of decimal places. We can do that with the help […]<\/p>\n","protected":false},"author":40,"featured_media":8927,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal values after the decimal point than desired. And our requirement may be such that we need to confine the rational values to the desired number of decimal places. We can do that with the help of the ROUND<\/a> formula in Google Sheets.\n\n
Usage: ROUND formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nROUND(value, [places])<\/strong>\n
\n \t
Usage: ROUND formula in Google Sheets<\/h3>\nLet's go right ahead and try the formula on the Google Sheets application. This should reinforce our understanding of the formulas. Please consider the following screenshot.\n\n
![\"ROUND](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/ROUND-formula-Illustration-Frame-1.png\")
\n\nAs is the case with almost all the Google Sheets formulas, both parameters of the ROUND formula accepts direct numeric values as well as cell references.\n\nThe very first example uses 0 for the places<\/strong> parameter. This indicates that the formula should ignore all the values after the decimal point, and then round off the number as per the standard norms<\/a>. The values 1, 2, and 3 for places<\/strong> parameter results in one, two, and three values after the decimal point. We illustrate this in the examples in rows 3, 4 and 5.\n\nIt gets interesting when we start using the negative values for the places parameter. A value of -1 for the places<\/strong> parameter gets us one zero at the end, after rounding off the tenth place. But, there won't be any decimal point in the output. Similarly, a value of -2 on the second parameter gets us two zeros at the end, after rounding off the hundredth place.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8847","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8847","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\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8847"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8847\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8927"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}