Syntax<\/h3>\n
FLOOR(value, [factor])<\/strong><\/p>\n Please note that the\u00a0<\/span>factor<\/strong>\u00a0<\/span>may not be equal to 0, and is usually a positive value.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The formula syntax isn\u2019t that complicated. But, it can be a little tricky to understand its behavior. So let us make use of a few examples to clear out any doubts. Consider the following screenshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/FLOOR-formula-Illustration-1.png” alt=”FLOOR formula in Google Sheets” title_text=”floor-formula” _builder_version=”4.16″ 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 Let us consider the first example. If we look at the multiples of\u00a0<\/span>factor<\/strong>\u00a0<\/span>value 1, they are 1, 2, 3, \u202618, 19, 20, 21, \u2026 etc. Since 20 is the nearest available factor multiple, the formula returned 20 as output.<\/p>\n Similarly, in the second example, the\u00a0<\/span>factor<\/strong>\u00a0<\/span>multiples are 3, 6, 9, 12, 15, 18, 21, 24, \u2026 etc. Clearly, the\u00a0<\/span>value<\/strong>\u00a0<\/span>20 lies between the multiples 18 and 21. Since the formula considers the nearest lower value (or the FLOOR value), it results in 18 and not 21.<\/p>\n Same is the case with the third example. Among the multiples 7, 14, 21, 28, \u2026 etc. the FLOOR of the value 20 is 14. We can also extend this to even rational\u00a0<\/span>factor<\/strong>s, as demonstrated in the final four examples. Please note that we can also use negative values for the first input parameter (final example).<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" While there are infinite rational numbers in mathematics, we don\u2019t usually deal with all of them. That\u2019s because, in real life, it isn\u2019t even feasible. Consider currency for instance. We may make many money transaction calculations \u2013 interest, exchange rates, etc. For the purposes of this example, let\u2019s say we arrived at $21.835. If we […]<\/p>\n","protected":false},"author":40,"featured_media":8977,"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 there are infinite rational numbers in mathematics, we don't usually deal with all of them. That's because, in real life, it isn't even feasible. Consider currency for instance. We may make many money transaction calculations - interest, exchange rates, etc. For the purposes of this example, let's say we arrived at $21.835. If we were to transact that in reality, we may have to round it off to the nearest available currency denomination. Because it is unlikely that we have physical denominations available to pay that amount in entirety. And more often, we round it down to the lowest possible multiple-denomination value. For instance, if we had $10 bills, we would round the value $21.835 to $20. Or if we had $1 bills, then we'd round it to $21. The FLOOR<\/a> formula in Google Sheets helps us with the similar scenarios while handling numbers on spreadsheets.\n\n
Usage: FLOOR formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nFLOOR(value, [factor])<\/strong>\n
\n \t
Usage: FLOOR formula in Google Sheets<\/h3>\nThe formula syntax isn't that complicated. But, it can be a little tricky to understand its behavior. So let us make use of a few examples to clear out any doubts. Consider the following screenshot.\n\n
![\"FLOOR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/FLOOR-formula-Illustration-1.png\")
\n\nLet us consider the first example. If we look at the multiples of factor<\/strong> value 1, they are 1, 2, 3, ...18, 19, 20, 21, ... etc. Since 20 is the nearest available factor multiple, the formula returned 20 as output.\n\nSimilarly, in the second example, the factor<\/strong> multiples are 3, 6, 9, 12, 15, 18, 21, 24, ... etc. Clearly, the value<\/strong> 20 lies between the multiples 18 and 21. Since the formula considers the nearest lower value (or the FLOOR value), it results in 18 and not 21.\n\nSame is the case with the third example. Among the multiples 7, 14, 21, 28, ... etc. the FLOOR of the value 20 is 14. We can also extend this to even rational factor<\/strong>s, as demonstrated in the final four examples. Please note that we can also use negative values for the first input parameter (final example).","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8976","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\/es\/wp-json\/wp\/v2\/posts\/8976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8976"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8976\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8977"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}