{"id":16,"date":"2015-01-05T22:44:04","date_gmt":"2015-01-05T21:44:04","guid":{"rendered":"http:\/\/www.zeljko.in.rs\/?p=16"},"modified":"2015-06-10T08:31:04","modified_gmt":"2015-06-10T07:31:04","slug":"provera-greske-u-rezltatu-formule","status":"publish","type":"post","link":"https:\/\/www.zeljko.in.rs\/?p=16","title":{"rendered":"Provera gre\u0161ke u rezultatu formule Excel 2010 i noviji"},"content":{"rendered":"<p><b class=\"ocpLegacyBold\">Syntax<\/b><\/p>\n<p><b class=\"ocpLegacyBold\">IFERROR<\/b>(<b class=\"ocpLegacyBold\">value<\/b>,<b class=\"ocpLegacyBold\">value_if_error<\/b>)<\/p>\n<p><b class=\"ocpRunInHead\">Value<\/b>\u00a0\u00a0\u00a0\u00a0 is the argument that is checked for an error.<\/p>\n<p><b class=\"ocpRunInHead\">Value_if_error<\/b>\u00a0\u00a0\u00a0\u00a0 is the value to return if the formula evaluates to an error. The following error types are evaluated: #N\/A, #VALUE!, #REF!, #DIV\/0!, #NUM!, #NAME?, or #NULL!.<\/p>\n<p><b class=\"ocpLegacyBold\">Remarks<\/b><\/p>\n<ul>\n<li>If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (&#8220;&#8221;).<\/li>\n<li>If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.<\/li>\n<\/ul>\n<h2><\/h2>\n<h2>Syntax<\/h2>\n<p>ERROR.TYPE(error_val)<\/p>\n<p>The ERROR.TYPE function syntax has the following arguments:<\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">Error_val<\/b>\u00a0\u00a0\u00a0\u00a0Required. The error value whose identifying number you want to find. Although error_val can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.<\/li>\n<\/ul>\n<table id=\"tblID0EABCAAA\" class=\"banded\">\n<thead>\n<tr>\n<td><b class=\"ocpLegacyBold\">If error_val is<\/b><\/td>\n<td><b class=\"ocpLegacyBold\">ERROR.TYPE returns<\/b><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>#NULL!<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>#DIV\/0!<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td>#VALUE!<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td>#REF!<\/td>\n<td>4<\/td>\n<\/tr>\n<tr>\n<td>#NAME?<\/td>\n<td>5<\/td>\n<\/tr>\n<tr>\n<td>#NUM!<\/td>\n<td>6<\/td>\n<\/tr>\n<tr>\n<td>#N\/A<\/td>\n<td>7<\/td>\n<\/tr>\n<tr>\n<td>#GETTING_DATA<\/td>\n<td>8<\/td>\n<\/tr>\n<tr>\n<td>Anything else<\/td>\n<td>#N\/A<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Syntax IFERROR(value,value_if_error) Value\u00a0\u00a0\u00a0\u00a0 is the argument that is checked for an error. Value_if_error\u00a0\u00a0\u00a0\u00a0 is the value to return if the formula evaluates to an error. The following error types are evaluated: #N\/A, #VALUE!, #REF!, #DIV\/0!, #NUM!, #NAME?, or #NULL!. Remarks If value or value_if_error is an empty cell, IFERROR treats it as an empty string [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-excel","category-microsoft"],"_links":{"self":[{"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16"}],"version-history":[{"count":4,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/posts\/16\/revisions"}],"predecessor-version":[{"id":20,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=\/wp\/v2\/posts\/16\/revisions\/20"}],"wp:attachment":[{"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeljko.in.rs\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}