Syntax<\/h3>\n
MAX(value1, [value2, \u2026])<\/strong><\/p>\n Please 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.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that we\u2019ve learned the syntax of the formula, let us try it directly on the Google Sheets application. Please consider the image below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/MAX-formula-Illustration-Frame-1.png” alt=”MAX Formula in Google Sheets” title_text=”max-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 maximum value out of them. The second example is a demonstration that shows us that the MAX 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. We will see that, of all the numbers we used for the input parameters, 907 is the largest value. Therefore, the MAX formula has diligently delivered what it was set out to do.<\/p>\n The MIN formula in Google Sheets\u00a0identifies the minimum value from a set of numeric values. Read 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":" Various\u00a0spreadsheets programs that we have been using have one main goal. To help us understand the underlying data. More specifically with numbers. We often find ourselves in situations where we need to identify the maximum value from a set of numeric values. Is there any way to do this swiftly, without having to do the […]<\/p>\n","protected":false},"author":40,"featured_media":8682,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Various <\/span>spreadsheets programs that we have been using have one main goal. To help us understand the underlying data. More specifically with numbers. We often find ourselves in situations where we need to identify the maximum value from a set of numeric values. Is there any way to do this swiftly, without having to do the scouting manually? Of course! The MAX<\/a> formula in Google Sheets is built just for this purpose.\n\n
Usage: MAX formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nMAX(value1, [value2, ...])<\/strong>\n
\n \t
Usage: MAX formula in Google Sheets<\/h3>\nNow that we've learned the syntax of the formula, let us try it directly on the Google Sheets application. Please consider the image below.\n\n
![\"MAX](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/MAX-formula-Illustration-Frame-1.png\")
\n\nThe first example consumes direct numeric values and returns the maximum value out of them. The second example is a demonstration that shows us that the MAX 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. We will see that, of all the numbers we used for the input parameters, 907 is the largest value. Therefore, the MAX formula has diligently delivered what it was set out to do.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8681","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\/fr\/wp-json\/wp\/v2\/posts\/8681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8681"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8681\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8682"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}