{"id":8678,"date":"2018-06-18T16:00:12","date_gmt":"2018-06-18T14:00:12","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=8678"},"modified":"2018-06-18T16:00:12","modified_gmt":"2018-06-18T14:00:12","slug":"formula-min-en-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-formulas\/min-formula-in-google-sheets\/","title":{"rendered":"C\u00f3mo utilizar la f\u00f3rmula MIN en Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

While the first parameter accepts only range references, the second parameter can take both direct numbers as well as cell references.<\/p>\n

We have the input dataset laid out on column A, which will serve as the source for the first parameter. We have placed the same dataset on column B, except we sorted it in the descending order. Column B is just for reference so that we can quickly compare the outputs with the expected output.<\/p>\n

Now let us quickly go through the column D. On the cell D2, we are looking to extract the first largest value. On D3, the second largest value and so on and so forth. If we were to compare columns B and D, we will notice that the LARGE formula returns the outputs the exact manner that it is expected to do so.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/MIN-formula-Illustration-Frame-1.png” alt=”Google Sheets MIN Formula” title_text=”min-formula” _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

The first example consumes direct numeric values and returns the minimum value out of them. The second example is a demonstration that shows us that the MIN formula can use references to cells that store numbers. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A8. And, in the final example, we not only passed direct numeric values but also a couple range references.<\/p>\n

You\u2019ll observe that the output is the same across all examples, regardless of the approach that we have taken with the formula. And unsurprisingly, if we look closely, 188 is the least value among all the numbers we used for input parameters. So, the MIN formula was spot on!<\/p>\n

The MAX formula in Google Sheets identifies the maximum value from a set of numeric values. Read all about it in\u00a0<\/span>this blog post.<\/a><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

While the first parameter accepts only range references, the second parameter can take both direct numbers as well as cell references. We have the input dataset laid out on column A, which will serve as the source for the first parameter. We have placed the same dataset on column B, except we sorted it in […]<\/p>\n","protected":false},"author":40,"featured_media":8761,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We can all agree on one thing about spreadsheets - they help us find meaning with underlying data. More specifically with numbers. There can be multiple business scenarios where we need to identify the minimum value from a set of numeric values. Is there any quickfire way to do this, without having to manually scout for it? Sure, there is. The MIN<\/a> formula in Google Sheets is built just for this purpose.\n

Syntax<\/h3>\nMIN(value1, [value2, ...])<\/strong>\n
    \n \t
  • value1<\/strong> - is the first input value in the set of numeric values, which the formula has to identify the minimum value from.<\/li>\n \t
  • value2, ...<\/strong> - [ OPTIONAL ] - these are additional values in the set of numeric values we are considering to calculate the minimum value from.<\/li>\n<\/ul>\nPlease note that these inputs can either be direct numeric values, or references to the cells having these numeric values. It is also possible to have direct values for a few parameters and ranges for the other parameters.\n

    Usage: MIN formula in Google Sheets<\/h3>\nBy any chance, if the syntax wasn't clear enough, we need not worry. Because, we are going to try them directly on the Google Sheets application, and this should help aid our understanding. Please take a look at the screenshot below.\n\n\"MIN\n\nThe first example consumes direct numeric values and returns the minimum value out of them. The second example is a demonstration that shows us that the MIN formula can use references to cells that store numbers. In the third example, instead of sending multiple values or references, we have passed a single composite range. This composite cell range consists of all the values from A2 through A8. And, in the final example, we not only passed direct numeric values but also a couple range references.\n\nYou'll observe that the output is the same across all examples, regardless of the approach that we have taken with the formula. And unsurprisingly, if we look closely, 188 is the least value among all the numbers we used for input parameters. So, the MIN formula was spot on!","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8678","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\/8678","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=8678"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8761"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}