{"id":2985,"date":"2020-04-14T11:15:14","date_gmt":"2020-04-14T09:15:14","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2985"},"modified":"2021-10-30T13:41:05","modified_gmt":"2021-10-30T11:41:05","slug":"a-min2-es-a-max2-maxa-fuggveny-195","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2985","title":{"rendered":"A MIN2 \u00e9s a MAX2 (MAXA) f\u00fcggv\u00e9ny (#195)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2985\" class=\"elementor elementor-2985\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7dce1ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dce1ad\" 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-6ab7c71\" data-id=\"6ab7c71\" 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-afda1bc elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"afda1bc\" 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 28.<\/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-a5a9d2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a5a9d2f\" 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-df1c30a\" data-id=\"df1c30a\" 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-2be6b3b elementor-widget elementor-widget-text-editor\" data-id=\"2be6b3b\" 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 MIN \u00e9s MAX f\u00fcggv\u00e9ny numerikus adatokkal dolgozik. De mi a helyzet az egy\u00e9b adatt\u00edpusokkal, azokkal nem lehet hasonl\u00f3 m\u0171veletet v\u00e9gezni? A v\u00e1lasz igen: a MIN2 \u00e9s a MAX2 (MAXA) f\u00fcggv\u00e9ny m\u00e1r minden adatt\u00edpust kezel. 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-29d8515 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"29d8515\" 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-5fabcd8\" data-id=\"5fabcd8\" 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-ea4e2dd elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"ea4e2dd\" 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__ea4e2dd\" 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__ea4e2dd\" 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__ea4e2dd\" 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-6e0a6ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e0a6ed\" 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-bf59ec1\" data-id=\"bf59ec1\" 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-90ffb7c elementor-widget elementor-widget-text-editor\" data-id=\"90ffb7c\" 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<\/strong> <strong>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=2851\">MIN<\/a>, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MAX<\/a>, 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-7456594 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7456594\" 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-d705085\" data-id=\"d705085\" 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-f9df490 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f9df490\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A MIN2 \\u00e9s a MAX2 (MAXA) 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 MIN2 \u00e9s a MAX2 (MAXA) 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-c1872f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1872f7\" 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-466e962\" data-id=\"466e962\" 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-e189c81 elementor-widget elementor-widget-text-editor\" data-id=\"e189c81\" 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 MIN2 \u00e9s a MAX2 (MAXA) f\u00fcggv\u00e9ny a statisztikai f\u00fcggv\u00e9nyek k\u00f6z\u00e9 tartozik \u2013 az argumentumk\u00e9nt megadott \u00e9rt\u00e9kek k\u00f6z\u00fcl a legkisebbet, illetve a legnagyobbat adj\u00e1k eredm\u00e9ny\u00fcl.<\/strong> Alkalmaz\u00e1suk akkor indokolt, ha elt\u00e9r\u0151 t\u00edpus\u00fa adatokkal kell dolgoznunk: a k\u00e9t f\u00fcggv\u00e9ny a numerikus, a sz\u00f6vegk\u00e9nt megadott numerikus \u00e9s a logikai t\u00edpus\u00fa adatokat k\u00e9pes kezelni. Az \u00fcres cell\u00e1kat \u00e9s a sz\u00f6veges adatt\u00edpust, bele\u00e9rtve az \u00fcres karakterl\u00e1ncot (&#8222;&#8221;), mell\u0151zi mindk\u00e9t f\u00fcggv\u00e9ny, eredm\u00e9ny\u00fcl mindig null\u00e1t adva.<\/p>\n\n<p><strong>A MAX2 f\u00fcggv\u00e9nyn\u00e9v a magyar nyelv\u0171 Excel alkalmaz\u00e1sban nem haszn\u00e1lhat\u00f3, helyette az angol f\u00fcggv\u00e9nynevet, a MAXA-t kell haszn\u00e1lni.<\/strong><\/p>\n\n<p>Teh\u00e1t, m\u00edg a MIN \u00e9s a MAX f\u00fcggv\u00e9ny kiz\u00e1r\u00f3lag numerikus \u00e9rt\u00e9kekkel sz\u00e1mol, addig a MIN2 \u00e9s a MAXA f\u00fcggv\u00e9ny a numerikus mellett a fent felsorolt adatt\u00edpusokat is k\u00e9pes kezelni, ak\u00e1r vegyesen is. Emiatt \u00e9rdemes megfontolnunk a MIN2 \u00e9s MAXA haszn\u00e1lat\u00e1t, hiszen mindkett\u0151 k\u00e9pes helyettes\u00edteni a MIN \u00e9s MAX f\u00fcggv\u00e9nyt.<\/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-fa10ee5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa10ee5\" 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-afcaf9c\" data-id=\"afcaf9c\" 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-c2cc3a3 elementor-widget elementor-widget-text-editor\" data-id=\"c2cc3a3\" 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>MIN2(<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-370353f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"370353f\" 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-4c5b6d9\" data-id=\"4c5b6d9\" 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-fde644b elementor-widget elementor-widget-text-editor\" data-id=\"fde644b\" 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>MAXA(<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-c7e223b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7e223b\" 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-67dcf50\" data-id=\"67dcf50\" 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-9bee1b9 elementor-widget elementor-widget-text-editor\" data-id=\"9bee1b9\" 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>az 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-4bd63fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4bd63fc\" 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-7e1693e\" data-id=\"7e1693e\" 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-9f40464 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"9f40464\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A MIN2 \\u00e9s a MAXA 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 MIN2 \u00e9s a MAXA 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-13fd874 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"13fd874\" 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-93012ad\" data-id=\"93012ad\" 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-1716e9e elementor-widget elementor-widget-text-editor\" data-id=\"1716e9e\" 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>El\u0151sz\u00f6r n\u00e9zz\u00fcnk p\u00e9ld\u00e1kat numerikus argumentumokra! Egyszer\u0171 sz\u00e1mokat adva argumentumk\u00e9nt, mindk\u00e9t f\u00fcggv\u00e9ny a MIN \u00e9s a MAX f\u00fcggv\u00e9nyhez hasonl\u00f3an m\u0171k\u00f6dik:<\/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-a9e6976 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a9e6976\" 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-09dddae\" data-id=\"09dddae\" 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-e7c6d64 elementor-widget elementor-widget-text-editor\" data-id=\"e7c6d64\" 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>=MIN2(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-5fc7068 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5fc7068\" 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-144d28c\" data-id=\"144d28c\" 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-e22606a elementor-widget elementor-widget-text-editor\" data-id=\"e22606a\" 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>=MAXA(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-9b8dcbd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b8dcbd\" 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-d43741d\" data-id=\"d43741d\" 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-19f3247 elementor-widget elementor-widget-text-editor\" data-id=\"19f3247\" 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 MIN2 eredm\u00e9nye 3, a MAXA eredm\u00e9nye 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 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! 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-a10be5a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a10be5a\" 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-1deb583\" data-id=\"1deb583\" 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-dd76700 elementor-widget elementor-widget-text-editor\" data-id=\"dd76700\" 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>=MIN2(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-042d5be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"042d5be\" 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-b034ef7\" data-id=\"b034ef7\" 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-ecaf86a elementor-widget elementor-widget-text-editor\" data-id=\"ecaf86a\" 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>=MAXA(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-be0d1f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"be0d1f1\" 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-e0d0317\" data-id=\"e0d0317\" 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-f1f2bc7 elementor-widget elementor-widget-text-editor\" data-id=\"f1f2bc7\" 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 MIN2 f\u00fcggv\u00e9ny eredm\u00e9nye 43935, a MAXA 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-99753f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"99753f0\" 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-a15a64d\" data-id=\"a15a64d\" 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-6b3eaa5 elementor-widget elementor-widget-text-editor\" data-id=\"6b3eaa5\" 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>=MIN2(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-937dffd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"937dffd\" 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-e3143e1\" data-id=\"e3143e1\" 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-4d39c3f elementor-widget elementor-widget-text-editor\" data-id=\"4d39c3f\" 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>=MAXA(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-7352446 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7352446\" 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-b1781d3\" data-id=\"b1781d3\" 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-5757e90 elementor-widget elementor-widget-text-editor\" data-id=\"5757e90\" 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 MIN2 eredm\u00e9nye 0,5, a MAXA 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-9fc5ba9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9fc5ba9\" 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-c131a84\" data-id=\"c131a84\" 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-6acbd6f elementor-widget elementor-widget-text-editor\" data-id=\"6acbd6f\" 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>=MIN2(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-0ceda4a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ceda4a\" 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-4f419f5\" data-id=\"4f419f5\" 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-679e86e elementor-widget elementor-widget-text-editor\" data-id=\"679e86e\" 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>=MAXA(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-122309b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"122309b\" 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-23bb001\" data-id=\"23bb001\" 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-def6a7e elementor-widget elementor-widget-text-editor\" data-id=\"def6a7e\" 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 MIN2 eredm\u00e9nye 0,1, a MAXA eredm\u00e9nye 25 lesz.<\/p>\n\n<p>K\u00f6vetkezzen a k\u00f6nyvel\u00e9si sz\u00e1mform\u00e1tum 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-757cf7e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"757cf7e\" 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-cab63e5\" data-id=\"cab63e5\" 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-a813d49 elementor-widget elementor-widget-text-editor\" data-id=\"a813d49\" 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>=MIN2(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-0e662e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e662e7\" 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-205adea\" data-id=\"205adea\" 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-0c5966c elementor-widget elementor-widget-text-editor\" data-id=\"0c5966c\" 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>=MAXA(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-c8e0b4d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8e0b4d\" 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-70ac4ae\" data-id=\"70ac4ae\" 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-a326bfa elementor-widget elementor-widget-text-editor\" data-id=\"a326bfa\" 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 MIN2 eredm\u00e9nye 10000, a MAXA 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-4f0efad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f0efad\" 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-b6031e8\" data-id=\"b6031e8\" 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-eb2ee63 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"eb2ee63\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. A MIN2 \\u00e9s a MAXA 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\">3. A MIN2 \u00e9s a MAXA 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-3235669 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3235669\" 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-6928b81\" data-id=\"6928b81\" 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-7130496 elementor-widget elementor-widget-text-editor\" data-id=\"7130496\" 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 adatok alkalmaz\u00e1sa egyszer\u0171: 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. Legyen a k\u00e9plet\u00fcnkben b\u00e1rmilyen \u00f6sszetett logikai felt\u00e9tel, ha annak eredm\u00e9nye IGAZ, akkor az 1-el, ha HAMIS, akkor 0-val fog sz\u00e1molni a k\u00e9plet. Mindezek tudat\u00e1ban pr\u00f3b\u00e1ljuk ki 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-d442819 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d442819\" 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-c3e9795\" data-id=\"c3e9795\" 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-f422581 elementor-widget elementor-widget-text-editor\" data-id=\"f422581\" 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>=MIN2(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-5415575 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5415575\" 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-3983582\" data-id=\"3983582\" 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-007b28e elementor-widget elementor-widget-text-editor\" data-id=\"007b28e\" 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>=MAXA(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-cd98155 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd98155\" 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-e922415\" data-id=\"e922415\" 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-eef21b3 elementor-widget elementor-widget-text-editor\" data-id=\"eef21b3\" 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 MIN2 eredm\u00e9nye 0, a MAXA 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-ab41de6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ab41de6\" 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-290d2ba\" data-id=\"290d2ba\" 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-a81dc61 elementor-widget elementor-widget-text-editor\" data-id=\"a81dc61\" 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(MIN2(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-584712c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"584712c\" 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-bff75d0\" data-id=\"bff75d0\" 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-4b7e700 elementor-widget elementor-widget-text-editor\" data-id=\"4b7e700\" 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(MAXA(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-4e93165 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e93165\" 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-9e812e7\" data-id=\"9e812e7\" 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-bfa9bd4 elementor-widget elementor-widget-text-editor\" data-id=\"bfa9bd4\" 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. Term\u00e9szetesen mindkett\u0151t helyettes\u00edthetj\u00fck a megfelel\u0151 logikai 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-1eead36 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1eead36\" 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-4671fba\" data-id=\"4671fba\" 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-3c17673 elementor-widget elementor-widget-text-editor\" data-id=\"3c17673\" 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(MIN2(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-a43bdd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a43bdd9\" 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-768eb77\" data-id=\"768eb77\" 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-cf35ac1 elementor-widget elementor-widget-text-editor\" data-id=\"cf35ac1\" 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(MAXA(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-9ddd94b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ddd94b\" 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-038bc65\" data-id=\"038bc65\" 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-d203840 elementor-widget elementor-widget-text-editor\" data-id=\"d203840\" 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 MIN2 eredm\u00e9nye HAMIS, a MAXA eredm\u00e9nye 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-6cfca73 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6cfca73\" 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-94cc8fa\" data-id=\"94cc8fa\" 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-5579249 elementor-widget elementor-widget-text-editor\" data-id=\"5579249\" 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>=MIN2(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-2c9d732 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c9d732\" 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-fff3ea7\" data-id=\"fff3ea7\" 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-809a010 elementor-widget elementor-widget-text-editor\" data-id=\"809a010\" 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>=MAXA(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-3e77364 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3e77364\" 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-1a5ed26\" data-id=\"1a5ed26\" 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-ac8b3e4 elementor-widget elementor-widget-text-editor\" data-id=\"ac8b3e4\" 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 MIN2 eredm\u00e9nye 0, a MAXA 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-f80e9c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f80e9c0\" 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-62f41fd\" data-id=\"62f41fd\" 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-fd48f77 elementor-widget elementor-widget-text-editor\" data-id=\"fd48f77\" 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(MIN2(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-fea68bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fea68bd\" 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-7395702\" data-id=\"7395702\" 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-25cee72 elementor-widget elementor-widget-text-editor\" data-id=\"25cee72\" 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(MAXA(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-78245a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"78245a1\" 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-bb3485b\" data-id=\"bb3485b\" 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-25413ba elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"25413ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. A MIN2 \\u00e9s a MAXA 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\">4. A MIN2 \u00e9s a MAXA 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-e44a859 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e44a859\" 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-b3fbd6e\" data-id=\"b3fbd6e\" 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-6ccbe33 elementor-widget elementor-widget-text-editor\" data-id=\"6ccbe33\" 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>Erre l\u00e1ttunk m\u00e1r kor\u00e1bban p\u00e9ld\u00e1t, hiszen a SZ\u00d6VEG f\u00fcggv\u00e9nyt seg\u00edts\u00e9g\u00fcl h\u00edv\u00f3 k\u00e9pletekben a SZ\u00d6VEG f\u00fcggv\u00e9ny argumentumk\u00e9nt sz\u00f6veg form\u00e1tum\u00fa numerikus \u00e9rt\u00e9ket adott eredm\u00e9ny\u00fcl, \u00edgy egyik f\u00fcggv\u00e9ny sem j\u00f6tt zavarba a legkisebb vagy a legnagyobb \u00e9rt\u00e9k kikeres\u00e9sekor. 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-86ce816 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86ce816\" 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-08f6cf7\" data-id=\"08f6cf7\" 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-92ee97b elementor-widget elementor-widget-text-editor\" data-id=\"92ee97b\" 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>=MIN2(&#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-0ce8057 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ce8057\" 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-ccf9616\" data-id=\"ccf9616\" 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-0994911 elementor-widget elementor-widget-text-editor\" data-id=\"0994911\" 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>=MAXA(&#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-621c5d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"621c5d5\" 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-369699d\" data-id=\"369699d\" 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-99c7528 elementor-widget elementor-widget-text-editor\" data-id=\"99c7528\" 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 MIN2 eredm\u00e9nye 20, a MAXA 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-dbbb3fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbbb3fd\" 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-bd02042\" data-id=\"bd02042\" 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-456dc64 elementor-widget elementor-widget-text-editor\" data-id=\"456dc64\" 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>=MIN2(&#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-d69e430 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d69e430\" 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-08fcf46\" data-id=\"08fcf46\" 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-5f1b027 elementor-widget elementor-widget-text-editor\" data-id=\"5f1b027\" 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>=MAXA(&#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-28ac3f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28ac3f4\" 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-eec4493\" data-id=\"eec4493\" 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-afba992 elementor-widget elementor-widget-text-editor\" data-id=\"afba992\" 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-cb376c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb376c2\" 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-b58476e\" data-id=\"b58476e\" 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-b4d5505 elementor-widget elementor-widget-text-editor\" data-id=\"b4d5505\" 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-32a030b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32a030b\" 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-b217d1e\" data-id=\"b217d1e\" 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-ba5380a elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ba5380a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. A MIN2 \\u00e9s a MAXA 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 MIN2 \u00e9s a MAXA 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-ec21129 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ec21129\" 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-03e2473\" data-id=\"03e2473\" 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-24d9576 elementor-widget elementor-widget-text-editor\" data-id=\"24d9576\" 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 \u2013 ahogy azt a f\u00fcggv\u00e9nyeket bemutat\u00f3 fejezetben \u00edrtuk \u2013 mindk\u00e9t f\u00fcggv\u00e9ny nulla \u00e9rt\u00e9kkel helyettes\u00edti. Ha minden hivatkozott argumentum sz\u00f6veg t\u00edpus\u00fa adat, akkor a f\u00fcggv\u00e9ny nulla eredm\u00e9nyt ad. Ha sz\u00f6veget konstansk\u00e9nt adunk meg a z\u00e1r\u00f3jelek k\u00f6z\u00f6tt, akkor a #\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-96aadff elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96aadff\" 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-05c4ef9\" data-id=\"05c4ef9\" 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-7339225 elementor-widget elementor-widget-text-editor\" data-id=\"7339225\" 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>=MIN2(&#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-c425197 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c425197\" 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-4449b42\" data-id=\"4449b42\" 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-e774caa elementor-widget elementor-widget-text-editor\" data-id=\"e774caa\" 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>=MAXA(&#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-8c2fb95 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c2fb95\" 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-8df1435\" data-id=\"8df1435\" 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-6915c81 elementor-widget elementor-widget-text-editor\" data-id=\"6915c81\" 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>=MIN2(&#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-0556fe7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0556fe7\" 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-2a91901\" data-id=\"2a91901\" 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-ce6f089 elementor-widget elementor-widget-text-editor\" data-id=\"ce6f089\" 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>=MAXA(&#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-8934cca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8934cca\" 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-e61813b\" data-id=\"e61813b\" 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-0d7048c elementor-widget elementor-widget-text-editor\" data-id=\"0d7048c\" 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; , illetve az \u00fcres karakterl\u00e1nc k\u00e9plete (=&#8221;&#8221;) p\u00e9ld\u00e1ul az A1 cell\u00e1ban tal\u00e1lhat\u00f3, akkor a k\u00f6vetkez\u0151 k\u00e9pletek eredm\u00e9nye 0, illetve 50.<\/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-8c5e372 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c5e372\" 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-82a2d55\" data-id=\"82a2d55\" 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-b0893fa elementor-widget elementor-widget-text-editor\" data-id=\"b0893fa\" 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>=MIN2(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-8bec4f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8bec4f1\" 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-5f616dc\" data-id=\"5f616dc\" 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-0762dfc elementor-widget elementor-widget-text-editor\" data-id=\"0762dfc\" 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>=MAXA(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-9a4c74e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a4c74e\" 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-064a245\" data-id=\"064a245\" 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-dc02444 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"dc02444\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;6. A MIN2 \\u00e9s a MAXA 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 MIN2 \u00e9s a MAXA 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-0939bd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0939bd9\" 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-0a20566\" data-id=\"0a20566\" 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-adc60f2 elementor-widget elementor-widget-text-editor\" data-id=\"adc60f2\" 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 \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-2f3f272 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f3f272\" 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-0c0b52e\" data-id=\"0c0b52e\" 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-5317537 elementor-widget elementor-widget-text-editor\" data-id=\"5317537\" 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>=MIN2(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-b569168 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b569168\" 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-a24c063\" data-id=\"a24c063\" 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-71276ff elementor-widget elementor-widget-text-editor\" data-id=\"71276ff\" 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>=MAXA(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-ae06b99 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae06b99\" 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-41e0fdd\" data-id=\"41e0fdd\" 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-8c951af elementor-widget elementor-widget-text-editor\" data-id=\"8c951af\" 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 MIN2 k\u00e9pletre 10-et, a MAXA k\u00e9pletre 50-et v\u00e1rt, j\u00f3l gondolta! Az el\u0151z\u0151 fejezet v\u00e9g\u00e9n \u00edrtuk, hogy a sz\u00f6veget vagy az \u00fcres karakterl\u00e1ncot nem veszi figyelembe a k\u00e9t f\u00fcggv\u00e9ny, de \u00edgy tesz az \u00fcres cell\u00e1val 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-9ed3d31 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ed3d31\" 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-56f8b5b\" data-id=\"56f8b5b\" 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-90ae8db elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"90ae8db\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;7. A MIN2 \\u00e9s a MAXA 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 MIN2 \u00e9s a MAXA 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-bc958b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc958b7\" 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-44f8517\" data-id=\"44f8517\" 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-c933590 elementor-widget elementor-widget-text-editor\" data-id=\"c933590\" 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-2dbc2d3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2dbc2d3\" 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-e5b454e\" data-id=\"e5b454e\" 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-eb7cd96 elementor-widget elementor-widget-text-editor\" data-id=\"eb7cd96\" 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>=MIN2(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-f293ee2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f293ee2\" 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-abc4982\" data-id=\"abc4982\" 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-f3cbe2d elementor-widget elementor-widget-text-editor\" data-id=\"f3cbe2d\" 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>=MAXA(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-3db80ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3db80ac\" 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-c67849e\" data-id=\"c67849e\" 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-e337708 elementor-widget elementor-widget-text-editor\" data-id=\"e337708\" 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-4ed441a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ed441a\" 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-84bfb9b\" data-id=\"84bfb9b\" 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-368c40c elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"368c40c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8. A MIN2 \\u00e9s a MAXA 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 MIN2 \u00e9s a MAXA 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-155ddb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"155ddb7\" 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-464e670\" data-id=\"464e670\" 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-43b46c6 elementor-widget elementor-widget-text-editor\" data-id=\"43b46c6\" 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 MIN2 \u00e9s a MAXA f\u00fcggv\u00e9nyt kell\u0151 \u00f3vatoss\u00e1ggal kell haszn\u00e1lnunk. Sajnos ad\u00f3dhatnak olyan helyzetek, amikor nem tudjuk megker\u00fclni haszn\u00e1latukat, mert a feldolgozand\u00f3 adatok k\u00f6z\u00f6tt nem csak numerikus t\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>A fentiek \u00f6sszefoglal\u00e1s\u00e1hoz seg\u00edts\u00e9g\u00fcnkre lehet az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-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\">195-K-Excel-MIN2, MAX2 f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka1 munkalapj\u00e1t mutatja. \u00d6sszehasonl\u00edt\u00e1sk\u00e9ppen a 8:9 sorokban meghagytuk a MIN \u00e9s MAX f\u00fcggv\u00e9nyek eredm\u00e9nyeit.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>\u00c9rtelmezz\u00fck a MIN2 \u00e9s a MAXA f\u00fcggv\u00e9nyek \u00e1ltal a 10:11 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-4a87b69 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4a87b69\" 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-3d7621f\" data-id=\"3d7621f\" 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-e29bb5e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"e29bb5e\" 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 B7 cell\u00e1ban sz\u00f6vegk\u00e9nt tal\u00e1lhat\u00f3 egy 7-es sz\u00e1m, amelyet nullak\u00e9nt \u00e9rtelmez a MIN2, \u00edgy ez lesz a legkisebb sz\u00e1m, \u00e9s az eredm\u00e9ny is \u2013 \u00e9s szint\u00e9n a B7 cella tartalma miatt lesz a MAXA f\u00fcggv\u00e9ny eredm\u00e9nye 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. Ahogy \u00edrtuk, az IGAZ eggyel, a HAMIS null\u00e1val egyenl\u0151, az \u00fcres cell\u00e1k \u00e9rt\u00e9ke szint\u00e9n nulla. Ennek felelnek meg az eredm\u00e9nyek is.<\/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 MIN2 nulla eredm\u00e9nye a H1:H3 cell\u00e1k tartalm\u00e1nak k\u00f6sz\u00f6nhet\u0151: a H1 tartalma sz\u00f6veg, az eredm\u00e9ny nulla; a H2 tartalma \u00fcres karakterl\u00e1nc, szint\u00e9n sz\u00f6veg, az eredm\u00e9ny megint csak nulla; \u00e9s a H3 tartalma a HAMIS logikai \u00e9rt\u00e9k, amelynek \u00e9rt\u00e9ke nulla. A MAXA eredm\u00e9ny\u00e9t k\u00f6nnyebb meg\u00e9rteni, mivel a H4:H7 cell\u00e1kban elhelyezett numerikus adatok k\u00f6z\u00fcl a H4 d\u00e1tum\u00e1nak 43924 \u00e9rt\u00e9ke a legmagasabb: enn\u00e9l mind a 16:05 id\u0151pontot helyettes\u00edt\u0151 0,670138889, mind a 25% sz\u00e1zzal osztott 0,25 \u00e9rt\u00e9ke, mind a 87-es sz\u00e1m kisebb.<\/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.<\/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-6ef76a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ef76a8\" 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-16a9d58\" data-id=\"16a9d58\" 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-0c99f7b elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"0c99f7b\" 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\/195-K-Excel-MIN2-MAX2-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\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg\" class=\"attachment-large size-large wp-image-3005\" alt=\"1. \u00e1bra: A MIN2 \u00e9s a MAXA f\u00fcggv\u00e9nyek \u00e1ltal kezelt adatt\u00edpusok.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_1_Munka1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-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>MIN2 <\/strong>\u00e9s a <strong>MAXA <\/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-08a8b0a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"08a8b0a\" 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-abace81\" data-id=\"abace81\" 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-327c782 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"327c782\" 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-f55717b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f55717b\" 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-9444e07\" data-id=\"9444e07\" 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-b224f58 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"b224f58\" 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-e2bd326 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e2bd326\" 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-6e5e4d4\" data-id=\"6e5e4d4\" 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-ae80a89 elementor-widget elementor-widget-text-editor\" data-id=\"ae80a89\" 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 MINA \u00e9s MAXA.<\/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-a636fd4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a636fd4\" 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-db47dda\" data-id=\"db47dda\" 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-b3a0f3f elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"b3a0f3f\" 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-b44890c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b44890c\" 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-e6c1e7d\" data-id=\"e6c1e7d\" 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-32c7bd9 elementor-widget elementor-widget-text-editor\" data-id=\"32c7bd9\" 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-1f77cbe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f77cbe\" 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-1f32cce\" data-id=\"1f32cce\" 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-a4b6603 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"a4b6603\" 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-b80296b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b80296b\" 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-fa74ced\" data-id=\"fa74ced\" 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-b7b2b03 elementor-widget elementor-widget-text-editor\" data-id=\"b7b2b03\" 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 tipikus 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\">195-K-Excel-MIN2, MAX2 f\u00fcggv\u00e9nyek.xlsx<\/a> munkaf\u00fczet Munka2 munkalapj\u00e1n <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2.jpg\" target=\"_blank\" rel=\"noopener\">(2. \u00e1bra)<\/a>! Az A1:F14 t\u00e1bl\u00e1zatban a numerikus \u00e9rt\u00e9kek mellett \u00fcres cella (C4), \u00fcres karakterl\u00e1nc (D4), sz\u00e1mnak l\u00e1tsz\u00f3 karakterl\u00e1nc (B7), hi\u00e1nyz\u00f3 adat (C9, D6), logikai \u00e9rt\u00e9k (B11), \u00e9s a hi\u00e1nyz\u00f3 adatot tipikusan jelz\u0151 nulla \u00e9rt\u00e9k (D11) is van! (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-67bc0d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"67bc0d2\" 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-2521c68\" data-id=\"2521c68\" 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-603524b elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"603524b\" 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\/195-K-Excel-MIN2-MAX2-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\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg\" class=\"attachment-large size-large wp-image-3006\" alt=\"2. \u00e1bra: A MIN2 \u00e9s a MAXA f\u00fcggv\u00e9nyek tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-f\u00fcggv\u00e9nyek_2_Munka2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/195-K-Excel-MIN2-MAX2-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>MIN2 <\/strong>\u00e9s a <strong>MAXA <\/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-6c8a918 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c8a918\" 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-975b42b\" data-id=\"975b42b\" 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-f3979d4 elementor-widget elementor-widget-text-editor\" data-id=\"f3979d4\" 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>=MIN2(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 MAXA f\u00fcggv\u00e9nnyel m\u00e1r k\u00f6nnyen boldogultunk: kijel\u00f6lt\u00fck a B14:D14 tartom\u00e1nyt, a B14 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=MAXA(B3:B12)<\/strong> k\u00e9pletet, majd le\u00fct\u00f6tt\u00fck 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>=MIN2(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 MAXA f\u00fcggv\u00e9nnyel szint\u00e9n k\u00f6nnyen boldogultunk: kijel\u00f6lt\u00fck az F3:F12 tartom\u00e1nyt, az F3 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=MAXA(B3:D3)<\/strong> k\u00e9pletet, majd le\u00fct\u00f6tt\u00fck 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-5d485f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d485f0\" 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-0b1ce43\" data-id=\"0b1ce43\" 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-299ffa4 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"299ffa4\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.3. 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<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. A hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9se<\/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-240e210 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"240e210\" 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-242f890\" data-id=\"242f890\" 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-df4111d elementor-widget elementor-widget-text-editor\" data-id=\"df4111d\" 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-eeed45d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eeed45d\" 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-42c4160\" data-id=\"42c4160\" 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-a71dc95 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"a71dc95\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9.4. 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<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.4. Az utols\u00f3\/els\u0151 elem stb. megjelen\u00edt\u00e9se<\/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-96c6fd8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96c6fd8\" 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-1af3248\" data-id=\"1af3248\" 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-caad7bc elementor-widget elementor-widget-text-editor\" data-id=\"caad7bc\" 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 \u00e9rt\u00e9khalmazb\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 \u2013 a MIN \u00e9s a MAX f\u00fcggv\u00e9nyek mellett \u2013 a MIN2 \u00e9s a MAXA f\u00fcggv\u00e9nyek haszn\u00e1lat\u00e1t javasoljuk.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\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\u00edthetnek.<\/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-309b1fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"309b1fc\" 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-3d069cc\" data-id=\"3d069cc\" 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-b637e5b elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"b637e5b\" 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-9b7bc85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b7bc85\" 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-bd98c7b\" data-id=\"bd98c7b\" 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-67afc6c elementor-widget elementor-widget-text-editor\" data-id=\"67afc6c\" 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 14.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (20H1, 2004b19041)<br \/>Irodai programcsomag: Microsoft Office Professional Plus 2016 v2003b12624.20442, 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-7acb5e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7acb5e0\" 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-7841cfe\" data-id=\"7841cfe\" 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-8c47327 elementor-widget elementor-widget-shortcode\" data-id=\"8c47327\" 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--2985 \"        data-post-id=\"2985\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2985\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2985\">                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-c58e42f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c58e42f\" 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-7923793\" data-id=\"7923793\" 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-283112f 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=\"283112f\" 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 28. Mir\u0151l sz\u00f3l ez a cikk?A MIN \u00e9s MAX f\u00fcggv\u00e9ny numerikus adatokkal dolgozik. De mi a helyzet az egy\u00e9b adatt\u00edpusokkal, azokkal nem lehet hasonl\u00f3 m\u0171veletet v\u00e9gezni? A v\u00e1lasz igen: a MIN2 \u00e9s a MAX2 (MAXA) f\u00fcggv\u00e9ny m\u00e1r minden adatt\u00edpust kezel. Ebben a cikkben ezt a k\u00e9t \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2985\">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-2985","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2985","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=2985"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2985\/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=2985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}