{"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\/if-funkcija-u-excelu\/","title":{"rendered":"[:sr]IF funkcija u Excelu[:en]Learn the IF Function in Excel: Step by Step Guide[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">[:sr]Sadr\u017eaj[:en] 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\/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\/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\/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\/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\/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\/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\/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[:sr]IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu vrednost. <a href=\"https:\/\/kalkulacija.com\/wordpress\/excel-funkcija-datedif\/\">IF funkcija<\/a> postoji od po\u010detka u Excel-u, ali je mali broj savlada i koristi u radu.<\/p>\n<figure id=\"attachment_3110\" aria-describedby=\"caption-attachment-3110\" style=\"width: 320px\" class=\"wp-caption alignnone\"><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\" alt=\"IF Funkcija u excelu 01\" width=\"320\" height=\"154\" 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\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><figcaption id=\"caption-attachment-3110\" class=\"wp-caption-text\">Upore\u0111ivanje<\/figcaption><\/figure>\n<p>Sintaksa funkcije izgleda ovako:<\/p>\n<p><strong>=IF (Logi\u010dki_test, Vrednost_ako_je_ta\u010dno, Vrednost_ako_je_neta\u010dno)<\/strong><\/p>\n<p>Vidimo na primeru, kako \u017eelimo da odlu\u010dimo ko je pro\u0161ao test ako ima vi\u0161e ili ta\u010dno 50 poena.<\/p>\n<figure id=\"attachment_3112\" aria-describedby=\"caption-attachment-3112\" style=\"width: 429px\" class=\"wp-caption alignnone\"><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\" alt=\"IF Funkcija u excelu\" width=\"429\" height=\"147\" 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\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><figcaption id=\"caption-attachment-3112\" class=\"wp-caption-text\">Definisanje IF funkcije<\/figcaption><\/figure>\n<figure id=\"attachment_3113\" aria-describedby=\"caption-attachment-3113\" style=\"width: 282px\" class=\"wp-caption alignnone\"><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 Funkcija u excelu\" width=\"282\" height=\"95\" \/><figcaption id=\"caption-attachment-3113\" class=\"wp-caption-text\">IF Funkcija za upore\u0111ivanje<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Primena_IF_Funkcije\"><\/span>Primena IF Funkcije<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sli\u010dan primer, ra\u010dunamo porez koji treba da se plati a on zavisi od visine plate. Ako je plata manja od 50 hiljada onda je porez 10%, u suprotnom je 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\" alt=\"IF Funkcija u excelu\" width=\"497\" height=\"380\" 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\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Kombinacija_IF_sa_AND_i_OR_operatorima\"><\/span>Kombinacija IF sa AND i OR operatorima<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Logi\u010dki test mo\u017eemo da pro\u0161irimo iz pomo\u0107u operatora AND i OR.<\/p>\n<p>AND ozna\u010dava da oba navedena uslova moraju biti ispunjena, a OR da bilo koji od dva navedena uslova mora biti ispunjen.<\/p>\n<p>Pogledajte primer sa AND operatorom gde je prvi argument IF funkcije logi\u010dki test sa AND operatorom. Dva uslova moraju biti ispunjena za bonus, da je zaposleni u firmi du\u017ee od dve godine i da je ima platu ve\u0107u od 50 hiljada.<\/p>\n<figure id=\"attachment_3115\" aria-describedby=\"caption-attachment-3115\" style=\"width: 594px\" class=\"wp-caption alignnone\"><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\" alt=\"IF Funkcija u excelu\" width=\"594\" height=\"328\" 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\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><figcaption id=\"caption-attachment-3115\" class=\"wp-caption-text\">IF Funkcija u excelu<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ugnjezdene_IF_funkcije\"><\/span>Ugnje\u017edene IF funkcije<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Unutar svake Excel funkcije mo\u017eemo da koristimo drugu funkciju. To je takozvano ugnje\u017edavanje. Sa IF izjavom se naj\u010de\u0161\u0107e koristi kada imamo nekoliko kategorija, tako tre\u0107i argument funkcije, vrednost_ako_je_neta\u010dno postaje nova IF funkcija i sve tako. Pogledajte kako to izgleda na primeru.[:en]<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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]IF funkcija u Excelu[:en]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>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]IF funkcija u excelu omogu\u0107ava proveru ispunjenosti logi\u010dkog uslova, i ako je istinit vra\u0107a jednu vrednost, a ako nije drugu<\/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 v28.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=\"Kalkulacija u osnovi svega!\" \/>\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\":\"[:sr]IF funkcija u Excelu[:en]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\":[\"Napredni Excel\",\"Poslovni Excel\",\"Saveti za napredni 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\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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":"Kalkulacija u osnovi svega!","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":"[:sr]IF funkcija u Excelu[:en]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":["Napredni Excel","Poslovni Excel","Saveti za napredni 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":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=894"}],"version-history":[{"count":6,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":3705,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/894\/revisions\/3705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3113"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}