{"id":459,"date":"2019-08-07T17:00:00","date_gmt":"2019-08-07T17:00:00","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=459"},"modified":"2020-01-20T07:04:15","modified_gmt":"2020-01-20T07:04:15","slug":"exemplu-de-utilizare-a-functiei-if","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/","title":{"rendered":"Exemplu de utilizare a functiei IF in Excel"},"content":{"rendered":"<p style=\"text-align: justify;\">Puteti recapitula cele invatate, utilizand fisierul de lucru atasat:\u00a0<div class='afi-document'><div class='afi-document-icon'><a href='http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Fisier-de-lucru_Functia-IF.xlsx'><img src='http:\/\/eticsolutions.ro\/blog\/wp-content\/plugins\/attachment-file-icons\/mime\/xls-icon.png'\/><\/a><\/div><div class='afi-document-link'><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Fisier-de-lucru_Functia-IF.xlsx\">Fisier de lucru_Functia IF<\/a><\/div><\/div><div class='afi-clear'><\/div><\/p>\n<p style=\"text-align: justify;\">__________________________________________________________________<\/p>\n<p style=\"text-align: justify;\">Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel):<\/p>\n<p style=\"text-align: justify;\"><strong>=IF(logical_test, [value_if_true],[value_if_false])<\/strong><\/p>\n<p style=\"text-align: justify;\">Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza).<\/p>\n<p style=\"text-align: justify;\">Functia IF are trei argumente, doar primul fiind obligatoriu (logical_test).<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>logical_test<\/strong><\/span> = o conditie logica ce trebuie indeplinita pentru a intoarce value_if_true<\/p>\n<p style=\"text-align: justify;\">Poate fi rezultatul unei functii, referinta la o celula sau chiar o constanta.<\/p>\n<p style=\"text-align: justify;\">Testul logic poate fi de forma:<\/p>\n<ul style=\"text-align: justify;\">\n<li>ceva egal cu altceva sau ceva mai mare cu altceva, etc.<\/li>\n<li>rezultat al unei functii de tip logic (ce intoarce TRUE sau FALSE)<\/li>\n<li>rezultatul unei functii (de exemplu, functia FIND, IF(FIND()\u2026.))<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">In cazul in care testul logic este rezultatul unei functii, nu este nevoie de utilizarea testului logic cu comparatie.<\/p>\n<p style=\"text-align: justify;\"><strong>Semne de comparatie<\/strong>: = , &lt;&gt;, &gt;=, &lt;=, \u00a0&gt;,\u00a0&lt;<\/p>\n<p style=\"text-align: justify;\"><strong>ATENTIE!<\/strong> Daca rezultatul testului logic este o eroare, atunci functia IF se opreste si rezultatul acesteia va fi eroare.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>value_if_true<\/strong><\/span> = actiunea ce trebuie realizata daca rezultatul testului logic este TRUE.<\/p>\n<p style=\"text-align: justify;\">Este un argument optional, in cazul in care este omis si testul logic este indeplinit, rezultatul functiei IF va fi TRUE.<\/p>\n<p style=\"text-align: justify;\">Poate fi o constanta numerica, un text (caz in care textul trebuie obligatoriu inclus intre ghilimele duble) sau o alta functie, inclusiv o noua functie de tip IF).<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>value_if_false<\/strong><\/span> = actiunea ce trebuie realizata daca rezultatul testului logic este FALSE.<\/p>\n<p style=\"text-align: justify;\">Este un argument optional, in cazul in care este omis si testul logic nu este indeplinit, rezultatul functiei IF va fi FALSE.<\/p>\n<p style=\"text-align: justify;\">Poate fi o constanta numerica, un text (caz in care textul trebuie obligatoriu inclus intre ghilimele duble) sau o alta functie).<\/p>\n<p style=\"text-align: justify;\"><strong>Exemple<\/strong>:<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>=IF(TYPE(A1)=1,)<\/strong><\/span> va intoarce rezultatul TRUE daca in celula A1 este inscrisa o valoare numerica si FALSE in orice alt caz.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>=IF(LEFT(a1,2)= \u201dBu\u201d, \u201dContract din Bucuresti\u201d,\u201d\u201d)<\/strong><\/span> va intoarce rezultatul \u201cContract din Bucuresti\u201d daca primele doua litere din celula A1 sunt \u201cBu\u201d si va intoarce blank (in celula respectiva nu va aparea nimic) in orice alt caz.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>=IF(LEFT(A1,2)= \u201dBu\u201d, \u201dContract din Bucuresti\u201d,)<\/strong><\/span> va intoarce rezultatul \u201cContract din Bucuresti\u201d daca primele doua litere din celula A1 sunt \u201cBu\u201d si va intoarce FALSE (in celula respectiva va aparea textul FALSE) in orice alt caz.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>=IF(LEFT(A1,2)= \u201dBu\u201d, \u201dContract din Bucuresti\u201d,IF(LEFT(A1,2)=\u201dBr\u201d,\u201dContract din Brasov\u201d,\u201dAlte contracte\u201d))<\/strong><\/span> va intoarce rezultatul \u201cContract din Bucuresti\u201d daca primele doua litere din celula A1 sunt \u201cBu\u201d, daca nu,\u00a0 in cazul in care primele doua litere din A1 sunt \u00a0\u201dBr\u201d va intoarce \u201cContract din Brasov\u201d si daca nu, va intoarce valoarea \u201cAlte contracte\u201d.<\/p>\n<p style=\"text-align: justify;\"><strong>Atentie! <\/strong>Chiar daca argumentele <strong>value_if_true<\/strong> si <strong>value_if_false<\/strong> sunt optionale, dupa argumentul logical_test trebuie sa introduceti si separatorul de argumente (virgula &#8211; pentru varianta in limba engleza, respectiv punct si virgula pentru varianta in limba romana\/franceza), dupa care inchideti paranteza.<\/p>\n<p style=\"text-align: justify;\">In cazul in care introduceti o actiune doar pentru <strong>value_if_true<\/strong>, de exemplu, in cazul in care conditia logica definita la <strong>logical_test <\/strong>nu este indeplinita, rezultatul functiei va fi <strong>FALSE<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Pentru a realiza o actiune si in cazul in care conditia nu este indeplinita, introduceti si value_if_false.<\/p>\n<h3 style=\"text-align: justify;\"><strong>EXEMPLU<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se da o baza de date de contracte, pentru care trebuie completata coloana Departament, stiind ca numarul contractului (coloana A) contine indicativul de departament, astfel:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Ou = Outsourcing<\/li>\n<li>Co = Consultanta<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Exemplu\u00a0: Bu_Co_2009_1 semnifica un contract incheiat in subsidiara Bucuresti si de catre departamentul Consultanta<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Functia_IF.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-466\" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Functia_IF-300x119.jpg\" alt=\"Functia_IF\" width=\"300\" height=\"119\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Functia_IF-300x119.jpg 300w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Functia_IF.jpg 964w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>REZOLVARE<\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 1<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">Extragem grupul de caractere ce semnifica indicativul de departament din numarul contractului, utilizand functia MID<\/p>\n<p style=\"text-align: justify;\"><strong>=MID(A5,4,2)<\/strong> &#8211; extrage din celula A5, un numar de 2 caractere, incepand cu al patrulea caracter<\/p>\n<p style=\"text-align: justify;\">Vom utiliza un <a title=\"nume definit de utilizator\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/crearea-de-nume-definite-de-utilizator\/\"><strong>nume definit de utilizator<\/strong><\/a>, pentru a realiza o formula mai eleganta si mai lizibila.<\/p>\n<p style=\"text-align: justify;\">Am dat denumirea<strong> indicativ_dep<\/strong> functiei MID(A5,4,2).<\/p>\n<p style=\"text-align: justify;\">Acest nume definit de utilizator va fi parte din testul logic (logical_test) al functiei IF.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 2<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">In celula I5 (prima celula din coloana Departament a bazei de date), inscriem functia:<\/p>\n<p style=\"text-align: justify;\"><strong>=IF(indicativ_dep=\u201dCo\u201d,\u201dConsultanta\u201d,\u201dOutsourcing\u201d)<\/strong><\/p>\n<p style=\"text-align: justify;\">Daca grupul de caractere extras din A5 (cu functia MID definita ca nume definit de utilizator indicativ_dep) este <strong>Co<\/strong>, atunci inseamna ca departamentul este Consultanta, daca nu, inseamna ca este Outsourcing.<\/p>\n<p style=\"text-align: justify;\">Daca nu am fi definit anterior numele indicativ_dep, functia ar fi aratat astfel:<\/p>\n<p style=\"text-align: justify;\"><strong>=IF(MID(A5,4,2)=\u201dCo\u201d,\u201dConsultanta\u201d,\u201dOutsourcing\u201d)<\/strong><\/p>\n<p style=\"text-align: justify;\">Rezultatul functiei este corect doar in cazul in care, intr-adevar (ca in exemplul nostru), era vorba doar de doua departamente.<\/p>\n<p style=\"text-align: justify;\">Pentru mai multe departamente, o varianta eleganta si simpla este utilizarea functiei VLOOKUP (Vezi <strong><a title=\"aici\" href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/\" target=\"_blank\" rel=\"noopener noreferrer\">aici<\/a><\/strong> un exemplu de utilizare a functiei VLOOKUP).<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 3<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">Copiati formula pana la capatul tabelului.<\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 4<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">In cazul in care informatiile din tabel sunt statice (nu veti mai realiza modificari in coloana A), puteti copia coloana Departament peste ea insasi, utilizand Copy \u00e0 Paste Special pentru a nu pastra decat rezultatul functiei IF utilizate.<\/p>\n<p style=\"text-align: justify;\"><strong><em>Va invit sa refaceti exercitiul, utilizand fisierul de lucru atasat la inceputul articolului. Spor la treaba!<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.cursuri-excel.eticsolutions.ro\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-406 \" src=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/fagureblog1.png\" alt=\"prezentare_firma\" width=\"714\" height=\"213\" srcset=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/fagureblog1.png 899w, https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/fagureblog1-300x89.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Puteti recapitula cele invatate, utilizand fisierul de lucru atasat:\u00a0Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[16],"tags":[90,976,102,64],"class_list":["post-459","post","type-post","status-publish","format-standard","hentry","category-cursuri-excel-gratuite","tag-cursuri-excel-gratuite","tag-cursuri-excel-online-gratuite","tag-functia-if","tag-training-2"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"-\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Exemplu de utilizare a functiei IF in Excel -\" \/>\n\t\t<meta property=\"og:description\" content=\"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-08-07T17:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T07:04:15+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Exemplu de utilizare a functiei IF in Excel -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#blogposting\",\"name\":\"Exemplu de utilizare a functiei IF in Excel -\",\"headline\":\"Exemplu de utilizare a functiei IF in Excel\",\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/08\\\/Functia_IF.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#articleImage\",\"width\":964,\"height\":381},\"datePublished\":\"2019-08-07T17:00:00+00:00\",\"dateModified\":\"2020-01-20T07:04:15+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#webpage\"},\"articleSection\":\"Cursuri Excel gratuite, cursuri excel gratuite, cursuri excel online gratuite, functia IF, training\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"position\":2,\"name\":\"Cursuri Excel\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"position\":3,\"name\":\"Cursuri Excel gratuite\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#listItem\",\"name\":\"Exemplu de utilizare a functiei IF in Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#listItem\",\"position\":4,\"name\":\"Exemplu de utilizare a functiei IF in Excel\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/\",\"name\":\"Exemplu de utilizare a functiei IF in Excel -\",\"description\":\"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\\\/franceza). Functia IF are trei argumente, doar primul\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-if\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"datePublished\":\"2019-08-07T17:00:00+00:00\",\"dateModified\":\"2020-01-20T07:04:15+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Exemplu de utilizare a functiei IF in Excel -","description":"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#blogposting","name":"Exemplu de utilizare a functiei IF in Excel -","headline":"Exemplu de utilizare a functiei IF in Excel","author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/08\/Functia_IF.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#articleImage","width":964,"height":381},"datePublished":"2019-08-07T17:00:00+00:00","dateModified":"2020-01-20T07:04:15+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#webpage"},"articleSection":"Cursuri Excel gratuite, cursuri excel gratuite, cursuri excel online gratuite, functia IF, training"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","position":1,"name":"Home","item":"https:\/\/eticsolutions.ro\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","position":2,"name":"Cursuri Excel","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","position":3,"name":"Cursuri Excel gratuite","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#listItem","name":"Exemplu de utilizare a functiei IF in Excel"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#listItem","position":4,"name":"Exemplu de utilizare a functiei IF in Excel","previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"}}]},{"@type":"Organization","@id":"https:\/\/eticsolutions.ro\/blog\/#organization","url":"https:\/\/eticsolutions.ro\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author","url":"https:\/\/eticsolutions.ro\/blog\/author\/"},{"@type":"WebPage","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/","name":"Exemplu de utilizare a functiei IF in Excel -","description":"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/#breadcrumblist"},"author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"creator":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"datePublished":"2019-08-07T17:00:00+00:00","dateModified":"2020-01-20T07:04:15+00:00"},{"@type":"WebSite","@id":"https:\/\/eticsolutions.ro\/blog\/#website","url":"https:\/\/eticsolutions.ro\/blog\/","inLanguage":"en-US","publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"-","og:type":"article","og:title":"Exemplu de utilizare a functiei IF in Excel -","og:description":"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/","og:image":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","og:image:secure_url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","article:published_time":"2019-08-07T17:00:00+00:00","article:modified_time":"2020-01-20T07:04:15+00:00","twitter:card":"summary_large_image","twitter:title":"Exemplu de utilizare a functiei IF in Excel -","twitter:description":"Puteti recapitula cele invatate, utilizand fisierul de lucru atasat: Fisier de lucru_Functia IF __________________________________________________________________ Functia IF este o functie de tip logic, cu urmatoarea sintaxa (pentru toate versiunile de Excel): =IF(logical_test, [value_if_true],[value_if_false]) Separatorul de argumente este virgula (versiunea in limba engleza), respectiv punct si virgula (versiunea in limba romana\/franceza). Functia IF are trei argumente, doar primul","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"459","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-29 09:51:21","updated":"2026-06-29 09:51:21"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/\" title=\"Cursuri Excel\">Cursuri Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/\" title=\"Cursuri Excel gratuite\">Cursuri Excel gratuite<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tExemplu de utilizare a functiei IF in Excel\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/eticsolutions.ro\/blog"},{"label":"Cursuri Excel","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/"},{"label":"Cursuri Excel gratuite","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/"},{"label":"Exemplu de utilizare a functiei IF in Excel","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-if\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/comments?post=459"}],"version-history":[{"count":12,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions"}],"predecessor-version":[{"id":3356,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions\/3356"}],"wp:attachment":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media?parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}