{"id":1888,"date":"2020-02-01T20:15:39","date_gmt":"2020-02-01T19:15:39","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=1888"},"modified":"2022-08-26T16:44:11","modified_gmt":"2022-08-26T14:44:11","slug":"excel-hibaertekek","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=1888","title":{"rendered":"A # hiba\u00e9rt\u00e9kek (#169)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1888\" class=\"elementor elementor-1888\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8fd233f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8fd233f\" 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-824de91\" data-id=\"824de91\" 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-0b76c0a elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"0b76c0a\" 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: 2022 augusztus 26.<\/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-253f44e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"253f44e\" 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-f0b87fe\" data-id=\"f0b87fe\" 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-ee73f40 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"ee73f40\" 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\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek\/Aritmetikai k\u00e9pletek, #1\" data-elementor-lightbox-description=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek\/Aritmetikai k\u00e9pletek, #1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjkwOTEsInVybCI6Imh0dHBzOlwvXC93d3cuZmlhdGx1eGVmZWwuaW5mb1wvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyMlwvMDhcL0JlamVneXplc0ZhY2VUd2l0dGVyX0Npa2tmcmlzc2l0dmVFQ0RMX00wNF9TNl9LZXBsZXRlay1lcy1mdWdndmVueWVrLUFyaXRtZXRpa2FpLWtlcGxldGVrXzEucG5nIn0%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"426\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-1024x545.png\" class=\"elementor-animation-buzz-out attachment-large size-large wp-image-29091\" alt=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek\/Aritmetikai k\u00e9pletek, #1\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-1024x545.png 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-300x160.png 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-768x409.png 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-150x80.png 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1-250x133.png 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/BejegyzesFaceTwitter_CikkfrissitveECDL_M04_S6_Kepletek-es-fuggvenyek-Aritmetikai-kepletek_1.png 1231w\" 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\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-5f363b6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f363b6\" 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-bd18810\" data-id=\"bd18810\" 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-eeee0cf elementor-widget elementor-widget-text-editor\" data-id=\"eeee0cf\" 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 k\u00e9pletekkel dolgozva \u00f3hatatlanul k\u00f6vet\u00fcnk el hib\u00e1kat, amelyeket az Excelnek valahogy jeleznie kell sz\u00e1munkra. Erre k\u00e9t m\u00f3dszer is l\u00e9tezik: az egyik egy hibajelz\u00e9s a cella bal fels\u0151 sark\u00e1ban, a m\u00e1sik egy sz\u00f6veges hiba\u00e9rt\u00e9k megjelen\u00edt\u00e9se a cell\u00e1ban.<br \/>Ebben a cikkben a hiba\u00e9rt\u00e9keket foglaljuk \u00f6ssze.<\/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-59e8847 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"59e8847\" 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-edbff3c\" data-id=\"edbff3c\" 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-c9842ec elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"c9842ec\" 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__c9842ec\" 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__c9842ec\" 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__c9842ec\" 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-fefefe9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fefefe9\" 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-92de7bb\" data-id=\"92de7bb\" 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-6aa1844 elementor-widget elementor-widget-text-editor\" data-id=\"6aa1844\" 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 Excel nyolc hiba\u00e9rt\u00e9ke \u00e1b\u00e9c\u00e9 sorrendben a k\u00f6vetkez\u0151 (z\u00e1r\u00f3jelben az angol nyelv\u0171 Excel hiba\u00e9rt\u00e9keinek neveit is felt\u00fcntett\u00fck):<\/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-ad37bdb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad37bdb\" 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-7b0abec\" data-id=\"7b0abec\" 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-c369199 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"c369199\" 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\">##### \u2013 kett\u0151skeresztek a cell\u00e1ban.<\/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\">#\u00c9RT\u00c9K! (#VALUE!) \u2013 ki\u00e9rt\u00e9kelhetetlen k\u00e9plet.<\/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\">#HI\u00c1NYZIK (#N\/A) \u2013 hi\u00e1nyz\u00f3 adat jelz\u00e9se.<\/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\">#HIV! (#REF!) \u2013 hivatkoz\u00e1s neml\u00e9tez\u0151 cell\u00e1ra.<\/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\">#N\u00c9V? (#NAME?) \u2013 t\u00e9ves vagy hi\u00e1nyz\u00f3 f\u00fcggv\u00e9nyn\u00e9v vagy tartom\u00e1nyn\u00e9v.<\/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\">#NULLA! (#NULL!) \u2013 hib\u00e1s hivatkoz\u00e1si oper\u00e1tor.<\/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\">#SZ\u00c1M! (#NUM!) \u2013 numerikus adatt\u00edpus hi\u00e1nya.<\/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\">#Z\u00c9R\u00d3OSZT\u00d3! (#DIV\/0!) \u2013 null\u00e1val val\u00f3 oszt\u00e1s k\u00eds\u00e9rlete.<\/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-fed5b3c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fed5b3c\" 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-d0ad947\" data-id=\"d0ad947\" 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-9b72409 elementor-widget elementor-widget-text-editor\" data-id=\"9b72409\" 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\u00e9k abban a cell\u00e1ban jelenik meg, amelyben a hiba jelentkezik. Amint a fenti felsorol\u00e1sb\u00f3l l\u00e1tszik, a hiba\u00e9rt\u00e9k kin\u00e9zete egys\u00e9ges: egy # jelet (kett\u0151skereszt, hashmark, number sign) csupa nagybet\u0171s sz\u00f3 vagy r\u00f6vid\u00edt\u00e9s k\u00f6vet, k\u00e9rd\u0151jellel vagy felki\u00e1lt\u00f3jellel lez\u00e1rva, a cell\u00e1n bel\u00fcl v\u00edzszintesen k\u00f6z\u00e9pre z\u00e1rva. Egy kiv\u00e9tel van, amellyel meg is kezdj\u00fck az ismerked\u00e9st, hiszen ennek megjelen\u00e9s\u00e9re sz\u00e1m\u00edthatunk legink\u00e1bb.<\/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-21295a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21295a0\" 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-7f138dd\" data-id=\"7f138dd\" 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-3f1d2f9 elementor-widget elementor-widget-text-editor\" data-id=\"3f1d2f9\" 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>Tipp:<\/strong> A <strong># <\/strong>beg\u00e9pel\u00e9s\u00e9hez haszn\u00e1ljuk az <em>AltGr+X<\/em> billenty\u0171parancsot!<\/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-851187a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"851187a\" 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-8ee5e55\" data-id=\"8ee5e55\" 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-2f23dab elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"2f23dab\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. ##### \\u2013 kett\\u0151skeresztek a cell\\u00e1ban&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. ##### \u2013 kett\u0151skeresztek a cell\u00e1ban<\/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-f29063b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f29063b\" 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-2b67d8d\" data-id=\"2b67d8d\" 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-6592ab5 elementor-widget elementor-widget-text-editor\" data-id=\"6592ab5\" 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 hiba oka: ha egy cell\u00e1ban olyan numerikus adat (sz\u00e1m, d\u00e1tum, p\u00e9nznem) tal\u00e1lhat\u00f3, amelyet az Excel nem tud teljes eg\u00e9sz\u00e9ben megjelen\u00edteni, mert az oszlop ehhez keskeny, akkor kett\u0151skeresztekkel t\u00f6lti fel a cell\u00e1t. Ugyanezzel a hiba\u00e9rt\u00e9kkel tal\u00e1lkozunk akkor is, ha negat\u00edv d\u00e1tum \u00e9s\/vagy id\u0151pont ker\u00fcl egy cell\u00e1ba.<\/strong><\/p>\n\n<p>Ezzel a hiba\u00e9rt\u00e9kkel nem csak a k\u00e9perny\u0151n, hanem nyomtat\u00e1sban is tal\u00e1lkozhatunk. Ez ut\u00f3bbi oka, hogy a nyomtat\u00e1si be\u00e1ll\u00edt\u00e1sok befoly\u00e1solhatj\u00e1k a cell\u00e1k, vagyis az oszlopok sz\u00e9less\u00e9g\u00e9t, benn\u00fck az adatok sz\u00e1m\u00e1ra rendelkez\u00e9sre \u00e1ll\u00f3 sz\u00e9less\u00e9get. \u00cdgy ami a k\u00e9perny\u0151n megfelel\u0151 sz\u00e9less\u00e9g\u0171nek t\u0171nik, az nyomtat\u00e1sban keskenynek bizonyulhat. Ez\u00e9rt mindig ellen\u0151rizz\u00fck a nyomtatni k\u00edv\u00e1nt anyagot nyomtat\u00e1si el\u0151n\u00e9zetben!<\/p>\n\n<p><strong>A hiba jav\u00edt\u00e1sa: a hib\u00e1t k\u00f6nnyen elh\u00e1r\u00edthatjuk, ha az oszlop sz\u00e9less\u00e9g\u00e9t megn\u00f6velj\u00fck ak\u00e1r egy megv\u00e1lasztott \u00e9rt\u00e9ket be\u00e1ll\u00edtva, ak\u00e1r automatikusan, a legsz\u00e9lesebb adathoz igaz\u00edtva a teljes oszlop sz\u00e9less\u00e9g\u00e9t. <\/strong>Az ut\u00f3bbira n\u00e9zz\u00fcnk k\u00e9t tippet!<\/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-7fd6d3a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7fd6d3a\" 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-730afd7\" data-id=\"730afd7\" 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-698c752 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"698c752\" 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\">Eg\u00e9rrel dolgozva egyszer\u0171en kattintsunk k\u00e9tszer a bal eg\u00e9rgombbal az oszlopfejl\u00e9c jobb oldal\u00e1n elhelyezked\u0151 elv\u00e1laszt\u00f3 vonalra, amit az eg\u00e9rmutat\u00f3 megv\u00e1ltozott form\u00e1ja is mutat. Ennek a m\u00f3dszernek el\u0151nye, hogy az oszlopban tal\u00e1lhat\u00f3 legsz\u00e9lesebb adathoz igaz\u00edtja az oszlop sz\u00e9less\u00e9g\u00e9t.<\/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>Haszn\u00e1lhatjuk a men\u00fcszalag <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong>parancs\u00e1t is, amit az <em>Alt+\u0150, FF, U <\/em>billenty\u0171kombin\u00e1ci\u00f3val is el\u00e9rhet\u00fcnk.<\/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-5447ea7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5447ea7\" 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-a8efc4e\" data-id=\"a8efc4e\" 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-6ac61bf elementor-widget elementor-widget-text-editor\" data-id=\"6ac61bf\" 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>Tipp:<\/strong> Egy m\u00e9retesebb t\u00e1bl\u00e1zat elk\u00e9sz\u00edt\u00e9s\u00e9t k\u00f6vet\u0151en, amikor nem tudjuk vagy akarjuk \u00e1tn\u00e9zni a teljes ter\u00fcletet, de biztosra akarunk menni, akkor egyszer\u0171en jel\u00f6lj\u00fck ki a teljes t\u00e1bl\u00e1zatot a <i>Ctrl+T<\/i> billenty\u0171paranccsal, majd haszn\u00e1ljuk a fenti k\u00e9t m\u00f3dszer egyik\u00e9t.<\/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-2d8e723 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2d8e723\" 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-274229b\" data-id=\"274229b\" 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-4b5ccbf elementor-widget elementor-widget-text-editor\" data-id=\"4b5ccbf\" 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 \u00faj munkalapon kezd\u00fcnk dolgozni, akkor azt fogjuk tapasztalni, hogy a numerikus adatok eset\u00e9ben az Excel automatikusan megn\u00f6veli az oszlop sz\u00e9less\u00e9g\u00e9t. \u00c9ppen ez\u00e9rt \u00e9rdemes adatbevitelkor mell\u0151zni a form\u00e1z\u00e1st, hiszen ezt k\u00f6vet\u0151en m\u00e1r nem fog az oszlopok sz\u00e9less\u00e9ge automatikusan v\u00e1ltozni.<\/p>\n<p><strong>Negat\u00edv d\u00e1tum \u00e9s\/vagy id\u0151pont <\/strong><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_.jpg\" target=\"_blank\" rel=\"noopener\">(1. \u00e1bra)<\/a> eset\u00e9n vizsg\u00e1ljuk fel\u00fcl az ezt eredm\u00e9nyez\u0151 k\u00e9pletet, \u00e9s d\u00f6nts\u00fck el, hogy ez hiba \u2013 ebben az esetben jav\u00edtsuk, vagy sz\u00e1nd\u00e9kos jelens\u00e9gk\u00e9nt v\u00e1ltozatlanul hagyjuk!<\/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-354ebc4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"354ebc4\" 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-e894745\" data-id=\"e894745\" 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-ae0cafc elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"ae0cafc\" 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\/2022\/08\/169-K-Excel-hibaertekek_1_.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\/2022\/08\/169-K-Excel-hibaertekek_1_-1024x576.jpg\" class=\"attachment-large size-large wp-image-29081\" alt=\"1. \u00e1bra: A d\u00e1tumform\u00e1tum\u00fa A1 cell\u00e1ban negat\u00edv d\u00e1tumot hoztunk l\u00e9tre a tegnapi napb\u00f3l kivonva a mai napot. L\u00e1that\u00f3, hogy a cell\u00e1ban megjelen\u0151 -1 \u00e9rt\u00e9kre #-ekkel h\u00edvja fel a figyelm\u00fcnket az Excel. Ugyancsak #-ekkel jelzi a hib\u00e1t a Sz\u00e1mform\u00e1tum kombin\u00e1lt listamez\u0151.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_1_.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 d\u00e1tumform\u00e1tum\u00fa A1 cell\u00e1ban negat\u00edv d\u00e1tumot hoztunk l\u00e9tre a tegnapi napb\u00f3l kivonva a mai napot. L\u00e1that\u00f3, hogy a cell\u00e1ban megjelen\u0151 -1 \u00e9rt\u00e9kre #-ekkel h\u00edvja fel a figyelm\u00fcnket az Excel. Ugyancsak #-ekkel jelzi a hib\u00e1t a <strong>Sz\u00e1mform\u00e1tum <\/strong>kombin\u00e1lt listamez\u0151.<\/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-5af6c52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5af6c52\" 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-0b9148c\" data-id=\"0b9148c\" 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-7b8bea8 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"7b8bea8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. #\\u00c9RT\\u00c9K! \\u2013 ki\\u00e9rt\\u00e9kelhetetlen k\\u00e9plet&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. #\u00c9RT\u00c9K! \u2013 ki\u00e9rt\u00e9kelhetetlen k\u00e9plet<\/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-413f7a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"413f7a8\" 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-ce922fb\" data-id=\"ce922fb\" 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-2136e12 elementor-widget elementor-widget-text-editor\" data-id=\"2136e12\" 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 hiba oka, hogy a k\u00e9plet ki\u00e9rt\u00e9kelhetetlen az Excel sz\u00e1m\u00e1ra.<\/strong> Ennek sz\u00e1mos oka lehet, p\u00e9ld\u00e1ul a k\u00e9pletben olyan \u00e9rt\u00e9kek, elt\u00e9r\u0151 adatt\u00edpusok, hivatkozott cell\u00e1k, tartom\u00e1nyok tal\u00e1lhat\u00f3k, amelyekkel val\u00f3 m\u0171veletv\u00e9gz\u00e9s helytelen eredm\u00e9nyt hozna.<\/p>\n<p><strong>A megold\u00e1s<\/strong> minden esetben a fentiek megvizsg\u00e1l\u00e1sa: helyes-e a k\u00e9plet, nincsenek-e \u00fctk\u00f6z\u0151 adatt\u00edpusok stb. Jellemz\u0151 az ut\u00f3bbi hiba elk\u00f6vet\u00e9se, amikor egy k\u00e9pletben elt\u00e9r\u0151 adatt\u00edpusokra hivatkozunk, azokkal akarunk egy azonos adatt\u00edpus\u00fa operandusokat k\u00edv\u00e1n\u00f3 sz\u00e1m\u00edt\u00e1st elv\u00e9gezni. A <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1br\u00e1n<\/a> egy ilyenre l\u00e1tunk egy egyszer\u0171 p\u00e9ld\u00e1t, amikor az A1 cell\u00e1ban egy sz\u00f6veget, Az A2 cell\u00e1ban pedig egy sz\u00e1mot elhelyezve, a kett\u0151 k\u00f6z\u00f6tt akarunk matematikai m\u0171veletet, eset\u00fcnkben egy kivon\u00e1st v\u00e9gezni az A3 cell\u00e1ban (=A1-A2). A k\u00e9pen l\u00e1tjuk azt is, hogy a <strong>Sz\u00e1mform\u00e1tum<\/strong> lista is jelzi a #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9ket.<\/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-3285b8d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3285b8d\" 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-baa4442\" data-id=\"baa4442\" 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-4df7a81 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"4df7a81\" 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\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK.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\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-1024x576.jpg\" class=\"attachment-large size-large wp-image-29082\" alt=\"2. \u00e1bra: Az A1 \u00e9s az A2 cell\u00e1ban elt\u00e9r\u0151 adatt\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k, amelyek k\u00f6z\u00f6tt kivon\u00e1st akarunk v\u00e9gezni az A3 cell\u00e1ban. Ez nyilv\u00e1n ki\u00e9rt\u00e9kelhetetlen k\u00e9plet, \u00edgy meg is kaptuk a #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9ket, amit a Sz\u00e1mform\u00e1tum kombin\u00e1lt listamez\u0151ben is jelez az Excel.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_2_ERTEK.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: Az A1 \u00e9s az A2 cell\u00e1ban elt\u00e9r\u0151 adatt\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k, amelyek k\u00f6z\u00f6tt kivon\u00e1st akarunk v\u00e9gezni az A3 cell\u00e1ban. Ez nyilv\u00e1n ki\u00e9rt\u00e9kelhetetlen k\u00e9plet, \u00edgy meg is kaptuk a <strong>#\u00c9RT\u00c9K! <\/strong>hiba\u00e9rt\u00e9ket, amit a <strong>Sz\u00e1mform\u00e1tum <\/strong>kombin\u00e1lt listamez\u0151ben is jelez az Excel.<\/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-7668183 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7668183\" 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-4ba6f64\" data-id=\"4ba6f64\" 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-417f1c2 elementor-widget elementor-widget-text-editor\" data-id=\"417f1c2\" 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>Tipp:<\/strong> A leggyakoribb hiba, amikor egy sz\u00e1mot sz\u00f6vegk\u00e9nt r\u00f6gz\u00edt\u00fcnk (sz\u00f3k\u00f6z, l az 1-es helyett, o a nulla helyett, m\u00e9rt\u00e9kegys\u00e9g, ezres elv\u00e1laszt\u00f3 stb.). Ez amilyen gyakori, olyan nehezen felder\u00edthet\u0151 hiba. Ez\u00e9rt javasoljuk, hogy a form\u00e1z\u00e1st mindig el\u0151zze meg az adatbevitel \u2013 adatbevitel k\u00f6zben ne form\u00e1zzunk, ne haszn\u00e1ljunk automatikus form\u00e1z\u00e1st (d\u00e1tum, %, p\u00e9nznem), ne form\u00e1zzuk el\u0151 a cell\u00e1kat. Ha egy megl\u00e9v\u0151 t\u00e1bl\u00e1zaton jav\u00edtunk, m\u00f3dos\u00edtunk adatokat, akkor j\u00e1rjuk el figyelmesen, a sz\u00e1m r\u00f6gz\u00edt\u00e9sekor!<\/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-bef21cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bef21cc\" 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-65df652\" data-id=\"65df652\" 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-737e319 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"737e319\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. #HI\\u00c1NYZIK \\u2013 hi\\u00e1nyz\\u00f3 adat jelz\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3. #HI\u00c1NYZIK \u2013 hi\u00e1nyz\u00f3 adat jelz\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dff7eb5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dff7eb5\" 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-9be26d4\" data-id=\"9be26d4\" 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-d6d9c0c elementor-widget elementor-widget-text-editor\" data-id=\"d6d9c0c\" 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>Ezt a hiba\u00e9rt\u00e9ket akkor kapjuk, ha egy k\u00e9pletben vagy f\u00fcggv\u00e9nyben hi\u00e1nyz\u00f3 adatra hivatkozunk. Ugyanakkor sz\u00e1nd\u00e9kosan is el\u0151id\u00e9zhetj\u00fck a hiba\u00e9rt\u00e9ket a #HI\u00c1NYZIK \u00e1lland\u00f3val (konstanssal) vagy a HI\u00c1NYZIK nev\u0171 f\u00fcggv\u00e9nnyel.<\/strong> Az angol nyelv\u0171 kiad\u00e1sban a konstans neve #NA, a f\u00fcggv\u00e9ny\u00e9 NA.<\/p>\n<p>A <strong>#HI\u00c1NYZIK hiba\u00e9rt\u00e9k <\/strong>azt jelzi, hogy k\u00e9plet\u00fcnk egy vagy t\u00f6bb hivatkoz\u00e1sa hi\u00e1nyos vagy nem j\u00f3l el\u0151k\u00e9sz\u00edtett adatra mutat. Ezt a hiba\u00e9rt\u00e9ket kapjuk keres\u0151f\u00fcggv\u00e9nyekn\u00e9l (FKERES, KERES, VKERES stb.), amennyiben a keres\u00e9s nem j\u00e1r eredm\u00e9nnyel, a keresett \u00e9rt\u00e9k nem tal\u00e1lhat\u00f3, vagy elt\u00e9r\u0151 adatt\u00edpusok tal\u00e1lhat\u00f3k a keresett \u00e9rt\u00e9kek k\u00f6z\u00f6tt, vagy felesleges sz\u00f3k\u00f6z\u00f6kkel terheltek az adatok. A hiba jav\u00edt\u00e1s\u00e1hoz ellen\u0151rizz\u00fck a hivatkozott cell\u00e1k adatt\u00edpus\u00e1t, tartalm\u00e1t, n\u00e9zz\u00fck meg, hogy az alkalmazott f\u00fcggv\u00e9ny el\u0151\u00edr\u00e1sainak megfelel\u0151en k\u00e9sz\u00edtett\u00fck el\u0151 a hivatkozott cell\u00e1kat!<\/p>\n<p>A <strong>#HI\u00c1NYZIK konstans<\/strong> vagy a <strong>HI\u00c1NYZIK f\u00fcggv\u00e9ny<\/strong> alkalmaz\u00e1s\u00e1t az a tipikus hiba indokolja, hogy t\u00e1bl\u00e1zatunk adatainak felt\u00f6lt\u00e9sekor a hi\u00e1nyz\u00f3 adatokat \u00fcresen hagyott cell\u00e1val, kit\u00f6lt\u0151 karakterrel, vagy valamilyen nulla \u00e9rt\u00e9kkel (nulla sz\u00e1m, \u00fcres karaktersorozat) jelezz\u00fck. Ez azonban nem helyes, mivel nem tudhatjuk, tudhatj\u00e1k a t\u00e1bl\u00e1zattal dolgoz\u00f3k, hogy az \u00edgy jelzett cell\u00e1k adatnak vagy adathi\u00e1nynak sz\u00e1m\u00edtanak-e, s\u0151t ezek az \u00e9rt\u00e9kek egyes f\u00fcggv\u00e9nyek, sz\u00e1m\u00edt\u00e1sok v\u00e9gz\u00e9s\u00e9n\u00e9l hiba\u00e9rt\u00e9ket vagy nehezen felder\u00edthet\u0151 hib\u00e1t okozhatnak. Ezt elker\u00fclve a hi\u00e1nyz\u00f3 adat cell\u00e1j\u00e1ba a #HI\u00c1NYZIK konstanst vagy az =HI\u00c1NYZIK() f\u00fcggv\u00e9nyt g\u00e9pelj\u00fck be. Az\u00a0Excel figyel a hiba\u00e9rt\u00e9k sz\u00e1nd\u00e9kos alkalmaz\u00e1s\u00e1ra, \u00e9s figyelembe veszi jelenl\u00e9t\u00e9t. Alkalmaz\u00e1sa igaz\u00e1n a diagramokn\u00e1l l\u00e1tv\u00e1nyos, ahol nem mindegy, hogy a hi\u00e1nyz\u00f3 adatokat p\u00e9ld\u00e1ul nulla vagy a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k jelzi.<\/p>\n<p>N\u00e9zz\u00fcnk ez ut\u00f3bbira k\u00e9t \u00e1br\u00e1t, amely egy egyszer\u0171 t\u00e1bl\u00e1zatr\u00f3l k\u00e9sz\u00edtett diagramot mutat mindk\u00e9t esetre. A <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK.jpg\" target=\"_blank\" rel=\"noopener\">3. \u00e1br\u00e1n<\/a> l\u00e1that\u00f3, hogy a hi\u00e1nyz\u00f3k\u00e9nt jel\u00f6lt <strong>Jutal\u00e9k<\/strong> \u00e9rt\u00e9kek f\u00e9lre\u00e9rthet\u0151ek, a vonaldiagramon \u00e9rv\u00e9nyes adatk\u00e9nt jelennek meg, m\u00edg a hiba\u00e9rt\u00e9k alkalmaz\u00e1s\u00e1val a vonaldiagram folytonoss\u00e1gi hi\u00e1nya az adatok hi\u00e1ny\u00e1t jelzi <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK.jpg\" target=\"_blank\" rel=\"noopener\">(4. \u00e1bra)<\/a>\u00a0\u2013 a grafikonon az adatsort ki kell jel\u00f6ln\u00fcnk, hogy l\u00e1thassuk, mely adatok hi\u00e1nyoznak val\u00f3j\u00e1ban. \u00c9rdemes teh\u00e1t r\u00e1szoknunk a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k vagy a HI\u00c1NYZIK f\u00fcggv\u00e9ny tudatos haszn\u00e1lat\u00e1ra.<\/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-6502b3b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6502b3b\" 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-e9b3760\" data-id=\"e9b3760\" 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-90a61de elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"90a61de\" 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\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-1024x576.jpg\" class=\"attachment-large size-large wp-image-29083\" alt=\"3. \u00e1bra: A D5, D7 \u00e9s D10 cell\u00e1kban a hi\u00e1nyz\u00f3 adatokat a megszokott m\u00f3don, nulla \u00e9rt\u00e9kkel \u00e9s karaktersorozattal jelezt\u00fck. A diagramon semmi sem utal arra, hogy ezek nem \u00e9rv\u00e9nyes adatok \u2013 az Excel null\u00e1nak vette a cell\u00e1k tartalm\u00e1t \u2013 ez pedig f\u00e9lre\u00e9rthet\u0151v\u00e9 teszi a diagramot.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_3_HIANYZIK.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\">3. \u00e1bra: A D5, D7 \u00e9s D10 cell\u00e1kban a hi\u00e1nyz\u00f3 adatokat a megszokott m\u00f3don, nulla \u00e9rt\u00e9kkel \u00e9s karaktersorozattal jelezt\u00fck. A diagramon semmi sem utal arra, hogy ezek nem \u00e9rv\u00e9nyes adatok \u2013 az Excel null\u00e1nak vette a cell\u00e1k tartalm\u00e1t \u2013 ez pedig f\u00e9lre\u00e9rthet\u0151v\u00e9 teszi a diagramot.<\/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-9410b1e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9410b1e\" 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-31496c4\" data-id=\"31496c4\" 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-3707830 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"3707830\" 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\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-1024x576.jpg\" class=\"attachment-large size-large wp-image-29084\" alt=\"4. \u00e1bra: A helyes megold\u00e1s a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k vagy a HI\u00c1NYZIK f\u00fcggv\u00e9ny alkalmaz\u00e1sa. A diagram m\u00e1ris f\u00e9lre\u00e9rthetetlen\u00fcl jelzi a hi\u00e1nyz\u00f3 adatokat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_4_HIANYZIK.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\">4. \u00e1bra: A helyes megold\u00e1s a <strong>#HI\u00c1NYZIK <\/strong>hiba\u00e9rt\u00e9k vagy a <strong>HI\u00c1NYZIK <\/strong>f\u00fcggv\u00e9ny alkalmaz\u00e1sa. A diagram m\u00e1ris f\u00e9lre\u00e9rthetetlen\u00fcl jelzi a hi\u00e1nyz\u00f3 adatokat.<\/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-e0c00de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e0c00de\" 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-b932045\" data-id=\"b932045\" 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-4ab6a7c elementor-widget elementor-widget-text-editor\" data-id=\"4ab6a7c\" 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>Tipp:<\/strong> A <strong>#HI\u00c1NYZIK<\/strong> konstanst kisbet\u0171kkel, <em>#hi\u00e1nyzik<\/em> m\u00f3don is beg\u00e9pelhetj\u00fck egy cell\u00e1ba. Mind a konstans, mind a f\u00fcggv\u00e9ny a cell\u00e1n bel\u00fcl k\u00f6z\u00e9pre z\u00e1rtan, csupa nagybet\u0171kkel jelen\u00edti meg a #HI\u00c1NYZIK sz\u00f6veget.<\/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-ba5e0e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ba5e0e8\" 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-781b0df\" data-id=\"781b0df\" 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-f265df9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f265df9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. #HIV! \\u2013 hivatkoz\\u00e1s neml\\u00e9tez\\u0151 cell\\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<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. #HIV! \u2013 hivatkoz\u00e1s neml\u00e9tez\u0151 cell\u00e1ra<\/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-d8ccd7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8ccd7c\" 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-e306dae\" data-id=\"e306dae\" 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-7ef8ac6 elementor-widget elementor-widget-text-editor\" data-id=\"7ef8ac6\" 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 #HIV! hiba\u00e9rt\u00e9k el\u0151fordul\u00e1s\u00e1nak tipikus oka, hogy egy kor\u00e1bban elk\u00e9sz\u00edtett k\u00e9pletben hivatkozott cell\u00e1t vagy tartom\u00e1nyt t\u00f6rl\u00fcnk.<\/strong><\/p>\n<p>Amikor egy t\u00e1bl\u00e1zatban az oszlopok \u00e9s\/vagy sorok cell\u00e1in sz\u00e1m\u00edt\u00e1sokat v\u00e9gz\u00fcnk, majd szerkesztj\u00fck a t\u00e1bl\u00e1zat oszlopait \u00e9s\/vagy sorait, besz\u00farva \u00e9s\/vagy t\u00f6r\u00f6lve oszlopokat \u00e9s\/vagy sorokat, akkor nagyon kell vigy\u00e1znunk, hogy a k\u00e9pletekben hivatkozott cell\u00e1k \u00e9s tartom\u00e1nyok ne t\u00f6rl\u0151djenek. Persze a hib\u00e1t sz\u00e1nd\u00e9kosan is el\u0151id\u00e9zhetj\u00fck \u2013 ebben az esetben jav\u00edtanunk kell a k\u00e9pletek hivatkoz\u00e1sain.<\/p>\n<p>A k\u00f6vetkez\u0151 k\u00e9t \u00e1br\u00e1n l\u00e1that\u00f3 munkalap A1:D6 tartom\u00e1ny\u00e1ban, egy n\u00e9gy oszlopb\u00f3l \u00e9s hat sorb\u00f3l \u00e1ll\u00f3 t\u00e1bl\u00e1zatot l\u00e1tunk, amelynek els\u0151 sora oszlopfeliratokat tartalmaz. A k\u00e9t \u00e1br\u00e1val azt mutatjuk be, hogy a D7-es cell\u00e1ban l\u00e1that\u00f3 \u00f6sszegre (=D2+D3+D4+D5+D6) milyen hat\u00e1ssal van, ha kit\u00f6r\u00f6lj\u00fck a negyedik sort. Mivel a k\u00e9pletben k\u00f6zvetlen\u00fcl hivatkoztunk a D4-es cell\u00e1ra <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV.jpg\" target=\"_blank\" rel=\"noopener\">(5. \u00e1bra)<\/a>, a t\u00f6rl\u00e9st k\u00f6vet\u0151en a hi\u00e1ny a #HIV! hiba\u00e9rt\u00e9ket fogja eredm\u00e9nyezni a D7-es cell\u00e1ban <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV.jpg\" target=\"_blank\" rel=\"noopener\">(6. \u00e1bra)<\/a>.<\/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-183ff68 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"183ff68\" 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-5422c5e\" data-id=\"5422c5e\" 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-48909b6 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"48909b6\" 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\/2022\/08\/169-K-Excel-hibaertekek_5_HIV.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-1024x576.jpg\" class=\"attachment-large size-large wp-image-29085\" alt=\"5. \u00e1bra: A D7-es cell\u00e1ban minden adatra egyenk\u00e9nt hivatkoztunk, ahogy az a Szerkeszt\u0151l\u00e9cen l\u00e1that\u00f3.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_5_HIV.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\">5. \u00e1bra: A D7-es cell\u00e1ban minden adatra egyenk\u00e9nt hivatkoztunk, ahogy az a <strong>Szerkeszt\u0151l\u00e9cen <\/strong>l\u00e1that\u00f3.<\/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-83fc625 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"83fc625\" 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-38d0fd1\" data-id=\"38d0fd1\" 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-251b276 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"251b276\" 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\/2022\/08\/169-K-Excel-hibaertekek_6_HIV.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-1024x576.jpg\" class=\"attachment-large size-large wp-image-29086\" alt=\"6. \u00e1bra: A negyedik sor t\u00f6rl\u00e9s\u00e9t k\u00f6vet\u0151en a D7 k\u00e9plet\u00e9ben a D4-re hivatkoz\u00e1s a #HIV! hiba\u00e9rt\u00e9ket eredm\u00e9nyezte.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_6_HIV.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\">6. \u00e1bra: A negyedik sor t\u00f6rl\u00e9s\u00e9t k\u00f6vet\u0151en a D7 k\u00e9plet\u00e9ben a D4-re hivatkoz\u00e1s a <strong>#HIV! <\/strong>hiba\u00e9rt\u00e9ket eredm\u00e9nyezte.<\/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-ad5f94d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad5f94d\" 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-c852091\" data-id=\"c852091\" 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-24d7e1f elementor-widget elementor-widget-text-editor\" data-id=\"24d7e1f\" 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 gyakorlatban, \u00e9s a #HIV! hiba\u00e9rt\u00e9k eredm\u00e9nyes elker\u00fcl\u00e9se \u00e9rdek\u00e9ben nem a fenti p\u00e9lda szerint szoktunk elj\u00e1rni, hanem tartom\u00e1nyk\u00e9nt hivatkozunk a cell\u00e1kra. Ha a D7-es cell\u00e1ban kijav\u00edtjuk a k\u00e9pletet erre: =SZUM(D2:D6) \u2013 akkor az Excel k\u00e9pes lesz \u201e\u00e1tugorni\u201d a t\u00f6r\u00f6lt cell\u00e1t, kijav\u00edtani a hivatkoz\u00e1sokat. Emiatt a most m\u00e1r D6-os cell\u00e1ban az =SZUM(D2:D5) k\u00e9pletet fogjuk l\u00e1tni.<\/p>\n\n<p>A #HIV! hiba\u00e9rt\u00e9k teh\u00e1t legink\u00e1bb t\u00e9ves, m\u00f3dosult, \u201emegs\u00e9r\u00fclt\u201d hivatkoz\u00e1sn\u00e1l fordul el\u0151, \u00edgy az abszol\u00fat, vegyes, munkalap \u00e9s munkaf\u00fczet hivatkoz\u00e1sokn\u00e1l mindig gondosan j\u00e1rjunk el!<\/p>\n\n<p>A #HIV! hiba\u00e9rt\u00e9k jelzi egyes f\u00fcggv\u00e9nyekn\u00e9l a rosszul megadott tartom\u00e1nyhivatkoz\u00e1st, ha nem a k\u00edv\u00e1nt m\u00f3don adtuk azt meg (kisebb vagy nagyobb tartom\u00e1nyt adunk meg, nem a megfelel\u0151 tartom\u00e1nyra hivatkozunk stb.).<\/p>\n\n<p>Szint\u00e9n a #HIV! hiba\u00e9rt\u00e9kkel jutalmaz minket az Excel, ha ir\u00e1ny\u00edtott beilleszt\u00e9st <strong>(<u>OLE<\/u>, <u>DDE<\/u>)<\/strong> hajtottunk v\u00e9gre, \u00e9s az Excel nem tal\u00e1lja a forr\u00e1st.<\/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-ae645f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae645f8\" 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-8ae70b4\" data-id=\"8ae70b4\" 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-cfe9e3d elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"cfe9e3d\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. #N\\u00c9V? \\u2013 t\\u00e9ves vagy hi\\u00e1nyz\\u00f3 f\\u00fcggv\\u00e9ny- vagy tartom\\u00e1nyn\\u00e9v&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. #N\u00c9V? \u2013 t\u00e9ves vagy hi\u00e1nyz\u00f3 f\u00fcggv\u00e9ny- vagy tartom\u00e1nyn\u00e9v<\/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-c67e990 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c67e990\" 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-8239a0e\" data-id=\"8239a0e\" 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-4c0ff78 elementor-widget elementor-widget-text-editor\" data-id=\"4c0ff78\" 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>Ezzel a hiba\u00e9rt\u00e9kkel leggyakrabban akkor tal\u00e1lkozunk, ha egy k\u00e9pletben rosszul g\u00e9pelt\u00fck be egy f\u00fcggv\u00e9ny nev\u00e9t, vagy egy tartom\u00e1nynevet, vagy egy karaktersorozatn\u00e1l lehagyjuk a hat\u00e1rol\u00f3 id\u00e9z\u0151jeleket.<\/strong> <strong>Ugyancsak ezt a hiba\u00e9rt\u00e9ket kapjuk, ha nem l\u00e9tez\u0151 f\u00fcggv\u00e9nyre vagy tartom\u00e1nyn\u00e9vre hivatkozunk.<\/strong><\/p>\n\n<p>A hib\u00e1t k\u00f6nny\u0171 elker\u00fcln\u00fcnk: haszn\u00e1ljuk a f\u00fcggv\u00e9ny \u00e9s tartom\u00e1nynevek r\u00f6gz\u00edt\u00e9s\u00e9t megk\u00f6nny\u00edt\u0151 szolg\u00e1ltat\u00e1sokat, figyelj\u00fcnk a pontos szintaxisra.<\/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-4fd9062 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4fd9062\" 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-bc75687\" data-id=\"bc75687\" 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-5c157df elementor-widget elementor-widget-text-editor\" data-id=\"5c157df\" 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>Tipp:<\/strong> Leggyakrabban a SZUM f\u00fcggv\u00e9ny nev\u00e9t szoktuk elg\u00e9pelni, SUM-ot \u00edrva SZUM helyett. Szint\u00e9n gyakori az \u00e9kezet, vagy a pont elhagy\u00e1sa a f\u00fcggv\u00e9ny nev\u00e9b\u0151l.<\/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-247ad83 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"247ad83\" 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-d43025b\" data-id=\"d43025b\" 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-c725e04 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"c725e04\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;6. #NULLA! \\u2013 hib\\u00e1s hivatkoz\\u00e1si oper\\u00e1tor&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. #NULLA! \u2013 hib\u00e1s hivatkoz\u00e1si oper\u00e1tor<\/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-ee62e85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ee62e85\" 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-03a0185\" data-id=\"03a0185\" 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-ecde427 elementor-widget elementor-widget-text-editor\" data-id=\"ecde427\" 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>K\u00e9pletekben \u00e9s f\u00fcggv\u00e9nyekben a hivatkoz\u00e1si oper\u00e1torokat (kett\u0151spont, pontosvessz\u0151 \u00e9s metszet) haszn\u00e1ljuk a cell\u00e1kra \u00e9s\/vagy tartom\u00e1nyokra hivatkozva. <strong>Ha egy hivatkoz\u00e1st elg\u00e9pel\u00fcnk, vagy logikai hib\u00e1t v\u00e9t\u00fcnk, akkor jutalmunk a #NULLA! hiba\u00e9rt\u00e9k.<\/strong><\/p>\n<p>N\u00e9zz\u00fcnk a hiba\u00e9rt\u00e9kre egy logikai hib\u00e1t elk\u00f6vetve a metszet hivatkoz\u00e1si oper\u00e1tor haszn\u00e1lat\u00e1val <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA.jpg\" target=\"_blank\" rel=\"noopener\">(7. \u00e1bra)<\/a>! Ha a C1 cell\u00e1ba beg\u00e9pelj\u00fck az =A1:A5 B1:B5 k\u00e9pletet, akkor m\u00e1ris megkapjuk a #NULLA! hiba\u00e9rt\u00e9ket, mivel az A1:A5 \u00e9s a B1:B5 cell\u00e1knak nincs k\u00f6z\u00f6s r\u00e9sze, metszete. <strong>A #NULLA! hib\u00e1t nyilv\u00e1n a hivatkoz\u00e1sok \u00e1ttekint\u00e9s\u00e9vel jav\u00edthatjuk.<\/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-b3e9658 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b3e9658\" 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-06dfb8c\" data-id=\"06dfb8c\" 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-2293387 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"2293387\" 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\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-1024x576.jpg\" class=\"attachment-large size-large wp-image-29087\" alt=\"7. \u00e1bra: A C1 cell\u00e1ban megjelen\u0151 #NULLA! hiba\u00e9rt\u00e9k oka, hogy a k\u00e9pletben tal\u00e1lhat\u00f3 metszet hivatkoz\u00e1snak nincs k\u00f6z\u00f6s r\u00e9sze.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/169-K-Excel-hibaertekek_7_NULLA.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\">7. \u00e1bra: A C1 cell\u00e1ban megjelen\u0151 <strong>#NULLA! <\/strong>hiba\u00e9rt\u00e9k oka, hogy a k\u00e9pletben tal\u00e1lhat\u00f3 metszet hivatkoz\u00e1snak nincs k\u00f6z\u00f6s r\u00e9sze.<\/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-f30cc91 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f30cc91\" 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-176854f\" data-id=\"176854f\" 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-f2d5f7a elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f2d5f7a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;7. #SZ\\u00c1M! \\u2013 numerikus adatt\\u00edpus hi\\u00e1nya&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. #SZ\u00c1M! \u2013 numerikus adatt\u00edpus hi\u00e1nya<\/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-792fd90 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"792fd90\" 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-a9fc4b7\" data-id=\"a9fc4b7\" 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-c61b615 elementor-widget elementor-widget-text-editor\" data-id=\"c61b615\" 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 #SZ\u00c1M!<\/strong> <strong>hiba\u00e9rt\u00e9k legink\u00e1bb akkor jelenik meg a k\u00e9plet vagy f\u00fcggv\u00e9ny eredm\u00e9nye helyett, ha az el\u0151\u00edrttal ellent\u00e9tben nem numerikus adatot adtunk meg.<\/strong> Az Excel ugyanakkor sok esetben k\u00e9pes felismerni az elt\u00e9r\u0151 adatt\u00edpusb\u00f3l ered\u0151 hib\u00e1t \u00e9s javaslatot tenni a helyes \u00e9rt\u00e9kre. Egy \u00f6sszetett k\u00e9pletben azonban a program nem tud javaslatot adni a helyes form\u00e1ra, \u00edgy a hiba felder\u00edt\u00e9se \u00e9s jav\u00edt\u00e1sa neh\u00e9zkes lehet. \u00c9ppen ez\u00e9rt mindig az elv\u00e1rt adatt\u00edpust adjuk meg a k\u00e9pletekben \u00e9s f\u00fcggv\u00e9nyekben!<\/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-bb48bb2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb48bb2\" 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-518322e\" data-id=\"518322e\" 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-1bb07a0 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"1bb07a0\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8. #Z\\u00c9R\\u00d3OSZT\\u00d3! \\u2013 null\\u00e1val val\\u00f3 oszt\\u00e1s k\\u00eds\\u00e9rlete&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. #Z\u00c9R\u00d3OSZT\u00d3! \u2013 null\u00e1val val\u00f3 oszt\u00e1s k\u00eds\u00e9rlete<\/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-420e673 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"420e673\" 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-0b8ce21\" data-id=\"0b8ce21\" 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-1f98689 elementor-widget elementor-widget-text-editor\" data-id=\"1f98689\" 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 hiba oka egy\u00e9rtelm\u0171: m\u00e1r kisiskol\u00e1s korunkban megtanultuk, hogy null\u00e1val nem tudunk osztani, vagyis oszt\u00e1sn\u00e1l a nevez\u0151 nem lehet nulla, vagy nem hivatkozhatunk \u00fcres cell\u00e1ra.<\/strong> Ha m\u00e9gis \u00edgy tesz\u00fcnk, jutalmunk a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9k.<\/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-c64fabd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c64fabd\" 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-d6ac3c4\" data-id=\"d6ac3c4\" 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-0ac5246 elementor-widget elementor-widget-text-editor\" data-id=\"0ac5246\" 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>Tipp:<\/strong> Ha a nevez\u0151ben nem numerikus adatt\u00edpusra hivatkozunk, akkor a k\u00e9plet ki\u00e9rt\u00e9kelhetetlen lesz, \u00edgy a #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9ket kapjuk eredm\u00e9ny\u00fcl.<\/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-44b746b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44b746b\" 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-8f658f7\" data-id=\"8f658f7\" 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-197a7ac elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"197a7ac\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9. \\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\">9. \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-1318b91 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1318b91\" 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-29db094\" data-id=\"29db094\" 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-0d048ec elementor-widget elementor-widget-text-editor\" data-id=\"0d048ec\" 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>Ebben a cikkben megismerkedt\u00fcnk az Excel nyolc hiba\u00e9rt\u00e9k\u00e9vel, n\u00e9v szerint a #####, a #\u00c9RT\u00c9K!, a #HI\u00c1NYZIK, a #HIV!, a #N\u00c9V?, a #NULLA!, a #SZ\u00c1M! \u00e9s a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9kekkel. Egyesek jav\u00edt\u00e1sa mag\u00e1t\u00f3l \u00e9rtet\u0151d\u0151, m\u00e1sok felder\u00edt\u00e9se sok fejt\u00f6r\u00e9st okozhat. A hiba oka sokszor a helytelen adatr\u00f6gz\u00edt\u00e9s, hivatkoz\u00e1s vagy oper\u00e1tor haszn\u00e1lat, a nem l\u00e9tez\u0151 adat, \u00e9s az elt\u00e9r\u0151, nem megengedett adatt\u00edpusok haszn\u00e1lata.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>A cikk legfontosabb tan\u00e1csa, hogy hi\u00e1nyz\u00f3 adatainkat ne t\u00f6ltel\u00e9k karakterekkel, sz\u00e1mokkal, hanem a #HI\u00c1NYZIK hiba\u00e9rt\u00e9kkel vagy a HI\u00c1NYZIK f\u00fcggv\u00e9nnyel jelezz\u00fck.<\/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-80d8482 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"80d8482\" 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-0736daf\" data-id=\"0736daf\" 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-773fb04 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"773fb04\" 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-f1ef76e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1ef76e\" 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-2f1ba90\" data-id=\"2f1ba90\" 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-029b88b elementor-widget elementor-widget-text-editor\" data-id=\"029b88b\" 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: 2020 febru\u00e1r 1.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H2, 2111b19044)<br \/>Irodai programcsomag: Microsoft 365 v2207b15427.20210, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/4.1.3<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek \u2192 Aritmetikai k\u00e9pletek<\/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-24854c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"24854c1\" 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-c43b31a\" data-id=\"c43b31a\" 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-ed11710 elementor-widget elementor-widget-shortcode\" data-id=\"ed11710\" 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--1888 \"        data-post-id=\"1888\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-1888\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-1888\">                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-0096450 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0096450\" 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-8e24918\" data-id=\"8e24918\" 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-0dffbac 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=\"0dffbac\" 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: 2022 augusztus 26. Mir\u0151l sz\u00f3l ez a cikk?A k\u00e9pletekkel dolgozva \u00f3hatatlanul k\u00f6vet\u00fcnk el hib\u00e1kat, amelyeket az Excelnek valahogy jeleznie kell sz\u00e1munkra. Erre k\u00e9t m\u00f3dszer is l\u00e9tezik: az egyik egy hibajelz\u00e9s a cella bal fels\u0151 sark\u00e1ban, a m\u00e1sik egy sz\u00f6veges hiba\u00e9rt\u00e9k megjelen\u00edt\u00e9se a cell\u00e1ban.Ebben a cikkben a hiba\u00e9rt\u00e9keket foglaljuk \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":29091,"parent":962,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-1888","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/1888","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=1888"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/1888\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/962"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/media\/29091"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}