{"id":325,"date":"2019-04-04T15:11:29","date_gmt":"2019-04-04T12:11:29","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=325"},"modified":"2019-04-04T16:27:14","modified_gmt":"2019-04-04T13:27:14","slug":"the-max-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-max-function\/","title":{"rendered":"The MAX function"},"content":{"rendered":"\n<p>The <strong>MAX <\/strong>functions returns the largest number in a set of values.<\/p>\n\n\n\n<p>If you need to get the second or third or n-th largest number in a set of values then you should use the <strong><a href=\"https:\/\/www.test4u.eu\/excelpedia\/the-large-function\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"LARGE  (opens in a new tab)\">LARGE <\/a><\/strong>function.<\/p>\n\n\n\n<p>The syntax of the <strong>MAX <\/strong>function is the following:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>MAX(n1, [n2], &#8230;)<\/strong><\/p><cite><strong>n1, n2, &#8230; <\/strong>: They are the numbers for which we want to find the maximum value. n1 is required, but all the other numbers are optional. There can be up to 255 different arguments <\/cite><\/blockquote>\n\n\n\n<p> Empty cells, logical values, or text in the array or reference are ignored. <\/p>\n\n\n\n<p>If there are no numbers in the arguments then the function returns the value 0.<\/p>\n\n\n\n<p>If there are error values in the referenced cells of the arguments, that cannot be translated into numbers then the <strong>MAX<\/strong> function returns an error also.<\/p>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=UkNtbFNGVVZTVmx3czc2WU1xcjlHQi9sVFAvQzZOYjUvUXNZaEdYQ2ZCST0=&b=aEp2dURJT0RyVFNsN1g2ZWVSLzBCRmRtdXNLc1VTZXQzUjl1WHVDSHBEWXNoS2F4ZllzaER1Y2ovcG5GcEMrRWhuWThybVhYcmN4ZGtia0wyZXl0WWJab01HbE1VN3hZdzVCcFppekc0aDg9\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"> <strong>Here are some examples of all the possible uses of MAX:<\/strong> <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Navigate to the cell <strong>J4<\/strong> and insert there the appropriate function to display the maximum value of the cell range <strong>F5:F10<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/d1M3VgPq-bU?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Navigate to the cell <strong>D12<\/strong> and calculate the maximum value of the cell range <strong>D5:G10<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/uMwqEJViuZo?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Enter the appropriate function in the cell <strong>C14<\/strong> so as to calculate the maximum sales figure for January (cell range <strong>C5:C8<\/strong>).<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/6CijGnitoow?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the cell <strong>E116<\/strong> enter a function that calculates the minimum cost for the cell range <strong>E3:E110<\/strong> and in the cell <strong>E117<\/strong> another function that returns the maximum cost for the same cell range.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/6cq0JpL3YIQ?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p> In the cell <strong>B1 <\/strong>of the <strong>Total <\/strong>worksheet insert the appropriate function to sum up the cells within the cell range <strong>A1:A10<\/strong> from the <strong>FF1 <\/strong>worksheet through to the <strong>FF12 <\/strong>worksheet.<br> Insert in the cell <strong>B2 <\/strong>a function that returns the average of the respective cell range, in cell <strong>B3 <\/strong>for the minimum, in cell <strong>B4 <\/strong>for the maximum and in cell <strong>B5 <\/strong>for the total of cells displaying numbers, following the same pattern. <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/IRNzb5Z8i8Q?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The MAX functions returns the largest number in a set of values.<br \/>\nIf you need to get the second or third or n-th largest number in a set of values then you should use the LARGE function.<\/p>\n","protected":false},"author":2,"featured_media":334,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[25,14],"class_list":["post-325","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-max","tag-statistical"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/max.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-5f","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/334"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}