{"id":20569,"date":"2026-02-19T16:53:17","date_gmt":"2026-02-19T16:53:17","guid":{"rendered":"https:\/\/undetectable.ai/blog\/?p=20569"},"modified":"2026-03-04T19:23:59","modified_gmt":"2026-03-04T19:23:59","slug":"formule-de-foaie-de-calcul","status":"publish","type":"post","link":"https:\/\/undetectable.ai/blog\/ro\/formule-de-foaie-de-calcul\/","title":{"rendered":"Formule Excel \u0219i Google Spreadsheet pe care nu v\u0103 pute\u021bi permite s\u0103 le ignora\u021bi"},"content":{"rendered":"<p>Dac\u0103 utiliza\u021bi Excel\/Google Sheets ca parte a activit\u0103\u021bii dumneavoastr\u0103 zilnice, exist\u0103 c\u00e2teva formule foarte utile la care ve\u021bi reveni dac\u0103 le \u00eenv\u0103\u021ba\u021bi o dat\u0103.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Exist\u0103, probabil, peste o sut\u0103 de formule diferite pentru foi de calcul care func\u021bioneaz\u0103 pentru diferite tipuri de calcule.<\/p>\n\n\n\n<p>Scopul meu \u00een acest blog este s\u0103 vorbesc despre cele mai simple dintre toate, cele care stau la baza tuturor calculelor avansate pe care le ve\u021bi \u00eenv\u0103\u021ba mai t\u00e2rziu.&nbsp;<\/p>\n\n\n\n<p>Vom trece mai \u00eent\u00e2i \u00een revist\u0103 c\u00e2teva comenzi de calcul aritmetic de baz\u0103, apoi v\u0103 voi prezenta c\u00e2teva modalit\u0103\u021bi prin care pute\u021bi face analize mai avansate.<\/p>\n\n\n\n<p>Acestea includ instruc\u021biuni IF, comenzi VLOOKUP, INDEX \u0219i MATCH etc.&nbsp;<\/p>\n\n\n\n<p>\u0218i este mai simplu dec\u00e2t crede\u021bi!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-text-align-center\"><strong>Principalele concluzii<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel \u0219i Google Sheets au multe comenzi de formul\u0103 \u00eencorporate care sunt utile pentru efectuarea calculelor.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUM, AVERAGE, COUNT, VLOOKUP, INDEX \u0219i MATCH sunt c\u00e2teva formule care v\u0103 pot ajuta cu calculele de zi cu zi. De asemenea, v\u0103 pute\u021bi juca cu ele prin introducerea logicii condi\u021bionale.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nu trebuie s\u0103 existe erori \u00een scrierea unei formule, \u00een caz contrar, nu ve\u021bi ob\u021bine rezultatele. \u00cen special, asigura\u021bi-v\u0103 c\u0103 evita\u021bi referin\u021bele circulare \u0219i \u00eempiedica\u021bi Excel s\u0103 intre \u00eentr-o bucl\u0103 de calcul infinit\u0103.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Ce este exact formula foii de calcul<\/h2>\n\n\n\n<p>Comenzile prin care pute\u021bi efectua calcule ale datelor dvs. sunt cunoscute sub numele de formule de foaie de calcul.<\/p>\n\n\n\n<p>At\u00e2t Microsoft Excel, c\u00e2t \u0219i Google Docs sunt \u00eenc\u0103rcate cu astfel de comenzi, acesta fiind par\u021bial motivul pentru care sunt instrumentele de baz\u0103 la orice loc de munc\u0103.&nbsp;<\/p>\n\n\n\n<p>Un semn (=) precede orice formul\u0103 scris\u0103 \u00een Excel. Este o indica\u021bie pentru Excel de a trata textul care urmeaz\u0103 ca o formul\u0103 pentru a efectua calculul necesar, mai degrab\u0103 dec\u00e2t o intrare de text simplu.<\/p>\n\n\n\n<p>\u00cen afar\u0103 de utilizarea formulelor din foile de calcul Google Sheets sau Excel pentru date, iat\u0103 c\u00e2teva motive pentru care Excel \u0219i Google Sheets au sute de comenzi de formule:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Automatizeaz\u0103 rapid calculele<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Cu to\u021bii trebuie s\u0103 facem unele calcule de baz\u0103, cum ar fi aritmetica sau calcularea mediilor, indiferent de natura activit\u0103\u021bii noastre.&nbsp;<\/p>\n\n\n\n<p>Dac\u0103 lucra\u021bi cu multe date, ave\u021bi nevoie de calcule mai ample la o frecven\u021b\u0103 mult mai mare.&nbsp;<\/p>\n\n\n\n<p>Este foarte convenabil dac\u0103 pute\u021bi efectua aceste calcule \u00een cadrul foii de calcul \u00een care sunt stocate datele, \u00een loc s\u0103 fie nevoie s\u0103 importa\u021bi datele \u00eentr-un calculator.<\/p>\n\n\n\n<p>De asemenea, pute\u021bi seta formula o singur\u0103 dat\u0103, iar aceasta va continua s\u0103 ruleze pentru c\u00e2te r\u00e2nduri sau date introduce\u021bi, dup\u0103 cum este necesar.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Reducerea erorilor manuale<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Exportul datelor dvs. \u00eentr-o aplica\u021bie de calcul nu numai c\u0103 v\u0103 ia mult timp, dar este \u0219i predispus la erori. O singur\u0103 intrare gre\u0219it\u0103 \u0219i \u00eentregul dvs. calcul \u00eenainte nu mai este fiabil.<\/p>\n\n\n\n<p>Chiar \u0219i cu mai multe corecturi, nu pute\u021bi fi sigur dac\u0103 a\u021bi introdus toate valorile cu exactitate.&nbsp;<\/p>\n\n\n\n<p>Rularea unei formule de foaie de calcul reduce acest punct de erori.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Conectarea logic\u0103 a datelor<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Pute\u021bi \u00een\u021belege mult mai logic seturile dvs. de date prin intermediul calculelor. Sorta\u021bi datele, filtra\u021bi-le, efectua\u021bi o analiz\u0103 \u0219i \u00een\u021belege\u021bi mai bine la ce corespund toate acele numere din fiecare celul\u0103 a foii de calcul.&nbsp;<\/p>\n\n\n\n<p>Este excelent pentru:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Elaborarea bugetului&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>P\u0103strarea unei eviden\u021be financiare personale sau de afaceri&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Profesorii care doresc o eviden\u021b\u0103 a lucr\u0103rilor\/performan\u021belor elevilor lor la examene&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Date de cercetare&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calcularea randamentului investi\u021biilor&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>Acum, fie c\u0103 ave\u021bi nevoie s\u0103 cunoa\u0219te\u021bi formulele pentru foaia de calcul Google sau dori\u021bi o list\u0103 de formule pentru foaia de calcul Excel, le pute\u021bi g\u0103si \u00een sec\u021biunea urm\u0103toare.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Formule de baz\u0103 de care fiecare utilizator are nevoie<\/h2>\n\n\n\n<p>At\u00e2t Excel, c\u00e2t \u0219i Google Sheets au sute de formule care efectueaz\u0103 diferite calcule. V\u0103 va lua destul de multe luni dac\u0103 dori\u021bi s\u0103 le \u00eenv\u0103\u021ba\u021bi pe toate. Cu toate acestea, am descris mai jos c\u00e2teva dintre cele foarte utile.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUM pentru totaluri<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Comanda SUM() este utilizat\u0103 pentru a aduna toate celulele selectate. Desigur, trebuie s\u0103 ave\u021bi o valoare numeric\u0103 \u00een celul\u0103 pentru ca aceasta s\u0103 func\u021bioneze. Formula nu va func\u021biona \u00een nicio celul\u0103 f\u0103r\u0103 valoare numeric\u0103.&nbsp;<\/p>\n\n\n\n<p>\u00cen interiorul parantezei, trebuie s\u0103 specifica\u021bi prima \u0219i ultima celul\u0103 din segmentul de foaie de calcul pe care dori\u021bi s\u0103 \u00eel ad\u0103uga\u021bi, separate prin dou\u0103 puncte.&nbsp;<\/p>\n\n\n\n<p>Astfel, dac\u0103 doresc s\u0103 adaug con\u021binutul r\u00e2ndurilor 3 p\u00e2n\u0103 la 7 \u00een prima coloan\u0103, a\u0219 scrie formula astfel: SUM(A3:A7). Formula func\u021bioneaz\u0103, de asemenea, pe mai multe r\u00e2nduri.<\/p>\n\n\n\n<p>De asemenea, aceast\u0103 formul\u0103 r\u0103m\u00e2ne aceea\u0219i at\u00e2t pentru Google Sheets, c\u00e2t \u0219i pentru Excel.<\/p>\n\n\n\n<p>Uita\u021bi-v\u0103 la acest exemplu:&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"969\" height=\"630\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg\" alt=\"\" class=\"wp-image-20576\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals.jpg 969w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-300x195.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-768x499.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SUM-for-totals-18x12.jpg 18w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/figure><\/div>\n\n\n<p>Pe l\u00e2ng\u0103 cea mai simpl\u0103 func\u021bie SUM, pute\u021bi face \u0219i urm\u0103toarele tipuri de adun\u0103ri:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMIF: Adun\u0103 numere dintr-un interval care \u00eendeplinesc o condi\u021bie<br><\/li>\n\n\n\n<li>SUMIFS: Ad\u0103uga\u021bi numere dintr-un interval care \u00eendeplinesc mai multe condi\u021bii<br><\/li>\n\n\n\n<li>SUMPRODUCT: \u00cenmul\u021birea valorilor corespunz\u0103toare din matrici \u0219i apoi adunarea rezultatelor<br><\/li>\n\n\n\n<li>SUMSQ: Ad\u0103uga\u021bi p\u0103tratele numerelor dintr-un interval<br><\/li>\n\n\n\n<li>SUMX2MY2: Ad\u0103uga\u021bi rezultatul (x\u00b2 - y\u00b2) pentru valorile corespunz\u0103toare din dou\u0103 intervale<br><\/li>\n\n\n\n<li>SUMX2PY2: Ad\u0103uga\u021bi rezultatul (x\u00b2 + y\u00b2) pentru valorile corespunz\u0103toare din dou\u0103 intervale<br><\/li>\n\n\n\n<li>SUMXMY2: Ad\u0103uga\u021bi p\u0103tratele diferen\u021belor (x - y)\u00b2 pentru dou\u0103 intervale<br><\/li>\n\n\n\n<li>DSUM: Ad\u0103uga\u021bi valori \u00eentr-o coloan\u0103 care \u00eendeplinesc criteriile definite \u00eentr-un tabel din baza de date<br><\/li>\n\n\n\n<li>IMSUM: Ad\u0103uga\u021bi numere complexe.<br><\/li>\n\n\n\n<li>SERIESSUM: Calcula\u021bi suma unei serii de puteri folosind coeficien\u021bii da\u021bi.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg\" alt=\"\" class=\"wp-image-20577\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1024x504.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-300x148.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-768x378.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-1536x756.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM-18x9.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/SERIESSUM.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AVERAGE pentru perspective<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Formula AVERAGE() este utilizat\u0103 pentru a calcula media unui anumit set de celule din foaia de calcul.&nbsp;<\/p>\n\n\n\n<p>Din nou, modul de lucru este destul de asem\u0103n\u0103tor. Introduce\u021bi \u00een parantez\u0103 primul \u0219i ultimul num\u0103r al celulei, separate prin dou\u0103 puncte, de exemplu AVERAGE(E2:E11), \u0219i ve\u021bi ob\u021bine media pentru celulele selectate.<\/p>\n\n\n\n<p>Din nou, formula pentru medie este aceea\u0219i \u00een Excel ca \u0219i \u00een Google Sheets.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"501\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg\" alt=\"\" class=\"wp-image-20578\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights.jpg 847w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-300x177.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-768x454.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/AVERAGE-for-insights-18x12.jpg 18w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure><\/div>\n\n\n<p>Varia\u021biile u\u0219oare ale formulei AVERAGE v\u0103 pot ajuta cu calcule condi\u021bionate, cum ar fi:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MEDIE: Pentru a calcula media aritmetic\u0103 a numerelor dintr-un interval<br><\/li>\n\n\n\n<li>AVERAGEA: Utiliza\u021bi-l atunci c\u00e2nd dori\u021bi media, inclusiv numere, text \u0219i valori logice<br><\/li>\n\n\n\n<li>AVERAGEIF: Aceast\u0103 comand\u0103 este pentru media numerelor care \u00eendeplinesc o condi\u021bie<br><\/li>\n\n\n\n<li>AVERAGEIFS: Aceasta calculeaz\u0103 media numerelor care \u00eendeplinesc mai multe condi\u021bii<br><\/li>\n\n\n\n<li>DAVERAGE: Calculeaz\u0103 media valorilor dintr-o coloan\u0103 a bazei de date care \u00eendeplinesc criteriile specificate<br><\/li>\n\n\n\n<li>COUNT pentru a urm\u0103ri articolele<\/li>\n<\/ul>\n\n\n\n<p>Aceast\u0103 comand\u0103 este util\u0103 pentru a calcula num\u0103rul de celule din foaia de calcul care con\u021bin date numerice.&nbsp;<\/p>\n\n\n\n<p>Nu va avea sens s\u0103 \u00eel folosi\u021bi atunci c\u00e2nd datele dvs. sunt limitate la doar c\u00e2teva r\u00e2nduri, dar dac\u0103 ave\u021bi sute de r\u00e2nduri de date \u0219i dori\u021bi s\u0103 \u0219ti\u021bi c\u00e2te dintre acestea sunt valori numerice, ve\u021bi ajunge aici.<\/p>\n\n\n\n<p>Se scrie, de asemenea, \u00eentr-un mod similar, \u0219i anume, \u00eencepe\u021bi cu semnul =, apoi men\u021biona\u021bi comanda COUNT, deschide\u021bi paranteza, men\u021biona\u021bi prima \u0219i ultima celul\u0103 separate prin dou\u0103 puncte \u0219i \u00eenchide\u021bi paranteza.<\/p>\n\n\n\n<p>Formula este aceea\u0219i at\u00e2t \u00een Google Sheets, c\u00e2t \u0219i \u00een Excel.<\/p>\n\n\n\n<p>De exemplu, <strong>=COUNT(E1:E100)<\/strong><\/p>\n\n\n\n<p>La fel ca \u0219i formulele SUM \u0219i AVERAGE, COUNT poate fi utilizat \u00een mai multe moduri diferite, \u0219i anume,&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNTA: Pentru a num\u0103ra celulele care nu sunt goale (numere, text sau valori).<br><\/li>\n\n\n\n<li>COUNTBLANK: Num\u0103r\u0103 doar celulele goale dintr-un interval<br><\/li>\n\n\n\n<li>COUNTIF: Acesta num\u0103r\u0103 celulele care \u00eendeplinesc o condi\u021bie<br><\/li>\n\n\n\n<li>COUNTIFS: Utiliza\u021bi-l pentru a num\u0103ra celulele care \u00eendeplinesc mai multe condi\u021bii<br><\/li>\n\n\n\n<li>DCOUNT: Acesta num\u0103r\u0103 valorile numerice dintr-o coloan\u0103 a bazei de date care \u00eendeplinesc criteriile specificate<br><\/li>\n\n\n\n<li>DCOUNTA: Este utilizat pentru a num\u0103ra valorile nevide dintr-o coloan\u0103 de baz\u0103 de date care \u00eendeplinesc criteriile specificate<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"468\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg\" alt=\"\" class=\"wp-image-20579\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1024x468.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-300x137.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-768x351.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-1536x702.jpg 1536w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items-18x8.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/COUNT-to-track-items.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Formule avansate pentru analiza datelor<\/h2>\n\n\n\n<p>Pentru majoritatea utilizatorilor, formulele pe care le-am discutat mai devreme vor fi mai mult dec\u00e2t suficiente. Cu toate acestea, unele formule sunt necesare pentru calcule avansate \u0219i sunt foarte utile \u00een cazul \u00een care munca dvs. implic\u0103 analiza datelor.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>VLOOKUP pentru c\u0103ut\u0103ri<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Formula VLOOKUP este utilizat\u0103 pentru a g\u0103si o valoare \u00eentr-un tabel \u0219i pentru a returna informa\u021bii conexe din acela\u0219i r\u00e2nd.<\/p>\n\n\n\n<p>\u00cen termeni mai simpli, atunci c\u00e2nd introduce\u021bi VLOOKUP, solicita\u021bi foii de calcul s\u0103 caute o valoare \u00een prima coloan\u0103 a unui tabel, apoi s\u0103 v\u0103 ofere o valoare dintr-o alt\u0103 coloan\u0103 din r\u00e2ndul respectiv.<\/p>\n\n\n\n<p>\u00cen exemplul nostru de foaie, dac\u0103 coloana A are ID-uri de produs, iar coloana C are pre\u021bul pe unitate, putem utiliza VLOOKUP pentru a c\u0103uta un anumit ID de produs \u0219i a ob\u021bine pre\u021bul acestuia din coloana C.&nbsp;<\/p>\n\n\n\n<p>Acesta va fi scris ca VLOOKUP(\u201cP-1001\u201d, A:C, 3, FALSE)<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"522\" height=\"290\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg\" alt=\"\" class=\"wp-image-20581\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches.jpg 522w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-300x167.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/VLOOKUP-for-searches-18x10.jpg 18w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Instruc\u021biuni IF pentru logic\u0103<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Func\u021bia IF este utilizat\u0103 pentru a lua decizii logice \u00eentr-o foaie de calcul. Aceasta spune pur \u0219i simplu foii ce s\u0103 fac\u0103 atunci c\u00e2nd o condi\u021bie este adev\u0103rat\u0103 \u0219i ce s\u0103 fac\u0103 atunci c\u00e2nd este fals\u0103.<\/p>\n\n\n\n<p>Pentru a scrie o instruc\u021biune IF, \u00eencepe\u021bi cu semnul =, include\u021bi comanda IF, deschide\u021bi parantezele \u0219i apoi descrie\u021bi condi\u021bia.<\/p>\n\n\n\n<p>Dup\u0103 aceea, include\u021bi o virgul\u0103 \u0219i men\u021biona\u021bi ce dori\u021bi s\u0103 fac\u0103 foaia dac\u0103 condi\u021bia este \u00eendeplinit\u0103. Urma\u021bi-o cu o alt\u0103 virgul\u0103 \u0219i ce dori\u021bi s\u0103 se \u00eent\u00e2mple dac\u0103 comanda nu este \u00eendeplinit\u0103.<\/p>\n\n\n\n<p>De exemplu, dac\u0103 ne imagin\u0103m o foaie cu rezultatele elevilor \u0219i dorim s\u0103 specific\u0103m o condi\u021bie conform c\u0103reia un scor mai mare sau egal cu 50 reprezint\u0103 un scor de trecere, iar un scor mai mic de 50 reprezint\u0103 un e\u0219ec, am putea utiliza logica IF.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg\" alt=\"\" class=\"wp-image-20582\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-1024x582.jpg 1024w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-300x170.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-768x436.jpg 768w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic-18x10.jpg 18w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/IF-statements-for-logic.jpg 1162w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Iat\u0103 cum \u00eel ve\u021bi scrie: =IF(A1&gt;=50, \u201cPass\u201d, \u201cFail\u201d)<\/p>\n\n\n\n<p>Foaia va c\u0103uta valoarea din celul\u0103, iar dac\u0103 aceasta este mai mare de 50, va ar\u0103ta c\u0103 elevul a promovat. \u00cen caz contrar, se va men\u021biona c\u0103 a picat.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>INDEX &amp; MATCH pentru c\u0103utare<\/strong><\/li>\n<\/ul>\n\n\n\n<p>INDEX \u0219i MATCH sunt utilizate \u00eempreun\u0103 pentru a c\u0103uta informa\u021bii \u00eentr-un tabel \u00eentr-un mod mai flexibil dec\u00e2t formula LOOKUP.&nbsp;<\/p>\n\n\n\n<p>Func\u021bia MATCH este responsabil\u0103 pentru g\u0103sirea pozi\u021biei unei valori \u00eentr-un r\u00e2nd sau coloan\u0103. Utiliza\u021bi func\u021bia MATCH pentru a c\u0103uta o valoare \u00een tabel \u0219i aceasta nu va returna valoarea \u00een sine. Aceasta va returna un num\u0103r care reprezint\u0103 locul \u00een care apare valoarea.<\/p>\n\n\n\n<p>De exemplu, dac\u0103 ID-ul unui produs este al cincilea element dintr-o list\u0103, MATCH va returna 5.<\/p>\n\n\n\n<p>Func\u021bia INDEX utilizeaz\u0103 acel num\u0103r de pozi\u021bie pentru a returna o valoare dintr-o loca\u021bie specific\u0103 dintr-un tabel sau coloan\u0103. Deci, pur \u0219i simplu recupereaz\u0103 orice valoare existent\u0103 la r\u00e2ndul pe care \u00eel specifica\u021bi.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"336\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg\" alt=\"\" class=\"wp-image-20583\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup.jpg 325w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-290x300.jpg 290w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/INDEX-MATCH-for-lookup-12x12.jpg 12w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Sfaturi pentru a evita erorile frecvente de formulare<\/h2>\n\n\n\n<p>Dup\u0103 cum probabil a\u021bi v\u0103zut deja, at\u00e2t Excel, c\u00e2t \u0219i Google Sheets v\u0103 cer s\u0103 introduce\u021bi formulele cu o precizie de 100%.<\/p>\n\n\n\n<p>Orice eroare \u00een scrierea formulei nu v\u0103 va oferi rezultate, ve\u021bi primi doar un mesaj de eroare care spune #N\/A.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"493\" src=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg\" alt=\"\" class=\"wp-image-20584\" title=\"\" srcset=\"https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors.jpg 678w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-300x218.jpg 300w, https:\/\/undetectable.ai/blog\/wp-content\/uploads\/2026\/02\/Common-Formula-Errors-18x12.jpg 18w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n<p>Iat\u0103 c\u00e2teva sfaturi pentru a v\u0103 ajuta s\u0103 evita\u021bi acest mesaj de eroare.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Verifica\u021bi cu aten\u021bie parantezele<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Formula trebuie s\u0103 fie scris\u0103 \u00een formatul exact descris mai sus. Dac\u0103, din \u00eent\u00e2mplare, a\u021bi l\u0103sat parantezele deschise sau doar a\u021bi descris intervalul de celule f\u0103r\u0103 paranteze, nu ve\u021bi ob\u021bine calculul datelor.&nbsp;<\/p>\n\n\n\n<p>Asigura\u021bi-v\u0103 \u00eentotdeauna c\u0103 at\u00e2t parantezele de deschidere, c\u00e2t \u0219i cele de \u00eenchidere sunt bine plasate. De asemenea, asigura\u021bi-v\u0103 c\u0103 exist\u0103 dou\u0103 puncte pentru a diferen\u021bia prima \u0219i ultima celul\u0103 din intervalul dvs.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tipuri de date de supraveghere<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Formulele din foile de calcul func\u021bioneaz\u0103 cel mai bine numai cu anumite tipuri de date. De exemplu, nu v\u0103 pute\u021bi a\u0219tepta la o valoare medie pentru datele care nu sunt cuantificabile, de exemplu, formele descriptive de date.&nbsp;<\/p>\n\n\n\n<p>Ori de c\u00e2te ori introduce\u021bi formule, verifica\u021bi de dou\u0103 ori datele din celulele dvs. pentru a nu introduce un interval de celule invalid.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Evita\u021bi referin\u021bele circulare<\/strong><\/li>\n<\/ul>\n\n\n\n<p>O referin\u021b\u0103 circular\u0103 \u00eenseamn\u0103 c\u0103 foaia dvs. de calcul se \u00eentoarce la propria celul\u0103 \u00een care este descris\u0103. Aceasta creeaz\u0103 o bucl\u0103 de circula\u021bie infinit\u0103 \u00een care nu pute\u021bi ob\u021bine un r\u0103spuns \u0219i \u00een schimb va afi\u0219a doar un mesaj de eroare.<\/p>\n\n\n\n<p>De exemplu, dac\u0103 introduce\u021bi SUM(A1:A10) \u00een celula A10, a\u021bi creat o bucl\u0103 circular\u0103 \u00een care celula va trebui s\u0103 adauge continuu orice valoare \u00eensumat\u0103 \u00een celula A10, iar acest proces nu se va termina niciodat\u0103.<\/p>\n\n\n\n<p>Formula trebuie s\u0103 \u00ee\u0219i cunoasc\u0103 propriul rezultat pentru a g\u0103si valoarea celulei A10.<\/p>\n\n\n\n<p>Asigura\u021bi-v\u0103 \u00eentotdeauna c\u0103 celula \u00een care a\u021bi introdus formula din foaia de calcul nu face parte din intervalul de celule al formulei \u00een sine.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Combinarea formulelor pentru o mai bun\u0103 eficien\u021b\u0103<\/h2>\n\n\n\n<p>Combinarea formulelor \u00een foile de calcul v\u0103 permite s\u0103 rezolva\u021bi probleme complexe mai eficient. Atunci c\u00e2nd utiliza\u021bi formulele simple despre care am vorbit mai devreme, ve\u021bi calcula lucrurile pas cu pas \u00een mai multe celule. <\/p>\n\n\n\n<p>\u00centr-o formul\u0103 combinat\u0103, pute\u021bi include mai multe calcule, astfel \u00eenc\u00e2t o formul\u0103 s\u0103 se alimenteze direct \u00een alta.<\/p>\n\n\n\n<p>De exemplu, pute\u021bi combina IF cu SUM pentru a aduna valorile care \u00eendeplinesc numai anumite condi\u021bii.<\/p>\n\n\n\n<p>De asemenea, pute\u021bi combina COUNT sau AVERAGE cu condi\u021bii pentru a analiza datele mai precis.<\/p>\n\n\n\n<p>Acestea fiind spuse, combinarea formulelor nu vine u\u0219or la \u00eenceput. Exist\u0103 o curb\u0103 de \u00eenv\u0103\u021bare real\u0103, iar dac\u0103 v\u0103 lansa\u021bi \u00een formule complexe imbricate f\u0103r\u0103 s\u0103 le folosi\u021bi pe cele simple de un num\u0103r bun de ori, ve\u021bi ajunge s\u0103 v\u0103 confunda\u021bi.<\/p>\n\n\n\n<p>A\u0219adar, \u00eentotdeauna exersa\u021bi mai \u00eent\u00e2i cu formule simple. Dup\u0103 ce v\u0103 sim\u021bi\u021bi confortabil, cre\u0219te\u021bi treptat prin combinarea a dou\u0103 func\u021bii, apoi a trei \u0219i, \u00een cele din urm\u0103, a unor configura\u021bii mai avansate.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Utilizarea formulelor pentru sarcini din lumea real\u0103<\/h2>\n\n\n\n<p>Odat\u0103 ce v\u0103 familiariza\u021bi cu aceste formule, ve\u021bi \u00eencepe s\u0103 observa\u021bi c\u00e2t de des se aplic\u0103 la lucrurile pe care le face\u021bi deja.<\/p>\n\n\n\n<p>De exemplu:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un mic proprietar de afacere ar putea folosi formula <strong>SUMIF<\/strong> pentru a urm\u0103ri cheltuielile pe categorii<\/li>\n\n\n\n<li>Sau un profesor ar putea combina <strong>FI<\/strong> cu <strong>COUNTIF<\/strong> func\u021bii de semnalizare a elevilor care r\u0103m\u00e2n \u00een urm\u0103 cu temele<\/li>\n\n\n\n<li>Acela\u0219i lucru este valabil \u0219i \u00een cazul freelancerilor care gestioneaz\u0103 facturile clien\u021bilor. Ace\u0219tia pot utiliza un simplu <strong>VLOOKUP<\/strong> pentru a extrage tarifele clien\u021bilor dintr-o list\u0103 principal\u0103 f\u0103r\u0103 a parcurge manual r\u00e2ndurile.<\/li>\n<\/ul>\n\n\n\n<p>Chestia este c\u0103 a \u0219ti care formul\u0103 se potrive\u0219te situa\u021biei tale specifice este aproape jum\u0103tate din b\u0103t\u0103lie. \u0218i exact aici este unde Undetectable's <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">AI Chatbot<\/a> poate fi ghidul t\u0103u.&nbsp;<\/p>\n\n\n\n<p>Pute\u021bi descrie ceea ce \u00eencerca\u021bi s\u0103 face\u021bi \u00eentr-un limbaj simplu, iar acesta v\u0103 va sugera formula potrivit\u0103 pentru sarcina dumneavoastr\u0103.<\/p>\n\n\n\n<p>Acum ave\u021bi un coleg priceput la foile de calcul pe care \u00eel pute\u021bi contacta ori de c\u00e2te ori sunte\u021bi blocat, iar acest lucru nu se limiteaz\u0103 doar la interog\u0103rile din Excel sau Google spreadsheet.<\/p>\n\n\n\n<p>Descoperi\u021bi mai jos cum AI Detector \u0219i Humanizer v\u0103 pot \u00eembun\u0103t\u0103\u021bi con\u021binutul!<\/p>\n\n\n\n<div id=\"uai-widget\" data-affiliate-link=\"https:\/\/undetectable.ai\/?_by=hi4km\"><script>var js = document.createElement(\"script\");js.async = true;js.src = \"https:\/\/widget.undetectable.ai\/js\/widget-loader.js?t=\"+Date.now();document.getElementsByTagName(\"head\")[0].appendChild(js);<\/script><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">G\u00e2nduri finale<\/h2>\n\n\n\n<p>Sper c\u0103 acest articol v-a ajutat s\u0103 \u00eenv\u0103\u021ba\u021bi c\u00e2teva lucruri despre formulele din foile de calcul.&nbsp;<\/p>\n\n\n\n<p>Cu c\u00e2t le folose\u0219ti mai mult, cu at\u00e2t devii mai bun la ele \u0219i, de fiecare dat\u0103 c\u00e2nd nu \u0219tii ce \u0219ir de formule s\u0103 folose\u0219ti, apeleaz\u0103 la ajutorul lui Undetectable AI <a href=\"https:\/\/undetectable.ai\/ai-chat\" target=\"_blank\" rel=\"noreferrer noopener\">Chat AI<\/a>, \u0219i v\u0103 va ajuta s\u0103 decide\u021bi ce comand\u0103 va func\u021biona cel mai bine pentru calculul dorit.&nbsp;<\/p>\n\n\n\n<p>Pute\u021bi, de asemenea, s\u0103 v\u0103 verifica\u021bi de dou\u0103 ori formula rul\u00e2nd-o prin AI Chat pentru a confirma c\u0103 nu face\u021bi nicio eroare.<\/p>\n\n\n\n<p>\u00cencerca\u021bi <a href=\"https:\/\/undetectable.ai\/\" target=\"_blank\" rel=\"noreferrer noopener\">AI nedetectabil<\/a> ast\u0103zi!<\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":15,"featured_media":20575,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-20569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-news"],"_links":{"self":[{"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/posts\/20569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/comments?post=20569"}],"version-history":[{"count":5,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/posts\/20569\/revisions"}],"predecessor-version":[{"id":20585,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/posts\/20569\/revisions\/20585"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/media\/20575"}],"wp:attachment":[{"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/media?parent=20569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/categories?post=20569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/undetectable.ai/blog\/ro\/wp-json\/wp\/v2\/tags?post=20569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}