{"id":2851,"date":"2020-04-07T21:04:22","date_gmt":"2020-04-07T19:04:22","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2851"},"modified":"2021-10-30T12:58:27","modified_gmt":"2021-10-30T10:58:27","slug":"a-min-es-a-max-fuggveny-192","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2851","title":{"rendered":"A MIN \u00e9s a MAX f\u00fcggv\u00e9ny (#192)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2851\" class=\"elementor elementor-2851\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4d8042b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4d8042b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7037193\" data-id=\"7037193\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b21b1b4 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"b21b1b4\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 10.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d278279 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d278279\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-794d697\" data-id=\"794d697\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3e6536 elementor-widget elementor-widget-text-editor\" data-id=\"a3e6536\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Mir\u0151l sz\u00f3l ez a cikk?<br \/>A statisztika kev\u00e9s embernek okoz \u00f6r\u00f6m\u00f6t, ak\u00e1r egy iskol\u00e1ban, ak\u00e1r az \u00e9letben tal\u00e1lkozik vele. Ugyanakkor nagyon sokszor v\u00e1lnak hasznoss\u00e1 a statisztikai f\u00fcggv\u00e9nyek, m\u00e9g egy egyszer\u0171 feladat sor\u00e1n is. Emiatt a MIN \u00e9s a MAX f\u00fcggv\u00e9ny, t\u00f6bb m\u00e1s statisztikai f\u00fcggv\u00e9nyhez hasonl\u00f3an, mindig kell\u00e9kei az vizsg\u00e1knak is. Ebben a cikkben ezt a k\u00e9t Excel f\u00fcggv\u00e9nyt vizsg\u00e1ljuk meg.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a219a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a219a2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a02316a\" data-id=\"a02316a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-45a206c elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"45a206c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;fas fa-file-excel&quot;,&quot;library&quot;:&quot;fa-solid&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;no_headings_message&quot;:&quot;Ezen az oldalon nem tal\\u00e1lhat\\u00f3 c\\u00edmsor.&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTartalomjegyz\u00e9k\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__45a206c\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__45a206c\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__45a206c\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-977384c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"977384c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6da374\" data-id=\"f6da374\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64945a8 elementor-widget elementor-widget-text-editor\" data-id=\"64945a8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A cikkben eml\u00edtett egy\u00e9b Excel f\u00fcggv\u00e9nyek a k\u00f6vetkez\u0151k:<\/strong> D\u00c1TUM\u00c9RT\u00c9K, HA, HAMIS, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">HI\u00c1NYZIK<\/a>, ID\u0150\u00c9RT\u00c9K, IGAZ, KICSI, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2985\">MAXA<\/a>, MAXHA, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2985\">MIN2<\/a>, MINHA, NAGY, SZ\u00d6VEG.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5b57d56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b57d56\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3d47bc6\" data-id=\"3d47bc6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8cf4767 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"8cf4767\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny bemutat\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">1. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny bemutat\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-28cc132 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28cc132\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d30bbc9\" data-id=\"d30bbc9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ee37294 elementor-widget elementor-widget-text-editor\" data-id=\"ee37294\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A MIN \u00e9s a MAX f\u00fcggv\u00e9ny a statisztikai f\u00fcggv\u00e9nyek k\u00f6z\u00e9 tartozik \u2013 az argumentumk\u00e9nt megadott numerikus \u00e9rt\u00e9kek k\u00f6z\u00fcl a legkisebbet, illetve a legnagyobbat adj\u00e1k eredm\u00e9ny\u00fcl.<\/strong><\/p>\n\n<p>A f\u00fcggv\u00e9nyek szintaxisa a k\u00f6vetkez\u0151:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2c82e3c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c82e3c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9d4bcf6\" data-id=\"9d4bcf6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6337319 elementor-widget elementor-widget-text-editor\" data-id=\"6337319\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>MIN(<em>arg1[;arg2\u2026]<\/em>)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0010e84 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0010e84\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca5701d\" data-id=\"ca5701d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-099424f elementor-widget elementor-widget-text-editor\" data-id=\"099424f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>MAX(<em>arg1[;arg2\u2026]<\/em>)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7ddced6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ddced6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f18ee86\" data-id=\"f18ee86\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fbbc176 elementor-widget elementor-widget-text-editor\" data-id=\"fbbc176\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>ahol <em>arg1<\/em> \u00e9s <em>arg2 <\/em>a numerikus argumentumokat jelenti. A f\u00fcggv\u00e9ny legal\u00e1bb egy, legfeljebb 255 darab argumentum megad\u00e1s\u00e1t v\u00e1rja. Argumentum lehet konstans (5), cellahivatkoz\u00e1s (A1), tartom\u00e1nyhivatkoz\u00e1s (A1:C10), tartom\u00e1nyn\u00e9v (Oszt\u00e1ly), t\u00f6mb \u00e9s k\u00e9plet, ak\u00e1r vegyesen is.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9662f52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9662f52\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca4c825\" data-id=\"ca4c825\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f34effb elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f34effb\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa numerikus argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa numerikus argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-87191bb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"87191bb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b496654\" data-id=\"b496654\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9f553e8 elementor-widget elementor-widget-text-editor\" data-id=\"9f553e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9ny teh\u00e1t numerikus adatokat v\u00e1r argumentumk\u00e9nt. Az Excel azonban t\u00f6bb numerikus adatt\u00edpussal rendelkezik, ez\u00e9rt nem haszontalan \u00e1ttekinten\u00fcnk, melyiket hogyan haszn\u00e1lhatjuk, mire kell figyeln\u00fcnk \u00e9s melyikkel milyen eredm\u00e9nyre sz\u00e1m\u00edthatunk!<\/p>\n\n<p>Ha konstans \u00e9rt\u00e9keket adunk meg, akkor egyszer\u0171 k\u00e9pleteket kapunk:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6956c77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6956c77\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-889a59d\" data-id=\"889a59d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d85384e elementor-widget elementor-widget-text-editor\" data-id=\"d85384e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cf80d1f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf80d1f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-639e4ef\" data-id=\"639e4ef\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b0c6fcf elementor-widget elementor-widget-text-editor\" data-id=\"b0c6fcf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4e20c40 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e20c40\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0a075e2\" data-id=\"0a075e2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a46a49a elementor-widget elementor-widget-text-editor\" data-id=\"a46a49a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A MIN f\u00fcggv\u00e9ny eredm\u00e9nye 3, a MAX f\u00fcggv\u00e9ny\u00e9 5 \u2013 ez mag\u00e1t\u00f3l \u00e9rtet\u0151d\u0151. Mivel a d\u00e1tum, az id\u0151, a k\u00f6nyvel\u00e9si, a t\u00f6rt, a tudom\u00e1nyos \u00e9s a sz\u00e1zal\u00e9k is numerikus t\u00edpus\u00faak, a k\u00e9t f\u00fcggv\u00e9ny ezekn\u00e9l is a fenti p\u00e9ld\u00e1khoz hasonl\u00f3an m\u0171k\u00f6dik. Ha a felsorolt numerikus form\u00e1tumok vegyesen fordulnak el\u0151 argumentumk\u00e9nt, a k\u00e9t f\u00fcggv\u00e9ny eredm\u00e9nye akkor is t\u00f6bbnyire mag\u00e1t\u00f3l \u00e9rtet\u0151d\u0151. Az\u00e9rt n\u00e9zz\u00fcnk meg n\u00e9h\u00e1ny esetet!<\/p>\n\n<p>D\u00e1tum \u00e9s id\u0151adatokkal dolgozva tartsuk \u00e9szben, hogy <strong>egy d\u00e1tumot az 1900 janu\u00e1r 1-je \u00f3ta eltelt napok sz\u00e1ma, m\u00edg egy id\u0151pontot egy 0 \u00e9s 1 k\u00f6z\u00f6tti t\u00f6rtsz\u00e1m jelk\u00e9pez<\/strong>! N\u00e9zz\u00fcnk egy p\u00e9ld\u00e1t d\u00e1tum t\u00edpus\u00fa adat kezel\u00e9s\u00e9re:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aa868ff elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aa868ff\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-614c802\" data-id=\"614c802\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-32ce1ff elementor-widget elementor-widget-text-editor\" data-id=\"32ce1ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(D\u00c1TUM\u00c9RT\u00c9K(&#8222;20\/4\/14&#8221;);43936)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1b3e1cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b3e1cf\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-45f4f4d\" data-id=\"45f4f4d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2178b79 elementor-widget elementor-widget-text-editor\" data-id=\"2178b79\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(D\u00c1TUM\u00c9RT\u00c9K(&#8222;20\/4\/14&#8221;);43936)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c29191 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c29191\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-78f1cf1\" data-id=\"78f1cf1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90a2453 elementor-widget elementor-widget-text-editor\" data-id=\"90a2453\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A 43935 sz\u00e1m 2020 \u00e1prilis 14-e, m\u00edg a 43936 sz\u00e1m 2020 \u00e1prilis 15-e sorsz\u00e1ma. \u00cdgy a MIN f\u00fcggv\u00e9ny eredm\u00e9nye 43935, a MAX f\u00fcggv\u00e9ny\u00e9 pedig 43936. Ha a fenti k\u00e9t k\u00e9pletet beg\u00e9pelj\u00fck egy-egy cell\u00e1ba, akkor a sorsz\u00e1mokat kapjuk eredm\u00e9ny\u00fcl, de ha hozz\u00e1juk rendel\u00fcnk egy d\u00e1tumform\u00e1tumot, akkor m\u00e1r d\u00e1tumk\u00e9nt l\u00e1tjuk viszont a k\u00e9t eredm\u00e9nyt. Hasonl\u00f3an egyszer\u0171 az id\u0151pontok kezel\u00e9se, \u00e9rtelmez\u00e9se is:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cebc6fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cebc6fe\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-74113d2\" data-id=\"74113d2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-26b11c7 elementor-widget elementor-widget-text-editor\" data-id=\"26b11c7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(ID\u0150\u00c9RT\u00c9K(&#8222;12:00&#8221;);0,6)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bc5536d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc5536d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-09ef032\" data-id=\"09ef032\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-20f98a8 elementor-widget elementor-widget-text-editor\" data-id=\"20f98a8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(ID\u0150\u00c9RT\u00c9K(&#8222;12:00&#8221;);0,6)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cac6f44 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cac6f44\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5888825\" data-id=\"5888825\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-eb8fc20 elementor-widget elementor-widget-text-editor\" data-id=\"eb8fc20\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A d\u00e9li 12 \u00f3ra az Excelben 0,5-el egyenl\u0151, \u00edgy a MIN eredm\u00e9nye 0,5, a MAX eredm\u00e9nye 0,6.<\/p>\n\n<p>N\u00e9zz\u00fcnk egy m\u00e1sik numerikus adatt\u00edpust, a sz\u00e1zal\u00e9kot! Az al\u00e1bbi k\u00e9t k\u00e9pletben sz\u00e1zal\u00e9k \u00e9s sz\u00e1m egy\u00fctt szerepel:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8b2f43b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b2f43b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d205ad8\" data-id=\"d205ad8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4cfd8bd elementor-widget elementor-widget-text-editor\" data-id=\"4cfd8bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(10%;25)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31ebab5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31ebab5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5c43cca\" data-id=\"5c43cca\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b9c0b8 elementor-widget elementor-widget-text-editor\" data-id=\"0b9c0b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(10%;25)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31495c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31495c4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d0198ab\" data-id=\"d0198ab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0729c39 elementor-widget elementor-widget-text-editor\" data-id=\"0729c39\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tudjuk, hogy a sz\u00e1zal\u00e9k sz\u00e1mform\u00e1tum\u00fa adat val\u00f3j\u00e1ban sz\u00e1zzal osztott \u00e9rt\u00e9ket jelent, \u00edgy a MIN eredm\u00e9nye 0,1, a MAX eredm\u00e9nye 25 lesz.<\/p>\n\n<p>K\u00f6vetkezzen a <strong>K\u00f6nyvel\u00e9si Sz\u00e1mform\u00e1tum<\/strong> vegyes alkalmaz\u00e1sa:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-12d23f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12d23f5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c822a39\" data-id=\"c822a39\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f25d99c elementor-widget elementor-widget-text-editor\" data-id=\"f25d99c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(SZ\u00d6VEG(10000;&#8221;0 Ft&#8221;);12000)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d1a5203 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d1a5203\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9ac457d\" data-id=\"9ac457d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2449120 elementor-widget elementor-widget-text-editor\" data-id=\"2449120\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(SZ\u00d6VEG(10000;&#8221;0 Ft&#8221;);12000)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6b37a12 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b37a12\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5c33dc8\" data-id=\"5c33dc8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-009acfa elementor-widget elementor-widget-text-editor\" data-id=\"009acfa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A MIN eredm\u00e9nye 10000, a MAX f\u00fcggv\u00e9ny\u00e9 12000.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43dbfd0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43dbfd0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-943b66d\" data-id=\"943b66d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2cc1a96 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"2cc1a96\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa sz\\u00f6vegk\\u00e9nt megadott numerikus argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa sz\u00f6vegk\u00e9nt megadott numerikus argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-059b3ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"059b3ab\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0ea51f6\" data-id=\"0ea51f6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4bf2774 elementor-widget elementor-widget-text-editor\" data-id=\"4bf2774\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sz\u00f6vegk\u00e9nt megadott numerikus \u00e9rt\u00e9k argumentumk\u00e9nt val\u00f3 megad\u00e1s\u00e1ra az el\u0151bb l\u00e1ttunk p\u00e9ld\u00e1t. Tapasztaltuk, hogy mindk\u00e9t f\u00fcggv\u00e9ny k\u00e9pes felismerni az egy\u00e9rtelm\u0171en sz\u00e1mk\u00e9nt \u00e9rtelmezhet\u0151 sz\u00f6veget, azt k\u00e9pes \u00e1talak\u00edtani numerikus \u00e9rt\u00e9kk\u00e9 \u00e9s a sz\u00e1m\u00edt\u00e1sba bevonni. De n\u00e9zz\u00fcnk egy kev\u00e9sb\u00e9 \u00f6sszetett p\u00e9ld\u00e1t, mire is gondolunk, amikor sz\u00f6vegk\u00e9nt megadott numerikus adatot adunk meg argumentumk\u00e9nt:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-257e27d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"257e27d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ba63684\" data-id=\"ba63684\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6c20c86 elementor-widget elementor-widget-text-editor\" data-id=\"6c20c86\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(&#8222;20&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dd1dbee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd1dbee\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5974a7e\" data-id=\"5974a7e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ae8b8ad elementor-widget elementor-widget-text-editor\" data-id=\"ae8b8ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(&#8222;20&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-88d7de2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"88d7de2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f8d0930\" data-id=\"f8d0930\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a41fa5 elementor-widget elementor-widget-text-editor\" data-id=\"1a41fa5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A h\u00faszas sz\u00e1mot macskak\u00f6rm\u00f6k <em>(Shift+2)<\/em> k\u00f6z\u00e9 z\u00e1rtuk, vagyis sz\u00f6vegk\u00e9nt adtuk meg. Mindk\u00e9t f\u00fcggv\u00e9ny visszaalak\u00edtja sz\u00e1mm\u00e1 a &#8222;20&#8221; karakterl\u00e1ncot, majd ezut\u00e1n v\u00e9gzi el a m\u0171veletet: a MIN eredm\u00e9nye 20, a MAX eredm\u00e9nye 50 lesz. A tizedes t\u00f6rt alakban fel\u00edrt sz\u00e1mokat is felismeri az Excel, teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9pletek is az elv\u00e1rt eredm\u00e9nyt fogj\u00e1k szolg\u00e1ltatni:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d56a7c9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d56a7c9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-998f58b\" data-id=\"998f58b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2d8589 elementor-widget elementor-widget-text-editor\" data-id=\"f2d8589\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(&#8222;20,5&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c9f92e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c9f92e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61a733c\" data-id=\"61a733c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-feded68 elementor-widget elementor-widget-text-editor\" data-id=\"feded68\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(&#8222;20,5&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5fe6dad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5fe6dad\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-38e9c74\" data-id=\"38e9c74\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b861213 elementor-widget elementor-widget-text-editor\" data-id=\"b861213\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9nyek sz\u00e1mk\u00e9nt kezelik a <strong>Sz\u00f6veg Sz\u00e1mform\u00e1tummal<\/strong> form\u00e1zott cell\u00e1ban elhelyezett sz\u00e1mot, vagy az <strong>=&#8221;120,55&#8243;<\/strong> k\u00e9plet eredm\u00e9ny\u00e9t is.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b411ab7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b411ab7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d06c1ab\" data-id=\"d06c1ab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-681a8ad elementor-widget elementor-widget-text-editor\" data-id=\"681a8ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A <strong>sz\u00f6vegk\u00e9nt megadott sz\u00e1m<\/strong> \u00e9s a <strong>sz\u00e1mot tartalmaz\u00f3 sz\u00f6veg<\/strong> (p\u00e9ld\u00e1ul 2020.) nem ugyanazt jelenti. Az ut\u00f3bbi esetben az Excel nem k\u00e9pes kiolvasni a karaktersorozatb\u00f3l a sz\u00e1mot, teh\u00e1t ne v\u00e1rjuk el, hogy a &#8222;50.&#8221; vagy a &#8222;5000\u20ac&#8221; helyes eredm\u00e9nyt ad. Ha ilyen adatokkal kell dolgoznunk, akkor el\u0151tte v\u00e9gezz\u00fcnk adattiszt\u00edt\u00e1st, vagyis gondoskodjunk arr\u00f3l, hogy az \u00e9rt\u00e9kek megfelel\u0151 adatt\u00edpus\u00faak legyenek. Ha m\u00e9gis ragaszkodnunk kell az adatok megjelen\u00e9s\u00e9hez, akkor ut\u00f3lag form\u00e1zzunk, alkalmazzunk egy\u00e9ni sz\u00e1mform\u00e1tumot vagy vess\u00fck be az adatt\u00edpusok k\u00f6z\u00f6tti \u00e1talak\u00edt\u00e1st v\u00e9gz\u0151 f\u00fcggv\u00e9nyeket.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3e2ccc7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e2ccc7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be830e9\" data-id=\"be830e9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3ddf708 elementor-widget elementor-widget-text-editor\" data-id=\"3ddf708\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mivel mindk\u00e9t f\u00fcggv\u00e9ny numerikus t\u00edpus\u00fa argumentumokat v\u00e1r, a k\u00f6vetkez\u0151 adatt\u00edpusok alkalmaz\u00e1sa fokozott \u00f3vatoss\u00e1got ig\u00e9nyel. Logikai \u00e9s sz\u00f6veges argumentumokat val\u00f3sz\u00edn\u0171leg nem fogunk a f\u00fcggv\u00e9nyeknek adni, ugyanakkor \u00fcres cella \u00e9s hiba\u00e9rt\u00e9k nagyon is el\u0151fordulhat az argumentumok k\u00f6z\u00f6tt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d67a8b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d67a8b0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9c61dec\" data-id=\"9c61dec\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7a05c78 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"7a05c78\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa logikai argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">4. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa logikai argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-550319b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"550319b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-affea21\" data-id=\"affea21\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-83a3e9d elementor-widget elementor-widget-text-editor\" data-id=\"83a3e9d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A logikai t\u00edpus\u00fa adatokat k\u00e9tf\u00e9le m\u00f3don \u00e9rtelmezi mindk\u00e9t f\u00fcggv\u00e9ny. <strong>Ha az IGAZ \u00e9s a HAMIS konstansk\u00e9nt, IGAZ vagy HAMIS f\u00fcggv\u00e9nyk\u00e9nt, vagy logikai eredm\u00e9nyt szolg\u00e1ltat\u00f3 be\u00e1gyazott f\u00fcggv\u00e9nyk\u00e9nt vagy k\u00e9pletk\u00e9nt jelenik meg a z\u00e1r\u00f3jelek k\u00f6z\u00f6tt, akkor az IGAZ \u00e9rt\u00e9ket 1-el, a HAMIS \u00e9rt\u00e9ket 0-val helyettes\u00edti az Excel, vagyis numerikus t\u00edpus\u00fa adatt\u00e1 alak\u00edtja ezt a k\u00e9t logikai \u00e9rt\u00e9ket.<\/strong> Gy\u0151z\u0151dj\u00fcnk meg a le\u00edrtakr\u00f3l kipr\u00f3b\u00e1lva az al\u00e1bbi k\u00e9pleteket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-651816a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"651816a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b8f953\" data-id=\"4b8f953\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab88008 elementor-widget elementor-widget-text-editor\" data-id=\"ab88008\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(IGAZ;HAMIS)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1629dd1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1629dd1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-88b61e1\" data-id=\"88b61e1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8c9900a elementor-widget elementor-widget-text-editor\" data-id=\"8c9900a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(IGAZ;HAMIS)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8a59da2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a59da2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a29fe12\" data-id=\"a29fe12\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f587d47 elementor-widget elementor-widget-text-editor\" data-id=\"f587d47\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A MIN eredm\u00e9nye 0, a MAX eredm\u00e9nye 1. Ha a cell\u00e1ban sz\u00e1mok helyett logikai \u00e9rt\u00e9keket akarunk eredm\u00e9ny\u00fcl l\u00e1tni, akkor haszn\u00e1ljuk az al\u00e1bbi k\u00e9pleteket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae0203a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae0203a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-288205b\" data-id=\"288205b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5446b54 elementor-widget elementor-widget-text-editor\" data-id=\"5446b54\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MIN(IGAZ;HAMIS)=1;IGAZ;HAMIS)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b56aae1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b56aae1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-01ce2f1\" data-id=\"01ce2f1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3c0dcec elementor-widget elementor-widget-text-editor\" data-id=\"3c0dcec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MAX(IGAZ;HAMIS)=1;IGAZ;HAMIS)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c93ac49 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c93ac49\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3f487e6\" data-id=\"3f487e6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9bedb91 elementor-widget elementor-widget-text-editor\" data-id=\"9bedb91\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A k\u00e9pletekben konstansk\u00e9nt illesztett\u00fck be a k\u00e9t logikai \u00e9rt\u00e9ket. Ahogy fentebb eml\u00edtett\u00fck, mindkett\u0151 konstanst helyettes\u00edthetj\u00fck az IGAZ \u00e9s a HAMIS f\u00fcggv\u00e9nnyel:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce2ed9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce2ed9e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-18e7652\" data-id=\"18e7652\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8e34fd2 elementor-widget elementor-widget-text-editor\" data-id=\"8e34fd2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MIN(IGAZ();HAMIS())=1;IGAZ();HAMIS())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-285ef35 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"285ef35\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-12d81d1\" data-id=\"12d81d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a28329 elementor-widget elementor-widget-text-editor\" data-id=\"0a28329\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MAX(IGAZ();HAMIS())=1;IGAZ();HAMIS())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5546641 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5546641\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9bd880f\" data-id=\"9bd880f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dab4eaa elementor-widget elementor-widget-text-editor\" data-id=\"dab4eaa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00cdgy lesz az eredm\u00e9ny HAMIS, illetve IGAZ. Na j\u00f3, nem bonyol\u00edtjuk tov\u00e1bb\u2026ink\u00e1bb vess\u00fcnk egy pillant\u00e1st olyan k\u00e9pletekre, amelyek logikai felt\u00e9teleket tartalmaznak:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2870290 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2870290\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4aae0e2\" data-id=\"4aae0e2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7841357 elementor-widget elementor-widget-text-editor\" data-id=\"7841357\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(5&gt;3;5&lt;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-192f048 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"192f048\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-998add0\" data-id=\"998add0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-96a3f26 elementor-widget elementor-widget-text-editor\" data-id=\"96a3f26\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(5&gt;3;5&lt;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3a80b1a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a80b1a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-860c049\" data-id=\"860c049\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c077e20 elementor-widget elementor-widget-text-editor\" data-id=\"c077e20\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A MIN eredm\u00e9nye 0, a MAX eredm\u00e9nye 1. Na, csak most \u00e9s utolj\u00e1ra, hadd \u00e9p\u00edts\u00fck be mindkett\u0151t a HA f\u00fcggv\u00e9nybe, hogy 0 \u00e9s 1 helyett HAMIS \u00e9s IGAZ eredm\u00e9nyt kapjunk!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a980c12 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a980c12\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6423288\" data-id=\"6423288\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d5a11df elementor-widget elementor-widget-text-editor\" data-id=\"d5a11df\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MIN(5&gt;3;5&lt;3)=1;IGAZ();HAMIS())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-36e22f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36e22f2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-716a031\" data-id=\"716a031\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ebb9014 elementor-widget elementor-widget-text-editor\" data-id=\"ebb9014\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=HA(MAX(5&gt;3;5&lt;3)=1;IGAZ();HAMIS())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0a641a9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a641a9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3126b87\" data-id=\"3126b87\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f3fc8ef elementor-widget elementor-widget-text-editor\" data-id=\"f3fc8ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>De milyen eredm\u00e9nyt kapunk, <strong>ha az argumentum egy hivatkoz\u00e1s logikai \u00e9rt\u00e9ket tartalmaz\u00f3 cell\u00e1ra, vagy az argumentumok k\u00f6z\u00f6tt egy vagy t\u00f6bb ilyen hivatkoz\u00e1s tal\u00e1lhat\u00f3<\/strong>? N\u00e9zz\u00fck csak a k\u00f6vetkez\u0151 k\u00e9pleteket, amelyek az A1:A2 tartom\u00e1nyra hivatkoznak \u2013 a k\u00e9t cell\u00e1ba az IGAZ \u00e9s a HAMIS \u00e9rt\u00e9keket helyezt\u00fck el:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-24cf967 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"24cf967\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2615b4d\" data-id=\"2615b4d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-22160e8 elementor-widget elementor-widget-text-editor\" data-id=\"22160e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(A1:A2)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-32f75d4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32f75d4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-93b96c9\" data-id=\"93b96c9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dcfedcc elementor-widget elementor-widget-text-editor\" data-id=\"dcfedcc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(A1:A2)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c9fef39 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c9fef39\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3daa40\" data-id=\"d3daa40\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c51078 elementor-widget elementor-widget-text-editor\" data-id=\"0c51078\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mindk\u00e9t k\u00e9plet eredm\u00e9nye nulla. Bizony, hivatkozott cell\u00e1ban vagy tartom\u00e1nyban l\u00e9v\u0151 logikai \u00e9rt\u00e9keket null\u00e1nak tekinti mindk\u00e9t f\u00fcggv\u00e9ny \u2013 de vigy\u00e1zzunk, ez nem ennyire egy\u00e9rtelm\u0171! N\u00e9zz\u00fcnk egy m\u00e1sik p\u00e9ld\u00e1t, csak hogy fokozzuk a zavart:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8a4e4c3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a4e4c3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e4d7454\" data-id=\"e4d7454\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1070cf7 elementor-widget elementor-widget-text-editor\" data-id=\"1070cf7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(A1:A2;5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70e3c43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70e3c43\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9b451e5\" data-id=\"9b451e5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6093308 elementor-widget elementor-widget-text-editor\" data-id=\"6093308\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(A1:A2;5;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2ddd5a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2ddd5a8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-69420ee\" data-id=\"69420ee\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bf2b80a elementor-widget elementor-widget-text-editor\" data-id=\"bf2b80a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A MAX k\u00e9plet eredm\u00e9nye 5. De mit gondolunk, mi a MIN k\u00e9plet eredm\u00e9nye? Bizony nem nulla, hanem 3! Ajaj! H\u00e1t ez a nulla nem nulla? Nem bizony, a <strong>m\u00e1sik \u00e9rtelmez\u00e9s szerint a<\/strong> <strong>hivatkozott cell\u00e1ban vagy tartom\u00e1nyban l\u00e9v\u0151 logikai \u00e9rt\u00e9keket nem veszi figyelembe a f\u00fcggv\u00e9ny<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e365e07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e365e07\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7b76f15\" data-id=\"7b76f15\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7c55c8a elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"7c55c8a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa sz\\u00f6veg t\\u00edpus\\u00fa argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">5. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa sz\u00f6veg t\u00edpus\u00fa argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-122b10b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"122b10b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f3134d\" data-id=\"5f3134d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c3f3873 elementor-widget elementor-widget-text-editor\" data-id=\"c3f3873\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha a hivatkozott argumentumok k\u00f6z\u00f6tt sz\u00f6veg t\u00edpus\u00fa adat tal\u00e1lhat\u00f3, bele\u00e9rtve az \u00fcres karakterl\u00e1ncot (&#8222;&#8221;) is, akkor azt mindk\u00e9t f\u00fcggv\u00e9ny figyelmen k\u00edv\u00fcl hagyja. Ha minden hivatkozott argumentum sz\u00f6veg t\u00edpus\u00fa adat, akkor a k\u00e9t f\u00fcggv\u00e9ny nulla eredm\u00e9nyt ad. Ha sz\u00f6veget konstansk\u00e9nt adunk meg a z\u00e1r\u00f3jelek k\u00f6z\u00f6tt, akkor az #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9ket kapjuk. L\u00e1ssunk a le\u00edrtakra egy-egy p\u00e9ld\u00e1t!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6970043 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6970043\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61d5564\" data-id=\"61d5564\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a07287 elementor-widget elementor-widget-text-editor\" data-id=\"9a07287\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(&#8222;Ez egy sz\u00f6veg&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-703ad43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"703ad43\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1fa3142\" data-id=\"1fa3142\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71b2891 elementor-widget elementor-widget-text-editor\" data-id=\"71b2891\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(&#8222;Ez egy sz\u00f6veg&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4a5d1cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4a5d1cd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a46726f\" data-id=\"a46726f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bc88196 elementor-widget elementor-widget-text-editor\" data-id=\"bc88196\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(&#8222;&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-00691bb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00691bb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9cc4e0d\" data-id=\"9cc4e0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93e859d elementor-widget elementor-widget-text-editor\" data-id=\"93e859d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(&#8222;&#8221;;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-02ee3df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"02ee3df\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2a4efb1\" data-id=\"2a4efb1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d85b2ff elementor-widget elementor-widget-text-editor\" data-id=\"d85b2ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mindegyik k\u00e9plet eredm\u00e9nye a #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9k. Ha az &#8222;Ez egy sz\u00f6veg&#8221; vagy az \u00fcres karakterl\u00e1nc (=&#8221;&#8221;) az A1 cell\u00e1ban tal\u00e1lhat\u00f3, akkor a k\u00f6vetkez\u0151 k\u00e9pletek eredm\u00e9nye 50, mivel az A1 cella \u00e9rt\u00e9k\u00e9t a f\u00fcggv\u00e9nyek figyelmen k\u00edv\u00fcl hagyj\u00e1k.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4abad23 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4abad23\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a076957\" data-id=\"a076957\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-995f449 elementor-widget elementor-widget-text-editor\" data-id=\"995f449\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(A1;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d69427 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d69427\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a46b9f7\" data-id=\"a46b9f7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f8c76ea elementor-widget elementor-widget-text-editor\" data-id=\"f8c76ea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(A1;50)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-78b332a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"78b332a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b0b18fb\" data-id=\"b0b18fb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ceeaa2d elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ceeaa2d\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;6. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa \\u00fcres cell\\u00e1kra hivatkoz\\u00f3 argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">6. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa \u00fcres cell\u00e1kra hivatkoz\u00f3 argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f637871 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f637871\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cd53abb\" data-id=\"cd53abb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9cf262d elementor-widget elementor-widget-text-editor\" data-id=\"9cf262d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Nem olyan egy\u00e9rtelm\u0171 a k\u00e9t f\u00fcggv\u00e9ny \u00e1ltal szolg\u00e1ltatott eredm\u00e9ny, mint hinn\u00e9nk, b\u00e1r az eddig le\u00edrtak alapj\u00e1n sejtj\u00fck, hogy nem egy nagy nulla. N\u00e9zz\u00fck csak a k\u00f6vetkez\u0151 k\u00e9pletet \u2013 felt\u00e9telezve, hogy a hivatkozott tartom\u00e1ny cell\u00e1i \u00fcresek:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c17a1c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c17a1c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3e30342\" data-id=\"3e30342\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-03eb507 elementor-widget elementor-widget-text-editor\" data-id=\"03eb507\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(A1:A10;50;10)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-313d668 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"313d668\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3a65353\" data-id=\"3a65353\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-600e17c elementor-widget elementor-widget-text-editor\" data-id=\"600e17c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(A1:A10;50;10)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-565d5a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"565d5a7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-10ba218\" data-id=\"10ba218\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1111dc9 elementor-widget elementor-widget-text-editor\" data-id=\"1111dc9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha a MIN k\u00e9pletre 10-et, a MAX k\u00e9pletre 50-et v\u00e1rtunk, j\u00f3l gondoltuk! <strong>A kor\u00e1bbi fejezetekben l\u00e1ttuk, hogy hivatkoz\u00e1sokban szerepl\u0151 logikai \u00e9rt\u00e9ket, sz\u00f6veget vagy \u00fcres karakterl\u00e1ncot nem veszi figyelembe a f\u00fcggv\u00e9ny, de \u00edgy tesz az \u00fcres cell\u00e1val is.<\/strong> Ez a kett\u0151s \u00e9rtelmez\u00e9s (hol nulla \u00e9s egy a logikai t\u00edpus\u00fa adatokn\u00e1l, hol figyelembe nem vett adat) nagyon zavar\u00f3 tud lenni, nehezen felder\u00edthet\u0151 hib\u00e1t okozhat. \u00c9ppen ez\u00e9rt, ha numerikust\u00f3l elt\u00e9r\u0151 t\u00edpus\u00fa adatokkal akarunk dolgozni, akkor haszn\u00e1ljuk a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2985\">MIN2<\/a> \u00e9s a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2985\">MAXA<\/a> f\u00fcggv\u00e9nyt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-985d48d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"985d48d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4f3b849\" data-id=\"4f3b849\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-73a9374 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"73a9374\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;7. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa hiba\\u00e9rt\\u00e9ket tartalmaz\\u00f3 argumentum eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">7. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1sa hiba\u00e9rt\u00e9ket tartalmaz\u00f3 argumentum eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c1020a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1020a3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a93f5aa\" data-id=\"a93f5aa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c5cda7 elementor-widget elementor-widget-text-editor\" data-id=\"1c5cda7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A hiba\u00e9rt\u00e9kre hiba\u00e9rt\u00e9k a v\u00e1lasz. Ha az argumentumlist\u00e1ban t\u00f6bb elt\u00e9r\u0151 hiba\u00e9rt\u00e9k is jelen van, akkor az els\u0151 hiba\u00e9rt\u00e9ket fogjuk eredm\u00e9ny\u00fcl kapni. Az al\u00e1bbi k\u00e9t k\u00e9pletben azt szeml\u00e9ltett\u00fck, hogy a null\u00e1val val\u00f3 oszt\u00e1s k\u00eds\u00e9rlete \u00e9s egy #HI\u00c1NYZIK hiba\u00e9rt\u00e9k a k\u00e9t f\u00fcggv\u00e9nyn\u00e9l milyen eredm\u00e9nyt ad:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9c2fd0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9c2fd0e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8cfdd30\" data-id=\"8cfdd30\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-433cb89 elementor-widget elementor-widget-text-editor\" data-id=\"433cb89\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MIN(3\/0;HI\u00c1NYZIK())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2104012 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2104012\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4a2f0e6\" data-id=\"4a2f0e6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-41409c2 elementor-widget elementor-widget-text-editor\" data-id=\"41409c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=MAX(3\/0;HI\u00c1NYZIK())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a882249 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a882249\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f4cb78b\" data-id=\"f4cb78b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b435862 elementor-widget elementor-widget-text-editor\" data-id=\"b435862\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mivel els\u0151k\u00e9nt a null\u00e1val val\u00f3 oszt\u00e1sra tett\u00fcnk k\u00eds\u00e9rletet, mindk\u00e9t esetben a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9ket kapjuk eredm\u00e9ny\u00fcl. Ha megcser\u00e9lj\u00fck a k\u00e9t argumentumot, akkor a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k lesz az eredm\u00e9ny.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-20a49f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"20a49f3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7daa1d2\" data-id=\"7daa1d2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-527d690 elementor-widget elementor-widget-text-editor\" data-id=\"527d690\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Mivel a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k vagy a HI\u00c1NYZIK f\u00fcggv\u00e9ny jelenl\u00e9te, alkalmaz\u00e1sa javasolt a hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9s\u00e9re, a k\u00e9t f\u00fcggv\u00e9ny helyett c\u00e9lszer\u0171bb a MINHA \u00e9s a MAXHA f\u00fcggv\u00e9nyt alkalmazni, p\u00e9ld\u00e1ul:<br \/><strong>=MINHA(C1:C10;C1:C10;&#8221;&lt;&gt;#HI\u00c1NYZIK&#8221;)<\/strong><br \/>A MINHA \u00e9s a MAXHA f\u00fcggv\u00e9nnyel figyelmen k\u00edv\u00fcl hagyjuk a hi\u00e1nyz\u00f3 adatokat, \u00edgy re\u00e1lis eredm\u00e9nyt kapunk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5384afb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5384afb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8436a1a\" data-id=\"8436a1a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52c31b6 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"52c31b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8. A MIN \\u00e9s a MAX f\\u00fcggv\\u00e9ny alkalmaz\\u00e1s\\u00e1nak \\u00f6sszefoglal\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">8. A MIN \u00e9s a MAX f\u00fcggv\u00e9ny alkalmaz\u00e1s\u00e1nak \u00f6sszefoglal\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9de2865 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9de2865\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7f43b0c\" data-id=\"7f43b0c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-574b516 elementor-widget elementor-widget-text-editor\" data-id=\"574b516\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eddig olvasottak alapj\u00e1n bel\u00e1that\u00f3, hogy a MIN \u00e9s a MAX f\u00fcggv\u00e9ny k\u00f6nnyen haszn\u00e1lhat\u00f3 numerikus adatokkal. \u00d3vatosan akkor kell elj\u00e1rnunk, ha egy\u00e9b adatt\u00edpus\u00fa adat keveredik az argumentumok k\u00f6z\u00e9. A #HI\u00c1NYZIK hiba\u00e9rt\u00e9k tervezett el\u0151fordul\u00e1sa a hi\u00e1nyz\u00f3 adatok jelz\u00e9s\u00e9re mindenk\u00e9ppen v\u00e1rhat\u00f3, illetve alkalmazand\u00f3, a t\u00f6bbi hiba\u00e9rt\u00e9k megjelen\u00e9se eredm\u00e9nyk\u00e9nt azonban jav\u00edtand\u00f3 hib\u00e1t jelez.<\/p>\n\n<p>A fentiek \u00f6sszefoglal\u00e1s\u00e1hoz seg\u00edts\u00e9g\u00fcnkre lehet az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>, amely a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">192-K-Excel-MIN, MAX f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka1 munkalapj\u00e1t mutatja. \u00c9rtelmezz\u00fck a MIN \u00e9s a MAX f\u00fcggv\u00e9nyek \u00e1ltal a 8:9 sorokban szolg\u00e1ltatott eredm\u00e9nyeket!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c94f851 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c94f851\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a694a6b\" data-id=\"a694a6b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-da96b29 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"da96b29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az A oszlopban kiz\u00e1r\u00f3lag sz\u00f6veg t\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k, \u00edgy mindk\u00e9t f\u00fcggv\u00e9ny eredm\u00e9nye nulla.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A B1 cell\u00e1ban sz\u00f6vegk\u00e9nt tal\u00e1lhat\u00f3 egy 1-es sz\u00e1m, \u00edgy ez lesz a legkisebb sz\u00e1m, egyben a MIN f\u00fcggv\u00e9ny eredm\u00e9nye is. A B7 cella tartalma sz\u00f6veg, a MAX f\u00fcggv\u00e9ny nem veszi figyelembe, emiatt lesz a legnagyobb \u00e9rt\u00e9k 6.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A C oszlop logikai \u00e9rt\u00e9keket \u00e9s \u00fcres cell\u00e1kat tartalmaz, \u00e9s ahogy \u00edrtuk, logikai adatokra hivatkozva null\u00e1t kapunk eredm\u00e9ny\u00fcl, m\u00edg az \u00fcres cell\u00e1kat nem veszik figyelembe a f\u00fcggv\u00e9nyek.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A D:G oszlopok azonos t\u00edpus\u00fa numerikus adatokat tartalmaznak, \u00edgy a f\u00fcggv\u00e9nyek eredm\u00e9nye nyilv\u00e1nval\u00f3. Az eredm\u00e9nyeket m\u00e1r megform\u00e1ztuk az adott oszlop \u00e9rt\u00e9keihez hasonl\u00f3an.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A H oszlop eredm\u00e9nyeinek \u00e9rtelmez\u00e9s\u00e9n\u00e9l der\u00fcl ki, meg\u00e9rtett\u00fck-e a kor\u00e1bban le\u00edrtakat a vegyes adatt\u00edpus\u00fa argumentumokr\u00f3l. A H1:H3 cell\u00e1kat a f\u00fcggv\u00e9ny nem veszi figyelembe, mivel adatt\u00edpusuk nem numerikus: a H1 tartalma sz\u00f6veg; a H2 tartalma \u00fcres karakterl\u00e1nc, szint\u00e9n sz\u00f6veg; \u00e9s a H3 tartalma a HAMIS logikai \u00e9rt\u00e9k. Az eredm\u00e9nyeket a H4:H7 cell\u00e1k tartalma alapj\u00e1n kapjuk: a H4 d\u00e1tum\u00e1nak 43924 az \u00e9rt\u00e9ke; a 16:05 id\u0151pontot a 0,670138889 sz\u00e1m helyettes\u00edti, a 25% sz\u00e1zzal osztott \u00e9rt\u00e9ke 0,25; \u00e9s a 22-es sz\u00e1m. \u00cdgy a MIN 0,25 eredm\u00e9nye a H6, a MAX eredm\u00e9nye pedig a H4 cella tartalm\u00e1nak k\u00f6sz\u00f6nhet\u0151.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">V\u00e9g\u00fcl az I oszlop hiba\u00e9rt\u00e9kei szint\u00e9n a v\u00e1rt eredm\u00e9nyeket szolg\u00e1ltatj\u00e1k, vagyis a tartom\u00e1ny els\u0151 hiba\u00e9rt\u00e9k\u00e9t adta eredm\u00e9ny\u00fcl mindk\u00e9t f\u00fcggv\u00e9ny. Az alattuk tal\u00e1lhat\u00f3 \u00fcres cell\u00e1kat egyik f\u00fcggv\u00e9ny sem veszi figyelembe.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce585cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce585cb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bed0293\" data-id=\"bed0293\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f1fc8e2 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"f1fc8e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg\" class=\"attachment-large size-large wp-image-2989\" alt=\"1. \u00e1bra: A MIN \u00e9s a MAX f\u00fcggv\u00e9nyek \u00e1ltal kezelt adatt\u00edpusok.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_1_Munka1.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A <strong>MIN <\/strong>\u00e9s a <strong>MAX <\/strong>f\u00fcggv\u00e9nyek \u00e1ltal kezelt adatt\u00edpusok.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-50cde73 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50cde73\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa0f83a\" data-id=\"fa0f83a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b14d58 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"4b14d58\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9. K\\u00e9rd\\u00e9sek \\u00e9s v\\u00e1laszok&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9. K\u00e9rd\u00e9sek \u00e9s v\u00e1laszok<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-39490bc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"39490bc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b8123c2\" data-id=\"b8123c2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c5b886 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"5c5b886\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.1. Mi a f\\u00fcggv\\u00e9nyek angol nyelv\\u0171 Excelben haszn\\u00e1lhat\\u00f3 neve?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9.1. Mi a f\u00fcggv\u00e9nyek angol nyelv\u0171 Excelben haszn\u00e1lhat\u00f3 neve?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c46b5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c46b5d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5e31f27\" data-id=\"5e31f27\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-86a3add elementor-widget elementor-widget-text-editor\" data-id=\"86a3add\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9nyek neve nem meglep\u0151 m\u00f3don MIN \u00e9s MAX.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3708c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3708c2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7507ce3\" data-id=\"7507ce3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fa20153 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"fa20153\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.2. Hogyan haszn\\u00e1lom ezt a k\\u00e9t f\\u00fcggv\\u00e9nyt egy \\u00f6sszef\\u00fcgg\\u0151 t\\u00e1bl\\u00e1zat sorainak \\u00e9s oszlopainak kisz\\u00e1m\\u00edt\\u00e1s\\u00e1ra?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9.2. Hogyan haszn\u00e1lom ezt a k\u00e9t f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-291bf25 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"291bf25\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bf9acc8\" data-id=\"bf9acc8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-70c06c6 elementor-widget elementor-widget-text-editor\" data-id=\"70c06c6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Gyakori feladat, amikor egy \u00f6sszef\u00fcgg\u0151, t\u00e9glalap alak\u00fa t\u00e1bl\u00e1zat adatsoraiban \u00e9s adatoszlopaiban kell a k\u00e9t f\u00fcggv\u00e9nnyel a legkisebb \u00e9s legnagyobb \u00e9rt\u00e9keket kikerestetn\u00fcnk. Az ilyen feladatokban \u00e1ltal\u00e1ban az a k\u00e9r\u00e9s, hogy keress\u00fck meg a legkisebb vagy legnagyobb \u00e9rt\u00e9ket az ilyen-olyan oszlopokban vagy sorokban, \u00e9s jelen\u00edts\u00fck meg azokat az oszlopok alatti sorban, illetve a sorok melletti oszlopban. A\u00a0megfogalmaz\u00e1s els\u0151 hall\u00e1sra bonyolult, pedig csup\u00e1n arr\u00f3l van sz\u00f3, hogy:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ef4586 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ef4586\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ca4266\" data-id=\"3ca4266\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f833c79 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"f833c79\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az oszlopokban l\u00e9v\u0151 \u00e9rt\u00e9kek k\u00f6z\u00fcl a legkisebb vagy legnagyobb \u00e9rt\u00e9keket az oszlopok alatti sorban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A sorokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9kek k\u00f6z\u00fcl a legkisebb vagy legnagyobb \u00e9rt\u00e9keket a sorok melletti oszlopban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-61af988 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"61af988\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-496067b\" data-id=\"496067b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fe068c8 elementor-widget elementor-widget-text-editor\" data-id=\"fe068c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>N\u00e9zz\u00fcnk a k\u00e9t f\u00fcggv\u00e9ny haszn\u00e1lat\u00e1ra egy egyszer\u0171 kiz\u00e1r\u00f3lag sz\u00e1mokat tartalmaz\u00f3 p\u00e9ld\u00e1t a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">192-K-Excel-MIN, MAX f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka2 munkalapj\u00e1n <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2.jpg\" target=\"_blank\" rel=\"noopener\">(2. \u00e1bra)<\/a>! (Vizsg\u00e1ljuk meg a t\u00e1bl\u00e1zatot, miel\u0151tt tov\u00e1bb olvasunk!)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e3cca9c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3cca9c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ba67bb\" data-id=\"3ba67bb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92b1353 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"92b1353\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg\" class=\"attachment-large size-large wp-image-2990\" alt=\"2. \u00e1bra: A MIN \u00e9s a MAX f\u00fcggv\u00e9nyek tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek_2_Munka2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: A <strong>MIN <\/strong>\u00e9s a <strong>MAX <\/strong>f\u00fcggv\u00e9nyek tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c2468a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c2468a5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8cf5690\" data-id=\"8cf5690\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66be681 elementor-widget elementor-widget-text-editor\" data-id=\"66be681\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az oszlopokban tal\u00e1lhat\u00f3 legkisebb \u00e9rt\u00e9keket a 13. sorban kellett kisz\u00e1molnunk. Ehhez kijel\u00f6lt\u00fck az oszlopok alatti, 13. sorban l\u00e9v\u0151 cell\u00e1kat, vagyis a B13:D13 tartom\u00e1nyt. A tartom\u00e1ny els\u0151, akt\u00edv cell\u00e1j\u00e1ba, vagyis a B13 cell\u00e1ba beg\u00e9pelt\u00fck a felette l\u00e9v\u0151 oszlop adataival sz\u00e1mol\u00f3 k\u00e9pletet: <strong>=MIN(B3:B12)<\/strong>, majd le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t. Ezzel a billenty\u0171kombin\u00e1ci\u00f3val mindh\u00e1rom cell\u00e1ba a megfelel\u0151 k\u00e9pletet tudtuk bevinni. A MAX f\u00fcggv\u00e9nnyel m\u00e1r k\u00f6nnyen boldogulunk: jel\u00f6lj\u00fck ki a B14:D14 tartom\u00e1nyt, a B14 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=MAX(B3:B12)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/p>\n<p>L\u00e1ssuk, hogyan j\u00e1rtunk el a sorok eset\u00e9ben: a t\u00edz term\u00e9k sorai melletti E oszlopban kellett kikeresn\u00fcnk az egyes sorokban tal\u00e1lhat\u00f3 legkisebb \u00e9rt\u00e9keket. Ezen t\u00edz cella tartom\u00e1nyhivatkoz\u00e1sa E3:E12. Kijel\u00f6lt\u00fck ezt a tartom\u00e1nyt, majd az E3 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=MIN(B3:D3)<\/strong> k\u00e9pletet, v\u00e9g\u00fcl le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! \u00cdgy minden sorhoz siker\u00fclt megjelen\u00edten\u00fcnk a legkisebb \u00e9rt\u00e9ket. A MAX f\u00fcggv\u00e9nnyel \u00edgy m\u00e1r k\u00f6nnyen boldogulunk: jel\u00f6lj\u00fck ki az F3:F12 tartom\u00e1nyt, az F3 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=MAX(B3:D3)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/p>\n<p>A c\u00edmben feltett \u201eHogyan haszn\u00e1lom ezt a k\u00e9t f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?\u201d k\u00e9rd\u00e9sre a v\u00e1lasz teh\u00e1t az, hogy \u00edgy.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9e99f8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e99f8f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2798dbc\" data-id=\"2798dbc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f7bceee elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f7bceee\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.3. Van valami gyorsabb m\\u00f3dszer az ilyen jelleg\\u0171 feladatokban a f\\u00fcggv\\u00e9nyek, k\\u00e9pletek bevitel\\u00e9re?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9.3. Van valami gyorsabb m\u00f3dszer az ilyen jelleg\u0171 feladatokban a f\u00fcggv\u00e9nyek, k\u00e9pletek bevitel\u00e9re?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c7d07dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7d07dd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c224389\" data-id=\"c224389\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db42018 elementor-widget elementor-widget-text-editor\" data-id=\"db42018\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Term\u00e9szetesen van. K\u00e9t m\u00f3dszert is mutatunk \u2013 haszn\u00e1ljuk ism\u00e9t a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/192-K-Excel-MIN-MAX-f\u00fcggv\u00e9nyek.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">192-K-Excel-MIN, MAX f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczetet:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aec6fd8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aec6fd8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d063250\" data-id=\"d063250\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-88005f4 elementor-widget elementor-widget-text-editor\" data-id=\"88005f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki ism\u00e9t a B13:D13 tartom\u00e1nyt az oszlopok legkisebb \u00e9rt\u00e9keinek kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Minimum <\/strong><em>(Alt+\u0150, D, M)<\/em> parancsot! Jel\u00f6lj\u00fck ki a E3:E12 tartom\u00e1nyt a sorok legkisebb \u00e9rt\u00e9keinek kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Minimum <\/strong><em>(Alt+\u0150, D, M)<\/em> parancsot!<\/li>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171vel megjelen\u00edthet\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablakkal az el\u0151z\u0151 pontban eml\u00edtett k\u00e9t tartom\u00e1nyt, a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be beg\u00e9pelve a B13:D13;E3:E12 tartom\u00e1nyhivatkoz\u00e1sokat. Ezut\u00e1n a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Minimum <\/strong><em>(Alt+\u0150, D, M)<\/em> parancsot! Minden cell\u00e1ba a megfelel\u0151 k\u00e9plet ker\u00fcl a megfelel\u0151 oszlop, illetve sorhivatkoz\u00e1ssal.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6fd2021 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fd2021\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-40deea2\" data-id=\"40deea2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e2107d1 elementor-widget elementor-widget-text-editor\" data-id=\"e2107d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A fenti m\u00f3dszerek alkalmazhat\u00f3s\u00e1g\u00e1nak az az oka, hogy az Excelt felk\u00e9sz\u00edtett\u00e9k a szokv\u00e1nyos t\u00e1bl\u00e1zatelrendez\u00e9sekre \u00e9s a tipikus sz\u00e1m\u00edt\u00e1si feladatokra.<br \/>Ennek ellen\u00e9re a fenti m\u00f3dszerek korl\u00e1tozottan, csak abban az esetben haszn\u00e1lhat\u00f3k, ha a k\u00e9pletet k\u00f6zvetlen\u00fcl az adatsorok mell\u00e9, illetve az adatoszlopok al\u00e1 akarjuk bevinni. Teh\u00e1t, ha az F oszlopban, illetve a 14. sorban akarjuk a MAX f\u00fcggv\u00e9nyt r\u00f6gz\u00edteni a fenti m\u00f3dszerek egyik\u00e9vel, nem lesz j\u00f3 a tartom\u00e1nyhivatkoz\u00e1s. Ennek oka, hogy az Excel beleveszi az E oszlopot \u00e9s a 13. sort is a tartom\u00e1nyba.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e1e8b11 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e1e8b11\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-784ae66\" data-id=\"784ae66\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4e9407b elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"4e9407b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.4. A hi\\u00e1nyz\\u00f3 adatok jel\\u00f6l\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9.4. A hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f1fa7bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1fa7bd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-09dbed7\" data-id=\"09dbed7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6197bc6 elementor-widget elementor-widget-text-editor\" data-id=\"6197bc6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Aki nem ismeri a #HI\u00c1NYZIK hiba\u00e9rt\u00e9ket \u00e9s a HI\u00c1NYZIK f\u00fcggv\u00e9nyt, az a hi\u00e1nyz\u00f3 adatait \u00fcres cell\u00e1val, vagy valamilyen m\u00e1s, megegyez\u00e9sen alapul\u00f3 \u00e9rt\u00e9kkel helyettes\u00edti. Ezt nem szabad, mert t\u00f6bb f\u00fcggv\u00e9ny szolg\u00e1ltathat hib\u00e1s, nem v\u00e1rt, f\u00e9lrevezet\u0151 eredm\u00e9nyt, okozhat nehezen felder\u00edthet\u0151 hib\u00e1t, illetve az ilyen adatsorok diagramon \u00e1br\u00e1zol\u00e1sa is f\u00e9lre\u00e9rthet\u0151. Olvassuk el <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">A # hiba\u00e9rt\u00e9kek (#169)<\/a> cikk <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888#3_HIANYZIK_-_hianyzo_adat_jelzese\">3. #HI\u00c1NYZIK \u2013 hi\u00e1nyz\u00f3 adat jelz\u00e9se<\/a> fejezet\u00e9t, hogy meg\u00e9rts\u00fck, hogyan kell helyesen jel\u00f6lni egy t\u00e1bl\u00e1zatban a hi\u00e1nyz\u00f3 adatot!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6d51b71 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d51b71\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-40b4982\" data-id=\"40b4982\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-200954b elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"200954b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.5. Az utols\\u00f3\\\/els\\u0151 elem stb. megjelen\\u00edt\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9.5. Az utols\u00f3\/els\u0151 elem stb. megjelen\u00edt\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7389b6f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7389b6f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f83c11b\" data-id=\"f83c11b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-32617da elementor-widget elementor-widget-text-editor\" data-id=\"32617da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A k\u00e9t f\u00fcggv\u00e9ny egy m\u00e1sik tipikus alkalmaz\u00e1si ter\u00fclete, amikor egy sz\u00e1mhalmazb\u00f3l a feladat megfogalmaz\u00e1sa szerint az utols\u00f3 elemet, az utols\u00f3 helyezettet, a legolcs\u00f3bbat, illetve az els\u0151 elemet, az els\u0151 helyezettet, a legdr\u00e1g\u00e1bbat stb. kell megjelen\u00edten\u00fcnk egy cell\u00e1ban. Ezekben az esetekben is a MIN \u00e9s a MAX f\u00fcggv\u00e9nyek haszn\u00e1lat\u00e1ra lesz sz\u00fcks\u00e9g\u00fcnk.<\/p>\n\n<p>Tal\u00e1lkozhatunk olyan k\u00e9rd\u00e9ssel is, amely nem az utols\u00f3\/els\u0151, hanem az utols\u00f3 h\u00e1rom vagy els\u0151 h\u00e1rom helyezettet, az utols\u00f3 ak\u00e1rh\u00e1ny vagy az els\u0151 t\u00edz stb. elemet kell megjelen\u00edten\u00fcnk. Az ilyen probl\u00e9m\u00e1kon a KICSI \u00e9s a NAGY f\u00fcggv\u00e9nyek seg\u00edtenek.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c1c44f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c1c44f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5d598e0\" data-id=\"5d598e0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bf49ada elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"bf49ada\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>V\u00c9GE.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-60007b4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60007b4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8dc3359\" data-id=\"8dc3359\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-532be80 elementor-widget elementor-widget-text-editor\" data-id=\"532be80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 \u00e1prilis 7.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (19H2, 1909b18363)<br \/>Irodai programcsomag: Microsoft Office 2016 v2003b12624.20382, Havi csatorna<br \/>Szint: kezd\u0151, ECDL: M04\/S6\/4.2.1<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek \u2192 F\u00fcggv\u00e9nyek haszn\u00e1lata<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-095cb47 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"095cb47\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bdb93b0\" data-id=\"bdb93b0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-89e123e elementor-widget elementor-widget-shortcode\" data-id=\"89e123e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><!-- FeedbackWP Plugin --><div        class=\"rmp-widgets-container rmp-wp-plugin rmp-main-container js-rmp-widgets-container js-rmp-widgets-container--2851 \"        data-post-id=\"2851\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2851\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2851\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d194a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d194a6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-01b300f\" data-id=\"01b300f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4794b1e elementor-share-buttons--skin-flat elementor-share-buttons--view-icon-text elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-global elementor-global-15485 elementor-widget-share-buttons\" data-id=\"4794b1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 10. Mir\u0151l sz\u00f3l ez a cikk?A statisztika kev\u00e9s embernek okoz \u00f6r\u00f6m\u00f6t, ak\u00e1r egy iskol\u00e1ban, ak\u00e1r az \u00e9letben tal\u00e1lkozik vele. Ugyanakkor nagyon sokszor v\u00e1lnak hasznoss\u00e1 a statisztikai f\u00fcggv\u00e9nyek, m\u00e9g egy egyszer\u0171 feladat sor\u00e1n is. Emiatt a MIN \u00e9s a MAX f\u00fcggv\u00e9ny, t\u00f6bb m\u00e1s statisztikai f\u00fcggv\u00e9nyhez hasonl\u00f3an, mindig \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":962,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-2851","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2851"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2851\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/962"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}