{"id":504,"date":"2019-09-15T15:00:26","date_gmt":"2019-09-15T13:00:26","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=504"},"modified":"2021-11-04T20:37:35","modified_gmt":"2021-11-04T19:37:35","slug":"relacios-operatorok-hasznalata","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=504","title":{"rendered":"Rel\u00e1ci\u00f3s oper\u00e1torok haszn\u00e1lata (#22)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"504\" class=\"elementor elementor-504\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0556aa4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0556aa4\" 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-2367ea8\" data-id=\"2367ea8\" 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-ca346db elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"ca346db\" 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>\u00a0Friss\u00edtve: 2020 m\u00e1jus 14.<\/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-a744653 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a744653\" 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-b64d1be\" data-id=\"b64d1be\" 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-e4c3017 elementor-widget elementor-widget-text-editor\" data-id=\"e4c3017\" 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 \/>Az Excel haszn\u00e1lat\u00e1nak l\u00e9nyege a sz\u00e1m\u00edt\u00e1sok v\u00e9gz\u00e9se az adatokon. Ehhez k\u00e9pleteket \u00e9s azokban t\u00f6bbek k\u00f6z\u00f6tt m\u0171veleti jeleket haszn\u00e1lunk. A m\u0171veleti jelek egyik csoportj\u00e1t alkotj\u00e1k az \u00f6sszehasonl\u00edt\u00f3, \u00fan. rel\u00e1ci\u00f3s oper\u00e1torok. Ezeket mutatjuk be ebben a cikkben.<\/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-6217344 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6217344\" 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-c75a83d\" data-id=\"c75a83d\" 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-e7e17a9 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"e7e17a9\" 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__e7e17a9\" 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__e7e17a9\" 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__e7e17a9\" 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-9e42cde elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e42cde\" 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-17300e9\" data-id=\"17300e9\" 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-15700ef elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"15700ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. Rel\\u00e1ci\\u00f3s oper\\u00e1torok mint m\\u0171veleti jelek&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. Rel\u00e1ci\u00f3s oper\u00e1torok mint m\u0171veleti jelek<\/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-b458d2c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b458d2c\" 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-967ddb0\" data-id=\"967ddb0\" 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-230fa8e elementor-widget elementor-widget-text-editor\" data-id=\"230fa8e\" 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>Az \u00f6sszehasonl\u00edt\u00f3, idegen sz\u00f3val rel\u00e1ci\u00f3s oper\u00e1torok k\u00e9toperandus\u00fa m\u0171veleti jelek.<\/strong> Ez azt jelenti, hogy legal\u00e1bb kett\u0151 darab \u00e9rt\u00e9kre van sz\u00fcks\u00e9g, amelyeket egym\u00e1ssal hasonl\u00edtunk \u00f6ssze egy kiv\u00e1lasztott rel\u00e1ci\u00f3s oper\u00e1torral.<\/p>\n\n<p>Haszn\u00e1latuk, <strong>fel\u00edr\u00e1suk m\u00f3dja <\/strong>megegyezik a matematikai jelekn\u00e9l megismerttel \u2013 az \u00f6sszead\u00e1shoz hasonl\u00f3an nem egy \u00f6sszead\u00e1s jelet, hanem egy rel\u00e1ci\u00f3s oper\u00e1tort \u00edrunk fel, vagyis a k\u00e9t \u00e9rt\u00e9ket a rel\u00e1ci\u00f3s oper\u00e1tor k\u00e9t oldal\u00e1ra kell \u00edrni.<br \/>P\u00e9lda: =5+2, =5&gt;2.<\/p>\n\n<p><strong>Az \u00e9rt\u00e9kek adatt\u00edpusa<\/strong> b\u00e1rmi (sz\u00e1m, p\u00e9nznem, sz\u00f6veg, logikai, d\u00e1tum\/id\u0151, sz\u00e1zal\u00e9k stb.) lehet, l\u00e9nyeges, hogy lehet\u0151leg azonos t\u00edpus\u00faak legyenek. A legt\u00f6bb \u00f6sszehasonl\u00edt\u00e1sn\u00e1l mag\u00e1t\u00f3l \u00e9rtet\u0151d\u0151 ez a szab\u00e1ly, azonban el\u0151fordulhatnak kiv\u00e9telek, amikor elt\u00e9r\u0151 adatt\u00edpus\u00fa \u00e9rt\u00e9keket hasonl\u00edtunk \u00f6ssze. Ilyen esetben mindig gondosan elemezni kell a k\u00e9plet eredm\u00e9ny\u00e9t.<\/p>\n\n<p><strong>Az \u00f6sszehasonl\u00edt\u00e1s, vagyis a rel\u00e1ci\u00f3s m\u0171velet eredm\u00e9nye mindig logikai IGAZ vagy 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-2161a19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2161a19\" 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-88c915f\" data-id=\"88c915f\" 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-ef86c5a elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ef86c5a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. Rel\\u00e1ci\\u00f3s oper\\u00e1torok&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. Rel\u00e1ci\u00f3s oper\u00e1torok<\/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-6d11b2b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d11b2b\" 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-8fcfa58\" data-id=\"8fcfa58\" 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-344edb3 elementor-widget elementor-widget-text-editor\" data-id=\"344edb3\" 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 6db \u00f6sszehasonl\u00edt\u00f3 vagy rel\u00e1ci\u00f3s oper\u00e1tor a k\u00f6vetkez\u0151:<\/strong><br \/><strong> &lt;, &gt;, =, &lt;&gt;, &lt;= \u00e9s &gt;=.<\/strong><br \/>Vegy\u00fck sorra az egyes oper\u00e1torok jelent\u00e9s\u00e9t \u00e9s haszn\u00e1lat\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-36f7545 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36f7545\" 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-a2d3847\" data-id=\"a2d3847\" 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-d632eb0 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d632eb0\" 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\"><p><strong>Kisebb mint<\/strong>, jele: <strong>&lt;<\/strong>, billenty\u0171kombin\u00e1ci\u00f3ja: <em>AltGr+\u00cd<\/em>.<br \/>Azt vizsg\u00e1ljuk, illetve azt felt\u00e9telezz\u00fck, hogy az oper\u00e1tor el\u0151tti \u00e9rt\u00e9k kisebb az oper\u00e1tor ut\u00e1n \u00edrt \u00e9rt\u00e9kn\u00e9l. Ha igen, akkor az eredm\u00e9ny logikai IGAZ, ha nem, akkor logikai HAMIS.<br \/>P\u00e9lda: =5&lt;3<br \/>A k\u00e9pletben azt vizsg\u00e1ljuk, hogy az 5 kisebb-e 3-n\u00e1l. A k\u00e9plet eredm\u00e9nye logikai HAMIS, mert az 5 nem kisebb 3-n\u00e1l.<\/p><\/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\"><p><strong>Nagyobb mint<\/strong>, jele: <strong>&gt;<\/strong>, billenty\u0171kombin\u00e1ci\u00f3ja: <em>AltGr+Y<\/em>.<br \/>Azt vizsg\u00e1ljuk, illetve azt felt\u00e9telezz\u00fck, hogy az oper\u00e1tor el\u0151tti \u00e9rt\u00e9k nagyobb az oper\u00e1tor ut\u00e1n \u00edrt \u00e9rt\u00e9kn\u00e9l. Ha igen, akkor az eredm\u00e9ny logikai IGAZ, ha nem, akkor logikai HAMIS.<br \/>P\u00e9lda: =5&gt;3<br \/>A k\u00e9pletben azt vizsg\u00e1ljuk, hogy az 5 nagyobb-e 3-n\u00e1l. A k\u00e9plet eredm\u00e9nye logikai IGAZ, mert az 5 nagyobb 3-n\u00e1l.<\/p><\/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\"><p><strong>Egyenl\u0151<\/strong>, jele: <strong>=<\/strong> , billenty\u0171kombin\u00e1ci\u00f3ja: <em>Shift+7<\/em>.<br \/>Az oper\u00e1tor el\u0151tt \u00e9s ut\u00e1n fel\u00edrt k\u00e9t \u00e9rt\u00e9k azonoss\u00e1g\u00e1t vizsg\u00e1ljuk. Ha a k\u00e9t \u00e9rt\u00e9k egyenl\u0151, megegyezik, akkor logikai IGAZ, ha nem, akkor logikai HAMIS eredm\u00e9nyt kapunk.<br \/>P\u00e9lda: =5=3<br \/>A k\u00e9pletben azt vizsg\u00e1ljuk, hogy az 5 egyenl\u0151-e 3-al. A k\u00e9plet eredm\u00e9nye logikai HAMIS, mert az 5 nem egyenl\u0151 3-al.<\/p><\/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\"><p><strong>Nem egyenl\u0151<\/strong>, jele: <strong>&lt;&gt;<\/strong>, billenty\u0171kombin\u00e1ci\u00f3ja: <em>AltGr+\u00cd<\/em>, majd <em>AltGr+Y<\/em>, a k\u00e9t oper\u00e1tor k\u00f6z\u00f6tt nem szabad \u00fcres helyet, sz\u00f3k\u00f6zt hagyni.<br \/>Azt vizsg\u00e1ljuk, hogy az oper\u00e1tor el\u0151tt \u00e9s ut\u00e1n fel\u00edrt k\u00e9t \u00e9rt\u00e9k elt\u00e9r-e egym\u00e1st\u00f3l, illetve azt \u00e1ll\u00edtjuk, hogy nem egyeznek meg. Ha a k\u00e9t \u00e9rt\u00e9k nem egyenl\u0151, akkor logikai IGAZ, ha egyenl\u0151, akkor logikai HAMIS eredm\u00e9nyt kapunk.<br \/>P\u00e9lda: =5&lt;&gt;5<br \/>A k\u00e9pletben azt \u00e1ll\u00edtjuk, hogy az 5 nem egyenl\u0151 5-el. A k\u00e9plet eredm\u00e9nye logikai HAMIS, mert az 5 egyenl\u0151 5-el.<\/p><\/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\"><p><strong>Kisebb vagy egyenl\u0151<\/strong>, jele: <strong>&lt;=<\/strong>, billenty\u0171kombin\u00e1ci\u00f3ja: <em>AltGr+\u00cd<\/em>, majd <em>Shift+7<\/em>, a k\u00e9t oper\u00e1tor k\u00f6z\u00f6tt nem szabad \u00fcres helyet, sz\u00f3k\u00f6zt hagyni.<br \/>Azt vizsg\u00e1ljuk, illetve azt felt\u00e9telezz\u00fck, hogy az oper\u00e1tor el\u0151tt fel\u00edrt \u00e9rt\u00e9k kisebb vagy megegyezik az oper\u00e1tor ut\u00e1n fel\u00edrt \u00e9rt\u00e9kn\u00e9l. Ha igen, akkor logikai IGAZ, ha nem, akkor logikai HAMIS eredm\u00e9nyt kapunk.<br \/>P\u00e9lda: =5&lt;=5<br \/>A k\u00e9pletben azt vizsg\u00e1ljuk, hogy az 5 kisebb-e vagy megegyezik-e 5-el. A k\u00e9plet eredm\u00e9nye logikai IGAZ, hiszen az 5 ugyan nem kisebb 5-n\u00e9l, de egyenl\u0151 5-el.<\/p><\/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\"><p><strong>Nagyobb vagy egyenl\u0151<\/strong>, jele: <strong>&gt;=<\/strong>, billenty\u0171kombin\u00e1ci\u00f3ja: <em>AltGr+Y<\/em>, majd <em>Shift+7<\/em>, a k\u00e9t oper\u00e1tor k\u00f6z\u00f6tt nem szabad \u00fcres helyet, sz\u00f3k\u00f6zt hagyni.<br \/>Azt vizsg\u00e1ljuk, illetve azt felt\u00e9telezz\u00fck, hogy az oper\u00e1tor el\u0151tt fel\u00edrt \u00e9rt\u00e9k nagyobb az oper\u00e1tor ut\u00e1n fel\u00edrt \u00e9rt\u00e9kn\u00e9l vagy egyenl\u0151-e azzal. Ha igen, akkor logikai IGAZ, ha nem, akkor logikai HAMIS eredm\u00e9nyt kapunk.<br \/>P\u00e9lda: =5&gt;=3<br \/>A k\u00e9pletben azt vizsg\u00e1ljuk, hogy az 5 nagyobb-e vagy megegyezik-e 3-al. A k\u00e9plet eredm\u00e9nye logikai IGAZ, hiszen az 5 ugyan nem egyenl\u0151 3-al, de nagyobb mint 3.<\/p><\/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-353f06f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"353f06f\" 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-3255422\" data-id=\"3255422\" 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-45a4653 elementor-widget elementor-widget-text-editor\" data-id=\"45a4653\" 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 &lt;= \u00e9s a &gt;= oper\u00e1torokban a m\u0171veleti jelek nem cser\u00e9lhet\u0151k fel egym\u00e1ssal<\/strong>, teh\u00e1t az =&lt; \u00e9s az =&gt; \u00edr\u00e1sm\u00f3d helytelen. Ha m\u00e9gis \u00edgy \u00edrjuk fel ezt a k\u00e9t oper\u00e1tort, az Excel javaslatot tesz a k\u00e9plet jav\u00edt\u00e1s\u00e1ra a k\u00e9t oper\u00e1tor felcser\u00e9l\u00e9s\u00e9vel.<\/p>\n\n<p>K\u00e9pletekben teh\u00e1t a fenti mintap\u00e9ld\u00e1k szerint kell alkalmazni a rel\u00e1ci\u00f3s oper\u00e1torokat. Mindig \u00fcgyeln\u00fcnk kell arra, hogy az oper\u00e1tor el\u0151tt \u00e9s ut\u00e1n is legyen \u00e9rt\u00e9k. Az Excel sz\u00e1mos f\u00fcggv\u00e9ny\u00e9ben param\u00e9terk\u00e9nt megadhatunk \u00f6sszehasonl\u00edt\u00f3 m\u0171veletet \u2013 egyesekn\u00e9l, mint p\u00e9ld\u00e1ul a HA() f\u00fcggv\u00e9nyn\u00e9l, k\u00f6telez\u0151 \u00f6sszehasonl\u00edt\u00f3 m\u0171veletet megadni.<\/p>\n\n<p>Mindemellett az Excel tartalmaz olyan m\u0171veleteket, szolg\u00e1ltat\u00e1sokat, t\u00f6bbnyire p\u00e1rbesz\u00e9dpanelek beviteli mez\u0151it, amikor elegend\u0151 csak az oper\u00e1tort, illetve a m\u00f6g\u00f6tte felt\u00fcntetni k\u00edv\u00e1nt \u00e9rt\u00e9ket megadni. Ilyen szolg\u00e1ltat\u00e1s p\u00e9ld\u00e1ul az ir\u00e1ny\u00edtott vagy automatikus sz\u0171r\u00e9s.<\/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-6ec4899 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ec4899\" 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-8389de2\" data-id=\"8389de2\" 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-cc1a7c9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"cc1a7c9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. Precedencia szab\\u00e1ly&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. Precedencia szab\u00e1ly<\/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-fd2a38c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd2a38c\" 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-ff83f26\" data-id=\"ff83f26\" 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-ee4a77e elementor-widget elementor-widget-text-editor\" data-id=\"ee4a77e\" 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 egy k\u00e9pletben vegyesen alkalmazunk (matematikai, sz\u00f6veg\u00f6sszef\u0171z\u0151, hivatkoz\u00e1si, rel\u00e1ci\u00f3s) oper\u00e1torokat, akkor tiszt\u00e1ban kell lenn\u00fcnk a m\u0171veletek v\u00e9grehajt\u00e1si sorrendj\u00e9vel, vagyis a precedencia szab\u00e1llyal. <strong>E szab\u00e1ly szerint a rel\u00e1ci\u00f3s oper\u00e1torok a v\u00e9grehajt\u00e1si sorrend v\u00e9g\u00e9n \u00e1llnak, vagyis az Excel ezeket hajtja v\u00e9gre utolj\u00e1ra.<\/strong><\/p>\n\n<p>N\u00e9zz\u00fcnk erre egy p\u00e9ld\u00e1t! Az <strong>=5+3&gt;7*3<\/strong> k\u00e9plet eredm\u00e9nye logikai HAMIS. Ennek oka, hogy az Excel el\u0151sz\u00f6r az <strong>\u00f6sszead\u00e1st<\/strong> \u00e9s a <strong>szorz\u00e1st<\/strong> hajtja v\u00e9gre, majd a k\u00e9t aritmetikai m\u0171velet eredm\u00e9ny\u00e9t hasonl\u00edtja \u00f6ssze a <strong>nagyobb mint<\/strong> rel\u00e1ci\u00f3s oper\u00e1torral. Mivel az 5+3 eredm\u00e9nye 8, a 7*3 eredm\u00e9nye pedig 21, \u00edgy az az \u00e1ll\u00edt\u00e1s, hogy a 8 nagyobb 21-n\u00e9l HAMIS.<\/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-c125e01 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c125e01\" 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-df66b82\" data-id=\"df66b82\" 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-d3cda07 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"d3cda07\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. A z\\u00e1r\\u00f3jelek haszn\\u00e1lata&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 z\u00e1r\u00f3jelek haszn\u00e1lata<\/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-41138a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"41138a7\" 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-b142a39\" data-id=\"b142a39\" 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-ed676c0 elementor-widget elementor-widget-text-editor\" data-id=\"ed676c0\" 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>\u00d6sszetett \u00f6sszehasonl\u00edt\u00e1sn\u00e1l haszn\u00e1lhatjuk a z\u00e1r\u00f3jeleket<\/strong> a m\u0171velet v\u00e9grehajt\u00e1si sorrendj\u00e9nek, vagyis a precedencia szab\u00e1ly fel\u00fclb\u00edr\u00e1l\u00e1s\u00e1ra.<br \/>P\u00e9ld\u00e1ul az =(5&gt;=3)=(3=3) k\u00e9plet csak els\u0151 olvas\u00e1sra t\u0171nik bonyolultnak, pedig mind\u00f6ssze k\u00e9t r\u00e9szfelt\u00e9tel egyenl\u0151s\u00e9g\u00e9t vizsg\u00e1ljuk. A k\u00f6z\u00e9pen tal\u00e1lhat\u00f3 egyenl\u0151s\u00e9gjel bal oldal\u00e1n azt vizsg\u00e1ljuk, hogy az 5 nagyobb vagy egyenl\u0151-e 3-n\u00e1l, a jobb oldal\u00e1n l\u00e1that\u00f3 felt\u00e9tel pedig azt vizsg\u00e1lja, hogy a 3 egyenl\u0151-e 3-al. Mivel mind a baloldali, mind a jobboldali felt\u00e9tel eredm\u00e9nye logikai IGAZ, a k\u00e9plet IGAZ eredm\u00e9nyt fog adni, mivel a baloldali logikai IGAZ \u00e9rt\u00e9k egyenl\u0151 a jobboldali logikai IGAZ \u00e9rt\u00e9kkel.<\/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-9a8014a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a8014a\" 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-aa61844\" data-id=\"aa61844\" 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-adf9f55 elementor-widget elementor-widget-text-editor\" data-id=\"adf9f55\" 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 \/><strong>Ha egy k\u00e9pletben a precedencia szab\u00e1ly szerint azonos szint\u0171 oper\u00e1torok sorakoznak egym\u00e1s ut\u00e1n, mint p\u00e9ld\u00e1ul a k\u00f6vetkez\u0151 k\u00e9pletben:<br \/>=5&gt;=3=IGAZ<br \/>akkor a v\u00e9grehajt\u00e1s balr\u00f3l jobbra t\u00f6rt\u00e9nik.<\/strong> Az Excel teh\u00e1t el\u0151sz\u00f6r az 5&gt;=3 felt\u00e9telt vizsg\u00e1lja meg, amelynek eredm\u00e9nye IGAZ. Az IGAZ logikai \u00e9rt\u00e9k egyenl\u0151s\u00e9g\u00e9t vizsg\u00e1lja IGAZ-zal, amelynek eredm\u00e9nye IGAZ.<\/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-81ed247 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"81ed247\" 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-1f34551\" data-id=\"1f34551\" 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-3c49ceb elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"3c49ceb\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. \\u00d6sszefoglal\\u00e1s&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. \u00d6sszefoglal\u00e1s<\/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-96def5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96def5c\" 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-ffe09cb\" data-id=\"ffe09cb\" 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-25ad3c0 elementor-widget elementor-widget-text-editor\" data-id=\"25ad3c0\" 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 rel\u00e1ci\u00f3s, vagyis \u00f6sszehasonl\u00edt\u00f3 oper\u00e1torokat a k\u00e9pletekben k\u00e9t vagy t\u00f6bb \u00e9rt\u00e9k \u00f6sszehasonl\u00edt\u00e1s\u00e1ra haszn\u00e1ljuk. Az \u00f6sszehasonl\u00edt\u00e1s eredm\u00e9nye mindig logikai IGAZ vagy HAMIS \u00e9rt\u00e9k. A 6 db oper\u00e1tor a k\u00f6vetkez\u0151: kisebb (&lt;), nagyobb (&gt;), egyenl\u0151 (=), nem egyenl\u0151 (&lt;&gt;), kisebb vagy egyenl\u0151 (&lt;=) \u00e9s nagyobb vagy egyenl\u0151 (&gt;=).<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>A precedencia szab\u00e1ly kimondja, hogy a m\u0171veleti jelek k\u00f6z\u00fcl az Excel az \u00f6sszehasonl\u00edt\u00f3 oper\u00e1torokat dolgozza fel legutolj\u00e1ra. Ezt a szab\u00e1lyt z\u00e1r\u00f3jelek haszn\u00e1lat\u00e1val ker\u00fclhetj\u00fck meg.<\/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-82259c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"82259c4\" 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-e61357d\" data-id=\"e61357d\" 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-843771f elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"843771f\" 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-c66a3d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c66a3d6\" 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-3aae357\" data-id=\"3aae357\" 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-aea0fef elementor-widget elementor-widget-text-editor\" data-id=\"aea0fef\" 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><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2019 szeptember 15.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (19H1, 1903b18362)<br \/>Irodai programcsomag: Microsoft Office Professional Plus 2016, Havi csatorna<br \/>Szint: kezd\u0151, ECDL: M04\/S6\/4.2.2<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek \u2192 F\u00fcggv\u00e9nyek haszn\u00e1lata<\/b><\/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-97d91a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"97d91a3\" 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-5f862d6\" data-id=\"5f862d6\" 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-42a9bba elementor-widget elementor-widget-shortcode\" data-id=\"42a9bba\" 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--504 \"        data-post-id=\"504\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-504\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-504\">                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-c25d1cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c25d1cb\" 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-a95dd70\" data-id=\"a95dd70\" 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-47b58c8 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=\"47b58c8\" 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>\u00a0Friss\u00edtve: 2020 m\u00e1jus 14. Mir\u0151l sz\u00f3l ez a cikk?Az Excel haszn\u00e1lat\u00e1nak l\u00e9nyege a sz\u00e1m\u00edt\u00e1sok v\u00e9gz\u00e9se az adatokon. Ehhez k\u00e9pleteket \u00e9s azokban t\u00f6bbek k\u00f6z\u00f6tt m\u0171veleti jeleket haszn\u00e1lunk. A m\u0171veleti jelek egyik csoportj\u00e1t alkotj\u00e1k az \u00f6sszehasonl\u00edt\u00f3, \u00fan. rel\u00e1ci\u00f3s oper\u00e1torok. Ezeket mutatjuk be ebben a cikkben. Tartalomjegyz\u00e9k 1. Rel\u00e1ci\u00f3s oper\u00e1torok mint m\u0171veleti jelek \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=504\">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-504","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/504","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=504"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/504\/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=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}