{"id":894,"date":"2017-09-20T22:10:59","date_gmt":"2017-09-20T20:10:59","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=894"},"modified":"2023-01-08T14:39:45","modified_gmt":"2023-01-08T13:39:45","slug":"if-funkcija-u-excelu","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/","title":{"rendered":"Learn the IF Function in Excel: Step by Step Guide"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Primena_IF_Funkcije\" >Primena IF Funkcije<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Kombinacija_IF_sa_AND_i_OR_operatorima\" >Kombinacija IF sa AND i OR operatorima<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Ugnjezdene_IF_funkcije\" >Ugnje\u017edene IF funkcije<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Application_of_the_IF_Function\" >Application of the IF Function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Combination_of_IF_with_AND_and_OR_operators\" >Combination of IF with AND and OR operators<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Nested_IF_functions\" >Nested IF functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/if-funkcija-u-excelu\/#Learn_the_IF_Function_in_Excel_Step_by_Step_Guide\" >Learn the IF Function in Excel: Step by Step Guide<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<span class=\"\">The IF function in excel allows checking the fulfillment of a logical condition, and if it is true, it returns one value, and if it is not, it returns another value.\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/excel-funkcija-datedif\/\">The IF function<\/a>\u00a0has existed since the beginning in Excel, but few have mastered it and used it in their work.<\/p>\n<figure id=\"attachment_3110\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3110\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3110\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_01.png\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_01.png 320w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_01-300x144.png 300w\" alt=\"IF Function in excel 01\" width=\"320\" height=\"154\" \/><figcaption id=\"caption-attachment-3110\" class=\"wp-caption-text\">Comparison<\/figcaption><\/figure>\n<p>The function syntax looks like this:<\/p>\n<p><strong>=IF (Boolean_test, Value_if_true, Value_if_false)<\/strong><\/p>\n<p>Let&#8217;s see with an example, how we want to decide who passed the test if they have more or exactly 50 points.<\/p>\n<figure id=\"attachment_3112\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3112\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3112\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_03.png\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_03.png 429w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_03-300x103.png 300w\" alt=\"IF Function in excel\" width=\"429\" height=\"147\" \/><figcaption id=\"caption-attachment-3112\" class=\"wp-caption-text\">Defining the IF function<\/figcaption><\/figure>\n<figure id=\"attachment_3113\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3113\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3113\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png\" alt=\"IF Function in excel\" width=\"282\" height=\"95\" \/><figcaption id=\"caption-attachment-3113\" class=\"wp-caption-text\">IF Comparison function<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Application_of_the_IF_Function\"><\/span><span id=\"Primena_IF_Funkcije\" class=\"ez-toc-section\"><\/span>Application of the IF Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A similar example, we calculate the tax that needs to be paid, and it depends on the amount of salary.\u00a0If the salary is less than 50 thousand then the tax is 10%, otherwise it is 50%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3114\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_05.png\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_05.png 497w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_05-300x229.png 300w\" alt=\"IF Function in excel\" width=\"497\" height=\"380\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Combination_of_IF_with_AND_and_OR_operators\"><\/span><span id=\"Kombinacija_IF_sa_AND_i_OR_operatorima\" class=\"ez-toc-section\"><\/span>Combination of IF with AND and OR operators<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We can extend the logical test from using AND and OR operators.<\/p>\n<p>AND indicates that both conditions must be met, and OR indicates that either of the two conditions must be met.<\/p>\n<p>See the example with the AND operator where the first argument of the IF function is a logical test with the AND operator.\u00a0Two conditions must be met for the bonus, that the employee has been in the company for more than two years and that he has a salary of more than 50,000.<\/p>\n<figure id=\"attachment_3115\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3115\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3115\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_06.png\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_06.png 594w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_06-300x166.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_06-360x200.png 360w\" alt=\"IF Function in excel\" width=\"594\" height=\"328\" \/><figcaption id=\"caption-attachment-3115\" class=\"wp-caption-text\">IF Function in excel<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Nested_IF_functions\"><\/span><span id=\"Ugnjezdene_IF_funkcije\" class=\"ez-toc-section\"><\/span>Nested IF functions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Within each Excel function we can use another function.\u00a0This is called nesting.\u00a0With the IF statement, it is most often used when we have several categories, so the third argument of the function, the value_if_is_false becomes a new IF function and so on.\u00a0See how it looks on an example.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Learn_the_IF_Function_in_Excel_Step_by_Step_Guide\"><\/span>Learn the IF Function in Excel: Step by Step Guide<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Learn how to use the IF function in Excel and become a spreadsheet whiz! Get a step-by-step guide outlining all the important details.<\/p>\n<p>The IF function in Excel is one of the most powerful and versatile tools available for analyzing and manipulating data. With it, you can analyze complex conditions and create sophisticated calculations with just a few simple steps. This guide covers everything you need to know about how to use the IF function in Excel.<\/p>\n<p>Nesting Multiple IF statements.<br \/>\nNesting multiple IF statements is a great way to analyze data when there is more than one condition to evaluate. With this technique, you can combine several IF functions together in the same formula. This allows you to evaluate multiple criteria and produce a result based on each condition. For example, you may want your formula to return one result if an employee\u2019s age is between 25 and 34, another result if the employee\u2019s age is between 35 and 44, and yet another result if the employee\u2019s age is 45 or higher.<\/p>\n<p>Formulating Logical Test Arguments with AND, OR functions and more complex arguments for more accurate results.<br \/>\nTo create more complex arguments, you can use additional logical functions such as AND and OR. With these functions you can combine two or more conditions to generate different results. For example, you might use the AND function to test if an employee is between 25 and 34 AND has at least one year of experience working with Excel. The OR function allows you to evaluate two separate criteria and return a result based on either scenario. For instance, you may want the formula to return one result if the employee\u2019s age is between 25 and 44 OR they have been at their current position for at least one year.<\/p>\n<p>Utilizing other helpful functions like the VLOOKUP and HLOOKUP to analyze data quickly and accurately when combined with the IF statement.<br \/>\nUnderstanding how to combine the IF statement with other functions like VLOOKUP and HLOOKUP can save you a lot of time when analyzing data. Using VLOOKUP, you can return information from a separate table based on the value of a certain cell. This is useful for quickly bringing in large amounts of info without having to manually search through your data set. Similarly, with HLOOKUP you can search for values from left to right instead of down. Both these functions work well with an IF statement as you can use them to accurately return specific pieces of data from your sheet.<\/p>\n<p>&nbsp;\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;894&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Learn the IF Function in Excel: Step by Step Guide&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>The IF function in excel allows checking the fulfillment of a logical condition, and if it is true, it returns<\/p>\n","protected":false},"author":1,"featured_media":3113,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,19,49],"tags":[],"class_list":["post-894","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-napredni-excel","category-ekscel","category-saveti-napredni-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>IF funkcija u Excelu<\/title>\n<meta name=\"description\" content=\"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IF funkcija u Excelu\" \/>\n<meta property=\"og:description\" content=\"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-20T20:10:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-08T13:39:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png\" \/>\n\t<meta property=\"og:image:width\" content=\"282\" \/>\n\t<meta property=\"og:image:height\" content=\"95\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Learn the IF Function in Excel: Step by Step Guide\",\"datePublished\":\"2017-09-20T20:10:59+00:00\",\"dateModified\":\"2023-01-08T13:39:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/\"},\"wordCount\":1030,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/IF_funkcija_04.png\",\"articleSection\":[\"Advanced Excel\",\"Excel\",\"Tips for excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/\",\"name\":\"IF funkcija u Excelu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/IF_funkcija_04.png\",\"datePublished\":\"2017-09-20T20:10:59+00:00\",\"dateModified\":\"2023-01-08T13:39:45+00:00\",\"description\":\"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/IF_funkcija_04.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/IF_funkcija_04.png\",\"width\":282,\"height\":95,\"caption\":\"IF Funkcija u excelu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/if-funkcija-u-excelu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IF funkcija u Excelu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IF funkcija u Excelu","description":"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/","og_locale":"en_US","og_type":"article","og_title":"IF funkcija u Excelu","og_description":"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.","og_url":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2017-09-20T20:10:59+00:00","article_modified_time":"2023-01-08T13:39:45+00:00","og_image":[{"width":282,"height":95,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Learn the IF Function in Excel: Step by Step Guide","datePublished":"2017-09-20T20:10:59+00:00","dateModified":"2023-01-08T13:39:45+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/"},"wordCount":1030,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png","articleSection":["Advanced Excel","Excel","Tips for excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/","url":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/","name":"IF funkcija u Excelu","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png","datePublished":"2017-09-20T20:10:59+00:00","dateModified":"2023-01-08T13:39:45+00:00","description":"IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/IF_funkcija_04.png","width":282,"height":95,"caption":"IF Funkcija u excelu"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/if-funkcija-u-excelu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"IF funkcija u Excelu"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=894"}],"version-history":[{"count":6,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":3705,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/894\/revisions\/3705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/3113"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}