{"id":324,"date":"2019-04-04T14:59:06","date_gmt":"2019-04-04T11:59:06","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=324"},"modified":"2019-04-04T16:26:43","modified_gmt":"2019-04-04T13:26:43","slug":"the-min-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-min-function\/","title":{"rendered":"The MIN function"},"content":{"rendered":"\n<p>The <strong>MIN <\/strong>functions returns the smallest number in a set of values.<\/p>\n\n\n\n<p>If you need to get the second or third or n-th smallest number in a set of values then you should use the <strong><a rel=\"noreferrer noopener\" aria-label=\"SMALL  (opens in a new tab)\" href=\"https:\/\/www.test4u.eu\/excelpedia\/the-small-function\/\" target=\"_blank\">SMALL <\/a><\/strong>function.<\/p>\n\n\n\n<p>The syntax of the <strong>MIN <\/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>MIN(n1, [n2], &#8230;)<\/strong><\/p><cite><strong>n1, n2, &#8230; <\/strong>: They are the numbers for which we want to find the minimum 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>MIN <\/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=SHd5WWNmNVUxWkgydzRXRno1aUlpVjhOYjAyeFJQcEtuWm5oOUdVUkR3OD0=&b=YW5YM0dXVmVDeHIzdCsyeElzbWVpZlhmUUdLempFY2Q1dTRNOWV1Sit5NCsxclVGQnpRMHRIbExGZVBWSXBhbm1SUmMra1ZPQ1pWWFNIcDdtaEh1a3drYVRWQ3V5Qi9xK3hMRVg0eU1PWEU9\">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 MIN:<\/strong> <\/p>\n\n\n\n<p>Use the appropriate function in the cell <strong>J4 <\/strong>to display the lowest value in the cell range <strong>D5:D10<\/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\/Vd7CcI3tZ-k?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 in the cell <strong>E116 <\/strong>a function to calculate the minimum value of the cell range <strong>\u03953:\u0395110<\/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\/vVymUYwTYUk?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 MIN functions returns the smallest number in a set of values.<br \/>\nIf you need to get the second or third or n-th smallest number in a set of values then you should use the SMALL function.<\/p>\n","protected":false},"author":2,"featured_media":331,"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":[24,14],"class_list":["post-324","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-min","tag-statistical"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/min.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-5e","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/324","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=324"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/331"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}