{"id":2201,"date":"2024-08-27T14:21:36","date_gmt":"2024-08-27T12:21:36","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=2201"},"modified":"2024-08-27T14:40:28","modified_gmt":"2024-08-27T12:40:28","slug":"istorijat-dodavanja-formula-u-excelu","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/","title":{"rendered":"[:sr]Istorijat dodavanja funkcija u Excelu[:en]History of adding Functions into Excel[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Istorijat_dodavanja_funkcija_u_Excelu\" >Istorijat dodavanja funkcija u Excelu<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Excel_2007\" >Excel 2007<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_2010\" >Funkcije dodate u Excel 2010<\/a><\/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\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_2013\" >Funkcije dodate u Excel 2013<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_2016\" >Funkcije dodate u Excel 2016<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_2019\" >Funkcije dodate u Excel 2019<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_2021\" >Funkcije dodate u Excel 2021<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Funkcije_dodate_u_Excel_365\" >Funkcije\u00a0dodate u Excel 365<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#History_of_adding_formulas_in_Excel\" >History of adding formulas in Excel<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Excel_2007-2\" >Excel 2007<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_2010\" >Formulas added to Excel 2010<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_2013\" >Formulas added to Excel 2013<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_2016\" >Formulas added to Excel 2016<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_2019\" >Formulas added to Excel 2019<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_2021\" >Formulas added to Excel 2021<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_365\" >Formulas added to Excel 365<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n[:sr]\n<h1><span class=\"ez-toc-section\" id=\"Istorijat_dodavanja_funkcija_u_Excelu\"><\/span>Istorijat dodavanja funkcija u Excelu<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Funkcije radnog lista su kategorizovane po njihovoj funkcionalnosti. Kliknite na kategoriju da biste pregledali njene funkcije. Ili pritisnite kombinaciju tastera Ctrl+F da biste prona\u0161li funkciju tako \u0161to \u0107ete otkucati prvih nekoliko slova ili re\u010d koja je opisuje. Da biste dobili detaljne informacije o funkciji, kliknite na njeno ime u prvoj koloni.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_2007\"><\/span>Excel 2007<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table>\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><strong>SUMIFS<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a ukupno svih brojeva u nizu \u0107elija koje zadovol\u0458avaju vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px;\"><strong>AVERAGEIF<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a prosek svih brojeva u nizu \u0107elija koje zadovol\u0458avaju uslov.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><strong>AVERAGEIFS<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a prosek svih brojeva u nizu \u0107elija koje zadovol\u0458avaju vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><strong>COUNTIFS<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj \u0107elija sa vrijedno\u0161\u0107u koja zadovol\u0458ava vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><strong>IFERROR<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost ili ako ta vrednost generi\u0161e gre\u0161ku koju vra\u0107a druga\u010diju vrednost.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBEKPIMEMBER<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kl\u0458u\u010dni prostor za performanse (KPI) i prikazuje ime KPI.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBEMEMBER<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a \u010dlana ili tuple iz kocke.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBEMEMBERPROPERTY<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost imovine \u010dlana iz kocke.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBERANKEDMEMBER<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a NTH ili rangiran \u010dlan u set.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBESET<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a izra\u010dunate \u010dlanove vra\u0107ene iz kocke.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBESETCOUNT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj predmeta u setu.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CUBEVALUE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a agregiranu vrednost iz kocke.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_2010\"><\/span>Funkcije dodate u Excel 2010<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><strong>AGGREGATE<\/strong><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a agregat na listi ili bazi podataka. Zamenjuje subtotal<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BETA.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kumulativnu funkciju gustine verovatno\u0107e beta verovatno\u0107e. Zamenjuje betadist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BETA.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnutu funkciju gustine beta verovatno\u0107e. Zamenjuje betainv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BINOM.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a individualnu izrazu binomalne verovatno\u0107e distribucije. Zamenjuje binomdista<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BINOM.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a je najmanji broj koji je kumulativna binomijalna distribucija koja je ve\u0107a od vrednosti kriterijuma. Zamenjuje Critbinom<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CEILING.PRECISE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Zaokru\u017euje broj najbli\u017ei celi broj ili do najbli\u017eeg vi\u0161estrukog zna\u010daja. Bez obzira na znak broja, broj je zaokru\u017een.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CHISQ.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kumulativnu funkciju gustine verovatno\u0107e beta verovatno\u0107e.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CHISQ.DIST.RT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a jednu reprodukciju verovatno\u0107e distribucije Chi-Skuared. Zamenjuje Chidist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CHISQ.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a slu\u010dajnu promenl\u0458ivu gde je verovatno\u0107a da je &#8220;manje od&#8221; P.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CHISQ.INV.RT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto jednu reprodukciju verovatno\u0107e distribucije Chi-Cvaver. Zamenjuje Chiinv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CHISQ.TEST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost verovatno\u0107e iz distribucije Chi-Skuever. Zamenjuje najgori<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CONFIDENCE.NORM<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a interval pouzdanosti za srednju populaciju. Zamenjuje samopouzdanje<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CONFIDENCE.T<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a interval pouzdanosti za srednju populaciju, koriste\u0107i studentsku T distribuciju.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">COVARIANCE.P<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a se kovarijansa dve liste brojeva. Zamenjuje kuvar<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">COVARIANCE.S<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a uzorak kovarijansa, prosek proizvoda odstupanja za svaki par podataka u dva skupa podataka.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ERF.PRECISE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a funkciju gre\u0161ke.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ERFC.PRECISE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a komplementarnu funkciju ERF integrisana izme\u0111u Ks i beskona\u010dnosti.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">EXPON.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a eksponencijalnu distribuciju. Zamenjuje ekspondista<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">F.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a distribuciju verovatno\u0107e verovatno\u0107e.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">F.DIST.RT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a distribuciju verovatno\u0107e verovatno\u0107e. Zamenjuje falsifikat<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">F.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto distribuciju verovatno\u0107e verovatno\u0107e.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">F.INV.RT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto distribuciju verovatno\u0107e verovatno\u0107e. Zamenjuje FINV<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">F.TEST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost verovatno\u0107e iz distribucije F. Zamenjuje Ftest<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FLOOR.PRECISE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Zaokru\u017euje broj najbli\u017ei celi broj ili do najbli\u017eeg vi\u0161estrukog zna\u010daja. Bez obzira na znak broja, broj je zaokru\u017een.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">GAMMA.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a distribuciju gama. Zamenjuje gamadistu<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">GAMMA.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto distribuciju gama. Zamenjuje gamainv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">GAMMALN.PRECISE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a prirodni logaritam gama funkcije, g (k).<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">HYPGEOM.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiper geometrijska distribucija za kona\u010dni stanovni\u0161tvo. Zamenjuje hipskudistu<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ISO.CEILING<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Zaokru\u017euje broj do najbli\u017eeg celog broja ili na najbli\u017eu vi\u0161estruku od zna\u010daja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">LOGNORM.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kumulativnu dugotrajnu distribuciju Ks, gde se LN (k) obi\u010dno distribuira sa parametrima srednjim i standardnim_devim. Zamenjuje lognormdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">LOGNORM.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto na logormalnu kumulativnu funkciju Ks, gde se LN (Ks) obi\u010dno distribuira sa parametrima srednjim i standardnim_devim. Zamenjuje Loginv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">MODE.MULT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vertikalni niz naj\u010de\u0161\u0107e nastalih ili ponavl\u0458aju\u0107ih vrednosti u nizu ili rasponu podataka.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">MODE.SNGL<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj koji se naj\u010de\u0161\u0107e pojavl\u0458uje u dometu. Zamenjuje re\u017eim<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NEGBINOM.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a negativnu dvomilnu distribuciju. Zamenjuje negbinomdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NETWORKDAYS.INTL<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj celog radnog dana izme\u0111u dva datuma koriste\u0107i parametre kako bi nazna\u010dili koji i koliko dana su vikend dani. Zamenjuje mre\u017ene dane<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NORM.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a normalnu kumulativnu distribuciju. Zamenjuje Normdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NORM.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto normalnu kumulativnu distribuciju. Zamenjuje NORMINV<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NORM.S.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a standardnu normalnu kumulativnu distribuciju. Zamenjuje NormSdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NORM.S.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a obrnuto standardne normalne kumulativne distribucije. Zamenjuje norminv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PERCENTILE.EXC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a KTHentel vrednosti vrednosti u dometu, gde je K u opsegu 0..1, ekskluzivno.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PERCENTILE.INC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">KTHERENTILE VREDNOSTI U nizu brojeva. Zamenjuje procentila<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PERCENTRANK.EXC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a \u010din vrednosti u podacima postavl\u0458enom u procentu (0..1, ekskluzivno) skupa podataka.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PERCENTRANK.INC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a \u010din vrednosti u podacima postavl\u0458enom u procentu skupa podataka. Zamenjuje procentirank<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">POISSON.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a distribuciju poisson-a. Zamenjuje Poisson<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">QUARTILE.EXC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kvartil skupa podataka, zasnovan na procentima vrednosti od 0..1, ekskluzivno.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">QUARTILE.INC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kvartil skupa podataka. Zamenjuje kvartile<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">RANK.AVG<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a rang broja na listi brojeva: veli\u010dina u odnosu na druge vrednosti na listi; Ako vi\u0161e od jedne vrednosti ima isti rang, vra\u0107en je prose\u010dan rang.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">RANK.EQ<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a rang broja na listi brojeva. Zamenjuje rang<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">STDEV.P<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a standardno odstupanje na osnovu celokupnog stanovni\u0161tva. Zamenjuje stdevp<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">STDEV.S<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a standardno odstupanje na osnovu uzorka. Zamenjuje stdev<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a procentne ta\u010dke (verovatno\u0107a) za T-distribuciju u\u010denika.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.DIST.2T<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a dvorevnu studentsku T-distribuciju. Zamenjuje tdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.DIST.RT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a t-distribuciju u\u010denika desno re\u0161eno. Zamenjuje tdist<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.INV<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a T vrednost T-distribucije u\u010denika kao funkciju verovatno\u0107e i stepena slobode.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.INV.2T<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a T vrednost T-distribucije u\u010denika kao funkciju verovatno\u0107e i stepena slobode. Zamenjuje Tinv<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">T.TEST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost verovatno\u0107e iz T distribucije. Zamenjuje ttest<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">VAR.P<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a varijancu na osnovu celokupnog stanovni\u0161tva. Zamenjuje Varp<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">VAR.S<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a varijancu na osnovu uzorka. Zamenjuje var<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">WEIBULL.DIST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a distribuciju Veibull-a. Zamenjuje veibull<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">WORKDAY.INTL<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a serijski broj koji je dat broj dana pre ili posle datuma. Zamenjuje radni dan<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Z.TEST<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost verovatno\u0107e iz normalne distribucije. Zamenjuje Ztest<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_2013\"><\/span>Funkcije dodate u Excel 2013<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ACOT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a arc-cotangent iz broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ACOTH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dki ARC-Cotangent iz broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ARABIC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj pretvoren od Rima na arapski jezik.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BASE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj pretvoren u tekst zastupanje sa datom bazom.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BINOM.DIST.RANGE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a verovatno\u0107u rezultata su\u0111enja koriste\u0107i binomalnu distribuciju.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BITAND<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a bodu i dva broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BITLSHIFT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj pomaknutog levog broja bita.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BITOR<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a bijelo ili dva broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BITRSHIFT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj pomaknutog pravednog broja bita.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">BITXOR<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a bodu navivo ekskluzivno ili dva broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CEILING.MATH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj zaokru\u017eenog do najbli\u017eeg celog broja ili na najbli\u017eu zna\u010dajnu cifru.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">COMBINA<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj kombinacija sa ponavl\u0458anjima za odre\u0111eni broj predmeta.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">COT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dku kosinusu broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">COTH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kotangent ugao.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CSC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a cosecant uglova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CSCH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dki rodi\u010dni ugao.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">DAYS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj dana izme\u0111u dva datuma.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">DECIMAL<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a decimalni broj tekstualnog predstavl\u0458anja broja u odre\u0111enoj bazi.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ENCODEURL<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a url kodirani niz.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FILTERXML<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a posebne podatke sa sadr\u017eaja KSML kori\u0161\u0107enjem KSPATH.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FLOOR.MATH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj zaokru\u017eenog na najbli\u017ei celi broj u datoj bazi u decimalni broj.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORMULATEXT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a formulu iz odre\u0111ene \u0107elije.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">GAMMA<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost gama funkcije.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">GAUSS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a 0,5 manje od standardne normalne kumulativne distribucije.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IFNA<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a boolovsku vrednost u zavisnosti da li je vrednost # n \/ a.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMCOSH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dku kosinus slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMCOT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kotangent slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMCSC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a cosecant slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMCSCH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dki koravni plan slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMSEC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a seanse slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMSECH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dki mese\u010dar slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMSINH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dko sinus slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IMTAN<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a tangentu slo\u017eenog broja.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ISFORMULA<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a boolovsku vrednost u zavisnosti da li \u0107elija sadr\u017ei formulu.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">ISOWEEKNUM<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj ISO nedel\u0458e u godini za datum.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">MUNIT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a matricu jedinice ili navedenu dimenziju.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">NUMBERVALUE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a tekst na broj na lokalnom nezavisnom na\u010dinu.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PDURATION<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj perioda koji zahtevaju investicija da bi se postigla odre\u0111ena vrednost.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PERMUTATIONA<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj permutacija za podskup objekata ili doga\u0111aja (sa ponavl\u0458anjem).<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">PHI<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost funkcije gustine za standardnu normalnu distribuciju.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">RRI<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a ekvivalentnu kamatnu stopu za rast investicije.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SEC<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a seanse ugao.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SECH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a hiperboli\u010dki mese\u010dev ugao.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SHEET<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj lima referen\u010denog lima.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SHEETS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj listova u referenci.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SKEW.P<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a skednost distribucije zasnovane na populaciji.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">UNICHAR<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a kopiju Unicode koji je referenca donete numeri\u010dke vrednosti.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">UNICODE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a broj koji odgovara prvom karakteru teksta.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">WEBSERVICE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a podatke sa VebErvice.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">XOR<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a logi\u010dko ekskluzivno ili bilo koji broj argumenata.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_2016\"><\/span>Funkcije dodate u Excel 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORECAST.ETS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a budu\u0107u vrednost na osnovu istorijskih vrednosti.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORECAST.ETS.CONFINT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a interval poverenja za budu\u0107u vrednost.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORECAST.ETS.SEASONALITY<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a du\u017einu uzorka ponavl\u0458aju\u0107e sezonske uzorak.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORECAST.ETS.STAT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a statisti\u010dku vrednost za budu\u0107u vrednost.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">FORECAST.LINEAR<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a budu\u0107u vrednost i vrednost na osnovu postoje\u0107ih vrednosti.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_2019\"><\/span>Funkcije dodate u Excel 2019<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">CONCAT<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a tekstualni niz koji je spajanje nekoliko \u017eica. Zamenjuje ugovor<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">IFS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost na osnovu vi\u0161e uslova koje navedete.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">MAXIFS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a najve\u0107u vrednost na listi ili nizu brojeva koji zadovol\u0458ava vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">MINIFS<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a je najmanju vrednost na listi ili nizu brojeva koji zadovol\u0458avaju vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SWITCH<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost na osnovu liste odgovaraju\u0107ih stavki.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">TEXTJOIN<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a tekstualni niz koji je spajanje nekoliko \u017eica.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_2021\"><\/span>Funkcije dodate u Excel 2021<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/22\/filter-formula-filtrira\/\">FILTER<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz podataka u dometu koji zadovol\u0458ava vi\u0161e uslova.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">LET<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a rezultat formule koja mo\u017ee da koristi promenl\u0458ive.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">RANDARRAY<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz slu\u010dajnih brojeva izme\u0111u 0 i 1.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SEQUENCE<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz sekvencijalnih brojeva.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/21\/sort\/\">SORT<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz podataka u rasponu koji je sortiran.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">SORTBY<\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz podataka u dometu koji je sortiran na osnovu vrednosti u odgovaraju\u0107em opsegu.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/20\/unique-vraca-niz-jedinstvenih-vrednosti-na-listi\/\">UNIQUE<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a niz jedinstvenih vrednosti na listi, stol ili rasponu \u0107elija.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"http:\/\/XLOOKUP\">XLOOKUP<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a vrednost u istom redu nakon pronala\u017eenja odgovaraju\u0107e vrednosti u bilo kojem stupcu.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/2022\/01\/08\/xmatch-formula-daje-redni-broj\/\">XMATCH<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a polo\u017eaj vrednosti na listi, stol ili raspon \u0107elija.<\/td>\n<\/tr>\n<tr style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<td style=\"padding-top: 0px; padding-bottom: 0px;\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/kako-napraviti-novu-funkciju-u-excel-u-upotrebom-lambda\/\">LAMBDA<\/a><\/td>\n<td style=\"padding-top: 0px; padding-bottom: 0px;\">Vra\u0107a rezultate formule koja se dodaje kao imenovani asortiman. Od apdejta 2022.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Funkcije_dodate_u_Excel_365\"><\/span>Funkcije\u00a0dodate u Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<tr>\n<td>FIELDVALUE<\/td>\n<td>(2020) Vra\u0107a podatke polja iz tipa podataka vezanog za akcije ili geografiju.<\/td>\n<\/tr>\n<tr>\n<td>LAMBDA<\/td>\n<td>(2020) Vra\u0107a rezultate formule koja je dodata kao imenovani opseg.<\/td>\n<\/tr>\n<tr>\n<td>STOCKHISTORY<\/td>\n<td>(2020) Vra\u0107a istorijske podatke o finansijskom instrumentu.<\/td>\n<\/tr>\n<tr>\n<td>ARRAYTOTEXT<\/td>\n<td>(2021) Vra\u0107a sadr\u017eaj niza ili opsega \u0107elija pretvoren u tekst.<\/td>\n<\/tr>\n<tr>\n<td>BYCOL<\/td>\n<td>(2021) Vra\u0107a rezultate primene LAMBDA funkcije na svaku kolonu u nizu.<\/td>\n<\/tr>\n<tr>\n<td>BYROW<\/td>\n<td>(2021) Vra\u0107a rezultate primene LAMBDA funkcije na svaki red u nizu.<\/td>\n<\/tr>\n<tr>\n<td>ISOMITTED<\/td>\n<td>(2021) Vra\u0107a vrednost Ta\u010dno ili Neta\u010dno u zavisnosti od toga da li nedostaje vrednost u LAMBDA.<\/td>\n<\/tr>\n<tr>\n<td>MAKEARRAY<\/td>\n<td>(2021) Vra\u0107a niz izra\u010dunat primenom LAMBDA funkcije.<\/td>\n<\/tr>\n<tr>\n<td>MAP<\/td>\n<td>(2021) Vra\u0107a niz formiran primenom mape pomo\u0107u LAMBDA funkcije.<\/td>\n<\/tr>\n<tr>\n<td>REDUCE<\/td>\n<td>(2021) Vra\u0107a ukupnu vrednost nakon smanjenja niza primenom LAMBDA funkcije.<\/td>\n<\/tr>\n<tr>\n<td>SCAN<\/td>\n<td>(2021) Vra\u0107a niz nakon primene LAMBDA funkcije na svaku vrednost i vra\u0107a niz.<\/td>\n<\/tr>\n<tr>\n<td>VALUETOTEXT<\/td>\n<td>(2021) Vra\u0107a tekst iz bilo koje navedene vrednosti.<\/td>\n<\/tr>\n<tr>\n<td>CHOOSECOLS<\/td>\n<td>(2022) Vra\u0107a niz samo sa odre\u0111enim brojem kolona.<\/td>\n<\/tr>\n<tr>\n<td>CHOOSEROWS<\/td>\n<td>(2022) Vra\u0107a niz samo sa odre\u0111enim brojem redova.<\/td>\n<\/tr>\n<tr>\n<td>DROP<\/td>\n<td>(2022) Vra\u0107a niz bez odre\u0111enih redova ili kolona.<\/td>\n<\/tr>\n<tr>\n<td>EXPAND<\/td>\n<td>(2022) Vra\u0107a niz pro\u0161iren ili dopunjen na odre\u0111ene dimenzije.<\/td>\n<\/tr>\n<tr>\n<td>HSTACK<\/td>\n<td>(2022) Vra\u0107a niz nakon kombinovanja dva niza horizontalno u nizu.<\/td>\n<\/tr>\n<tr>\n<td>IMAGE<\/td>\n<td>(2022) Vra\u0107a sliku sa veb URL adrese.<\/td>\n<\/tr>\n<tr>\n<td>TAKE<\/td>\n<td>(2022) Vra\u0107a presek odre\u0111enih redova i kolona u nizu.<\/td>\n<\/tr>\n<tr>\n<td>TEXTAFTER<\/td>\n<td>(2022) Vra\u0107a znakove sa kraja tekstualnog niza posle grani\u010dnika.<\/td>\n<\/tr>\n<tr>\n<td>TEXTBEFORE<\/td>\n<td>(2022) Vra\u0107a znakove sa po\u010detka tekstualnog niza pre grani\u010dnika.<\/td>\n<\/tr>\n<tr>\n<td>TEXTSPLIT<\/td>\n<td>(2022) Vra\u0107a tekstualni niz podeljen na vi\u0161e kolona pomo\u0107u grani\u010dnika.<\/td>\n<\/tr>\n<tr>\n<td>TOCOL<\/td>\n<td>(2022) Vra\u0107a niz transformisan u jednu kolonu.<\/td>\n<\/tr>\n<tr>\n<td>TOROW<\/td>\n<td>(2022) Vra\u0107a niz transformisan u jedan red.<\/td>\n<\/tr>\n<tr>\n<td>VSTACK<\/td>\n<td>(2022) Vra\u0107a niz nakon kombinovanja dva niza vertikalno u nizu.<\/td>\n<\/tr>\n<tr>\n<td>WRAPCOLS<\/td>\n<td>(2022) Vra\u0107a niz transformisan u vi\u0161e kolona.<\/td>\n<\/tr>\n<tr>\n<td>WRAPROWS<\/td>\n<td>(2022) Vra\u0107a niz transformisan u vi\u0161e redova.<\/td>\n<\/tr>\n<tr>\n<td>GROUPBY<\/td>\n<td>(2023) Vra\u0107a grupisanje va\u0161ih podataka du\u017e jedne ose i agregira povezane vrednosti.<\/td>\n<\/tr>\n<tr>\n<td>PIVOTBY<\/td>\n<td>(2023) Vra\u0107a grupisanje va\u0161ih podataka du\u017e dve ose i agregira povezane vrednosti.<\/td>\n<\/tr>\n<tr>\n<td>PY<\/td>\n<td>(2023) Vra\u0107a vrednost ili objekat nakon pokretanja koda u Pajton editoru.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n[:en]\n<h1><span class=\"ez-toc-section\" id=\"History_of_adding_formulas_in_Excel\"><\/span>History of adding formulas in Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Worksheet functions are categorized by their functionality.\u00a0Click on a category to view its features.\u00a0Or press Ctrl+F to find the function by typing the first few letters or the word that describes it.\u00a0To get detailed information about a function, click on its name in the first column.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_2007-2\"><\/span><span id=\"Excel_2007\" class=\"ez-toc-section\"><\/span>Excel 2007<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>SUMIFS<\/strong><\/td>\n<td>Returns the total of all numbers in a range of cells that meet multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td><strong>AVERAGEIF<\/strong><\/td>\n<td>Returns the average of all numbers in a range of cells that satisfy a condition.<\/td>\n<\/tr>\n<tr>\n<td><strong>AVERAGEIFS<\/strong><\/td>\n<td>Returns the average of all numbers in a range of cells that meet multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td><strong>COUNTIFS<\/strong><\/td>\n<td>Returns the number of cells with a value that satisfies multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td><strong>IFERROR<\/strong><\/td>\n<td>Returns a value or if that value generates an error it returns a different value.<\/td>\n<\/tr>\n<tr>\n<td>CUBEKPIMEMBER<\/td>\n<td>Returns the Key Performance Space (KPI) and displays the name of the KPI.<\/td>\n<\/tr>\n<tr>\n<td>CUBEMEMBER<\/td>\n<td>Returns a member or tuple from the cube.<\/td>\n<\/tr>\n<tr>\n<td>CUBEMEMBERPROPERTY<\/td>\n<td>Returns the value of the member&#8217;s property from the cube.<\/td>\n<\/tr>\n<tr>\n<td>CUBERANKEDMEMBER<\/td>\n<td>Returns the NTH or ranked member in the set.<\/td>\n<\/tr>\n<tr>\n<td>CUBESET<\/td>\n<td>Returns the calculated members returned from the cube.<\/td>\n<\/tr>\n<tr>\n<td>CUBESETCOUNT<\/td>\n<td>Returns the number of items in the set.<\/td>\n<\/tr>\n<tr>\n<td>CUBEVALUE<\/td>\n<td>Returns the aggregated value from the cube.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_2010\"><\/span><span id=\"Formule_dodate_u_Excel_2010\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 2010<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr>\n<td><strong>AGGREGATE<\/strong><\/td>\n<td>Returns an aggregate in a list or database.\u00a0Replaces the subtotal<\/td>\n<\/tr>\n<tr>\n<td>BETA.DIST<\/td>\n<td>Returns the cumulative probability density function of the beta probability.\u00a0Replaces betadist<\/td>\n<\/tr>\n<tr>\n<td>BETA.INV<\/td>\n<td>Returns the inverse of the beta probability density function.\u00a0Replaces betainev<\/td>\n<\/tr>\n<tr>\n<td>BINOM.DIST<\/td>\n<td>Returns the individual expression of the binomial probability distribution.\u00a0It replaces the binomist<\/td>\n<\/tr>\n<tr>\n<td>BINOM.INV<\/td>\n<td>Returns the smallest number that is the cumulative binomial distribution that is greater than the criterion value.\u00a0Replaces Critbin<\/td>\n<\/tr>\n<tr>\n<td>CEILING.PRECISE<\/td>\n<td>Rounds the number to the nearest whole number or to the nearest multiple.\u00a0Regardless of the sign of the number, the number is rounded.<\/td>\n<\/tr>\n<tr>\n<td>CHISQ.DIST<\/td>\n<td>Returns the cumulative probability density function of the beta probability.<\/td>\n<\/tr>\n<tr>\n<td>CHISQ.DIST.RT<\/td>\n<td>Returns a single reproduction of the Chi-Squared probability distribution.\u00a0Replaces Chidist<\/td>\n<\/tr>\n<tr>\n<td>CHISQ.INV<\/td>\n<td>Returns a random variable where the probability is \u201cless than\u201d P .<\/td>\n<\/tr>\n<tr>\n<td>CHISQ.INV.RT<\/td>\n<td>Returns the inverse of a reproduction of the probability distribution of the Chi-Cvaver.\u00a0Replaces Chiinv<\/td>\n<\/tr>\n<tr>\n<td>CHISQ.TEST<\/td>\n<td>Returns the probability value from the Chi-Square distribution.\u00a0It replaces the worst<\/td>\n<\/tr>\n<tr>\n<td>CONFIDENCE.NORM<\/td>\n<td>Returns the confidence interval for the population mean.\u00a0It replaces self-confidence<\/td>\n<\/tr>\n<tr>\n<td>CONFIDENCE.T<\/td>\n<td>Returns the confidence interval for the population mean, using the Student&#8217;s T distribution.<\/td>\n<\/tr>\n<tr>\n<td>COVARIANCE.P<\/td>\n<td>The covariance of two lists of numbers is returned.\u00a0Replaces the cook<\/td>\n<\/tr>\n<tr>\n<td>COVARIANCE.S<\/td>\n<td>Returns the sample covariance, the average of the product of the deviations for each pair of data in the two data sets.<\/td>\n<\/tr>\n<tr>\n<td>ERF.PRECISE<\/td>\n<td>Returns the error function.<\/td>\n<\/tr>\n<tr>\n<td>ERFC.PRECISE<\/td>\n<td>Returns the complementary function ERF integrated between Ks and infinity.<\/td>\n<\/tr>\n<tr>\n<td>EXPON.DIST<\/td>\n<td>Returns the exponential distribution.\u00a0It replaces the exhibitor<\/td>\n<\/tr>\n<tr>\n<td>F.DIST<\/td>\n<td>Returns the probability distribution of the probability.<\/td>\n<\/tr>\n<tr>\n<td>F.DIST.RT<\/td>\n<td>Returns the probability distribution of the probability.\u00a0It replaces counterfeit<\/td>\n<\/tr>\n<tr>\n<td>F.INV<\/td>\n<td>Returns the inverse probability distribution of the probability.<\/td>\n<\/tr>\n<tr>\n<td>F.INV.RT<\/td>\n<td>Returns the inverse probability distribution of the probability.\u00a0Replaces FINV<\/td>\n<\/tr>\n<tr>\n<td>F.TEST<\/td>\n<td>Returns the probability value from the distribution F. Replaces Ftest<\/td>\n<\/tr>\n<tr>\n<td>FLOOR.PRECISE<\/td>\n<td>Rounds the number to the nearest whole number or to the nearest multiple.\u00a0Regardless of the sign of the number, the number is rounded.<\/td>\n<\/tr>\n<tr>\n<td>GAMMA.DIST<\/td>\n<td>Returns the gamma distribution.\u00a0It replaces the vermin<\/td>\n<\/tr>\n<tr>\n<td>GAMMA.INV<\/td>\n<td>Returns the inverse gamma distribution.\u00a0Replaces gamainv<\/td>\n<\/tr>\n<tr>\n<td>GAMMALN.PRECISE<\/td>\n<td>Returns the natural logarithm of the gamma function, g (k).<\/td>\n<\/tr>\n<tr>\n<td>HYPGEOM.DIST<\/td>\n<td>Returns the hyper geometric distribution for the finite population.\u00a0It replaces the Hipscudist<\/td>\n<\/tr>\n<tr>\n<td>ISO.CEILING<\/td>\n<td>Rounds a number to the nearest whole number or to the nearest multiple of significance.<\/td>\n<\/tr>\n<tr>\n<td>LOGNORM.DIST<\/td>\n<td>Returns the cumulative long-run distribution of Ks, where LN (k) is normally distributed with parameters mean and standard_dev.\u00a0Replaces lognormdist<\/td>\n<\/tr>\n<tr>\n<td>LOGNORM.INV<\/td>\n<td>Returns the inverse of the lognormal cumulative function Ks, where LN(Ks) is normally distributed with parameters mean and standard_dev.\u00a0Replaces Loginv<\/td>\n<\/tr>\n<tr>\n<td>MODE.MULT<\/td>\n<td>Returns a vertical array of the most frequently occurring or repeating values \u200b\u200bin a data array or range.<\/td>\n<\/tr>\n<tr>\n<td>MODE.SNGL<\/td>\n<td>Returns the most frequently occurring number in the range.\u00a0Replaces mode<\/td>\n<\/tr>\n<tr>\n<td>NEGBINOM.DIST<\/td>\n<td>Returns the negative binomial distribution.\u00a0Replaces negbinomdist<\/td>\n<\/tr>\n<tr>\n<td>NETWORKDAYS.INTL<\/td>\n<td>Returns the number of full weekdays between two dates using parameters to indicate which and how many days are weekend days.\u00a0Replaces network days<\/td>\n<\/tr>\n<tr>\n<td>NORM.DIST<\/td>\n<td>Returns the normal cumulative distribution.\u00a0Replaces Normdist<\/td>\n<\/tr>\n<tr>\n<td>NORM.INV<\/td>\n<td>Returns the inverse normal cumulative distribution.\u00a0Replaces NORMINV<\/td>\n<\/tr>\n<tr>\n<td>NORM.S.DIST<\/td>\n<td>Returns the standard normal cumulative distribution.\u00a0Replaces NormSdist<\/td>\n<\/tr>\n<tr>\n<td>NORM.S.INV<\/td>\n<td>Returns the inverse of the standard normal cumulative distribution.\u00a0Replaces norminv<\/td>\n<\/tr>\n<tr>\n<td>PERCENTILE.EXC<\/td>\n<td>Returns KTHentel values \u200b\u200bof values \u200b\u200bin the range, where K is in the range 0..1, exclusive.<\/td>\n<\/tr>\n<tr>\n<td>PERCENTILE.INC<\/td>\n<td>KTHERENTILE VALUES In an array of numbers.\u00a0Replaces percentiles<\/td>\n<\/tr>\n<tr>\n<td>PERCENTRANK.EXC<\/td>\n<td>Returns the rank of the values \u200b\u200bin the data set as a percentage (0..1, exclusive) of the data set.<\/td>\n<\/tr>\n<tr>\n<td>PERCENTRANK.INC<\/td>\n<td>Returns the rank of the values \u200b\u200bin the data set as a percentage of the data set.\u00a0Replaces the percentile<\/td>\n<\/tr>\n<tr>\n<td>POISSON.DIST<\/td>\n<td>Returns the poisson distribution.\u00a0Replaces Poisson<\/td>\n<\/tr>\n<tr>\n<td>QUARTILE.EXC<\/td>\n<td>Returns the quartile of a data set, based on percentages of values \u200b\u200bfrom 0..1, exclusively.<\/td>\n<\/tr>\n<tr>\n<td>QUARTILE.INC<\/td>\n<td>Returns the quartile of the data set.\u00a0Replaces quartiles<\/td>\n<\/tr>\n<tr>\n<td>RANK.AVG<\/td>\n<td>Returns the rank of a number in a list of numbers: size relative to other values \u200b\u200bin the list;\u00a0If more than one value has the same rank, the average rank is returned.<\/td>\n<\/tr>\n<tr>\n<td>RANK.EQ<\/td>\n<td>Returns the rank of a number in a list of numbers.\u00a0Replaces rank<\/td>\n<\/tr>\n<tr>\n<td>STDEV.P<\/td>\n<td>Returns the standard deviation based on the entire population.\u00a0Replaces stdevp<\/td>\n<\/tr>\n<tr>\n<td>STDEV.S<\/td>\n<td>Returns the standard deviation based on the sample.\u00a0Replaces stdev<\/td>\n<\/tr>\n<tr>\n<td>T.DIST<\/td>\n<td>Returns the percentage points (probability) for the student&#8217;s T-distribution.<\/td>\n<\/tr>\n<tr>\n<td>T.DIST.2T<\/td>\n<td>Returns the two-way student T-distribution.\u00a0Replaces tdist<\/td>\n<\/tr>\n<tr>\n<td>T.DIST.RT<\/td>\n<td>Returns the right-solved Student&#8217;s t-distribution.\u00a0Replaces tdist<\/td>\n<\/tr>\n<tr>\n<td>T.INV<\/td>\n<td>Returns the T value of the Student&#8217;s T-distribution as a function of probability and degrees of freedom.<\/td>\n<\/tr>\n<tr>\n<td>T.INV.2T<\/td>\n<td>Returns the T value of the Student&#8217;s T-distribution as a function of probability and degrees of freedom.\u00a0Replaces Tinv<\/td>\n<\/tr>\n<tr>\n<td>T.TEST<\/td>\n<td>Returns the probability value from the T distribution.\u00a0Replaces ttest<\/td>\n<\/tr>\n<tr>\n<td>YES.P<\/td>\n<td>Returns the variance based on the entire population.\u00a0Replaces Warp<\/td>\n<\/tr>\n<tr>\n<td>WHOSE<\/td>\n<td>Returns the variance based on the sample.\u00a0Replaces var<\/td>\n<\/tr>\n<tr>\n<td>WEIBULL.DIST<\/td>\n<td>Returns the Veibull distribution.\u00a0Replaces veibull<\/td>\n<\/tr>\n<tr>\n<td>WORKDAY.INTL<\/td>\n<td>Returns a serial number that is the given number of days before or after the date.\u00a0It replaces the working day<\/td>\n<\/tr>\n<tr>\n<td>Z.TEST<\/td>\n<td>Returns a probability value from a normal distribution.\u00a0Replaces Ztest<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_2013\"><\/span><span id=\"Formule_dodate_u_Excel_2013\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 2013<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr>\n<td>ACOT<\/td>\n<td>Returns the arc-cotangent of a number.<\/td>\n<\/tr>\n<tr>\n<td>ACOTH<\/td>\n<td>Returns the hyperbolic ARC-Cotangent of a number.<\/td>\n<\/tr>\n<tr>\n<td>ARABIC<\/td>\n<td>Returns a number converted from Roman to Arabic.<\/td>\n<\/tr>\n<tr>\n<td>BASE<\/td>\n<td>Returns the number converted to text representation with the given base.<\/td>\n<\/tr>\n<tr>\n<td>BINOM.DIST.RANGE<\/td>\n<td>Returns the probability of the outcome of the trial using the binomial distribution.<\/td>\n<\/tr>\n<tr>\n<td>BITAND<\/td>\n<td>Returns a point and two numbers.<\/td>\n<\/tr>\n<tr>\n<td>BITLSHIFT<\/td>\n<td>Returns the number of the shifted left bit number.<\/td>\n<\/tr>\n<tr>\n<td>BITOR<\/td>\n<td>Returns a white number or two.<\/td>\n<\/tr>\n<tr>\n<td>BITRSHIFT<\/td>\n<td>Returns the number of shifted fair number of bits.<\/td>\n<\/tr>\n<tr>\n<td>BITXOR<\/td>\n<td>Returns a navivo exclusive score or two numbers.<\/td>\n<\/tr>\n<tr>\n<td>CEILING.MATH<\/td>\n<td>Returns a number rounded to the nearest integer or to the nearest significant figure.<\/td>\n<\/tr>\n<tr>\n<td>COMBINA<\/td>\n<td>Returns the number of combinations with repetitions for the specified number of items.<\/td>\n<\/tr>\n<tr>\n<td>COT<\/td>\n<td>Returns the hyperbolic cosine of a number.<\/td>\n<\/tr>\n<tr>\n<td>COTH<\/td>\n<td>Returns the cotangent angle.<\/td>\n<\/tr>\n<tr>\n<td>CSC<\/td>\n<td>Returns the cosecant of the angles.<\/td>\n<\/tr>\n<tr>\n<td>CSCH<\/td>\n<td>Returns the hyperbolic parent angle.<\/td>\n<\/tr>\n<tr>\n<td>DAYS<\/td>\n<td>Returns the number of days between two dates.<\/td>\n<\/tr>\n<tr>\n<td>DECIMAL<\/td>\n<td>Returns the decimal number of the textual representation of a number in the specified base.<\/td>\n<\/tr>\n<tr>\n<td>ENCODEURL<\/td>\n<td>Returns a url encoded string.<\/td>\n<\/tr>\n<tr>\n<td>FILTERXML<\/td>\n<td>Returns special data from XML content using KSPATH.<\/td>\n<\/tr>\n<tr>\n<td>FLOOR.MATH<\/td>\n<td>Returns the number rounded to the nearest whole number in the given base to a decimal number.<\/td>\n<\/tr>\n<tr>\n<td>FORMULATEXT<\/td>\n<td>Returns the formula from the specified cell.<\/td>\n<\/tr>\n<tr>\n<td>GAMMA<\/td>\n<td>Returns the value of the gamma function.<\/td>\n<\/tr>\n<tr>\n<td>GAUSS<\/td>\n<td>Returns 0.5 less than the standard normal cumulative distribution.<\/td>\n<\/tr>\n<tr>\n<td>IFNA<\/td>\n<td>Returns a boolean value depending on whether the value is # n \/ a.<\/td>\n<\/tr>\n<tr>\n<td>IMCOSH<\/td>\n<td>Returns the hyperbolic cosine of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMCOT<\/td>\n<td>Returns the cotangent of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMCSC<\/td>\n<td>Returns the cosecant of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMCSCH<\/td>\n<td>Returns the hyperbolic plane of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMSEC<\/td>\n<td>Returns a complex number of sessions.<\/td>\n<\/tr>\n<tr>\n<td>IMSECH<\/td>\n<td>Returns the hyperbolic sleeper of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMSINH<\/td>\n<td>Returns the hyperbolic sine of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>IMTAN<\/td>\n<td>Returns the tangent of a complex number.<\/td>\n<\/tr>\n<tr>\n<td>ISFORMULA<\/td>\n<td>Returns a boolean value depending on whether the cell contains a formula.<\/td>\n<\/tr>\n<tr>\n<td>ISOWEEKNUM<\/td>\n<td>Returns the ISO week number of the year for the date.<\/td>\n<\/tr>\n<tr>\n<td>FORTIFIES<\/td>\n<td>Returns the unit matrix or the specified dimension.<\/td>\n<\/tr>\n<tr>\n<td>NUMBERVALUE<\/td>\n<td>Returns text to number in local independent mode.<\/td>\n<\/tr>\n<tr>\n<td>PDURATION<\/td>\n<td>Returns the number of periods required for an investment to reach a specified value.<\/td>\n<\/tr>\n<tr>\n<td>PERMUTATIONA<\/td>\n<td>Returns the number of permutations for a subset of objects or events (with repetition).<\/td>\n<\/tr>\n<tr>\n<td>PHI<\/td>\n<td>Returns the value of the density function for the standard normal distribution.<\/td>\n<\/tr>\n<tr>\n<td>RRI<\/td>\n<td>Returns the equivalent interest rate for investment growth.<\/td>\n<\/tr>\n<tr>\n<td>SEC<\/td>\n<td>Returns session angle.<\/td>\n<\/tr>\n<tr>\n<td>SECH<\/td>\n<td>Returns the hyperbolic moon angle.<\/td>\n<\/tr>\n<tr>\n<td>SHEET<\/td>\n<td>Returns the sheet number of the referenced sheet.<\/td>\n<\/tr>\n<tr>\n<td>SHEETS<\/td>\n<td>Returns the number of sheets in the reference.<\/td>\n<\/tr>\n<tr>\n<td>SKEW.P<\/td>\n<td>Returns the skewness of a population-based distribution.<\/td>\n<\/tr>\n<tr>\n<td>UNICHAR<\/td>\n<td>Returns a copy of the Unicode reference of the passed numeric value.<\/td>\n<\/tr>\n<tr>\n<td>UNICODE<\/td>\n<td>Returns the number corresponding to the first character of the text.<\/td>\n<\/tr>\n<tr>\n<td>WEBSERVICE<\/td>\n<td>Returns data from VebErvice.<\/td>\n<\/tr>\n<tr>\n<td>XOR<\/td>\n<td>Returns boolean exclusive or any number of arguments.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_2016\"><\/span><span id=\"Formule_dodate_u_Excel_2016\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr>\n<td>FORECAST.ETS<\/td>\n<td>Returns a future value based on historical values.<\/td>\n<\/tr>\n<tr>\n<td>FORECAST.ETS.CONFINT<\/td>\n<td>Returns the confidence interval for the future value.<\/td>\n<\/tr>\n<tr>\n<td>FORECAST.ETS.SEASONALITY<\/td>\n<td>Returns the pattern length of a recurring seasonal pattern.<\/td>\n<\/tr>\n<tr>\n<td>FORECAST.ETS.STAT<\/td>\n<td>Returns a statistical value for the future value.<\/td>\n<\/tr>\n<tr>\n<td>FORECAST.LINEAR<\/td>\n<td>Returns a future value and a value based on existing values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_2019\"><\/span><span id=\"Formule_dodate_u_Excel_2019\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 2019<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr>\n<td>CONCAT<\/td>\n<td>Returns a text string that is a concatenation of several strings.\u00a0It replaces the contract<\/td>\n<\/tr>\n<tr>\n<td>IFS<\/td>\n<td>Returns a value based on multiple conditions that you specify.<\/td>\n<\/tr>\n<tr>\n<td>MAXIFS<\/td>\n<td>Returns the largest value in a list or array of numbers that satisfies multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td>MINIFS<\/td>\n<td>Returns the smallest value in a list or array of numbers that satisfy multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td>SWITCH<\/td>\n<td>Returns a value based on a list of matching items.<\/td>\n<\/tr>\n<tr>\n<td>TEXTJOIN<\/td>\n<td>Returns a text string that is a concatenation of several strings.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_2021\"><\/span><span id=\"Formule_dodate_u_Excel_2021\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 2021<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/22\/filter-formula-filtrira\/\">FILTER<\/a><\/td>\n<td>Returns an array of data in a range that satisfies multiple conditions.<\/td>\n<\/tr>\n<tr>\n<td>LET<\/td>\n<td>Returns the result of a formula that can use variables.<\/td>\n<\/tr>\n<tr>\n<td>RANDARRAY<\/td>\n<td>Returns an array of random numbers between 0 and 1.<\/td>\n<\/tr>\n<tr>\n<td>SEQUENCE<\/td>\n<td>Returns an array of sequential numbers.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/21\/sort\/\">SORT<\/a><\/td>\n<td>Returns an array of data in a range that is sorted.<\/td>\n<\/tr>\n<tr>\n<td>SORTBY<\/td>\n<td>Returns an array of data in a range sorted by the values \u200b\u200bin the corresponding range.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/kalkulacija.com\/wordpress\/2021\/12\/20\/unique-vraca-niz-jedinstvenih-vrednosti-na-listi\/\">UNIQUE<\/a><\/td>\n<td>Returns an array of unique values \u200b\u200bin a list, table, or cell range.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"http:\/\/xlookup\/\">XLOOKUP<\/a><\/td>\n<td>Returns the value in the same row after finding a matching value in any column.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/kalkulacija.com\/wordpress\/2022\/01\/08\/xmatch-formula-daje-redni-broj\/\">XMATCH<\/a><\/td>\n<td>Returns the position of a value in a list, table, or cell range.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Formulas_added_to_Excel_365\"><\/span><span id=\"Formule_dodate_u_Excel_365\" class=\"ez-toc-section\"><\/span>Formulas added to Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table border=\"1\" frame=\"hsides\" rules=\"rows\">\n<tbody style=\"border-top: 1px solid black; padding-top: 0px; padding-bottom: 0px; font-size: 10pt;\">\n<tr>\n<td>FIELDVALUE<\/td>\n<td>(2020) Returns the field data from a Stocks or Geography linked data type.<\/td>\n<\/tr>\n<tr>\n<td>LAMBDA<\/td>\n<td>(2020) Returns the results of a formula added as a named range.<\/td>\n<\/tr>\n<tr>\n<td>STOCKHISTORY<\/td>\n<td>(2020) Returns the historical data about a financial instrument.<\/td>\n<\/tr>\n<tr>\n<td>ARRAYTOTEXT<\/td>\n<td>(2021) Returns the contents of an array or cell range converted into text.<\/td>\n<\/tr>\n<tr>\n<td>BYCOL<\/td>\n<td>(2021) Returns the results from applying a LAMBDA function to each column in an array.<\/td>\n<\/tr>\n<tr>\n<td>BYROW<\/td>\n<td>(2021) Returns the results from applying a LAMBDA function to each row in an array.<\/td>\n<\/tr>\n<tr>\n<td>ISOMITTED<\/td>\n<td>(2021) Returns the value True or False depending whether the value in a LAMBDA is missing.<\/td>\n<\/tr>\n<tr>\n<td>MAKEARRAY<\/td>\n<td>(2021) Returns the array calculated by applying a LAMBDA function.<\/td>\n<\/tr>\n<tr>\n<td>MAP<\/td>\n<td>(2021) Returns the array formed by applying a map using a LAMBDA function.<\/td>\n<\/tr>\n<tr>\n<td>REDUCE<\/td>\n<td>(2021) Returns the total value after reducing an array by applying a LAMBDA function.<\/td>\n<\/tr>\n<tr>\n<td>SCAN<\/td>\n<td>(2021) Returns the array after applying a LAMBDA function to each value and returns an array.<\/td>\n<\/tr>\n<tr>\n<td>VALUETOTEXT<\/td>\n<td>(2021) Returns the text from any specified value.<\/td>\n<\/tr>\n<tr>\n<td>CHOOSECOLS<\/td>\n<td>(2022) Returns the array with just a specific number of columns.<\/td>\n<\/tr>\n<tr>\n<td>CHOOSEROWS<\/td>\n<td>(2022) Returns the array with just a specific number of rows.<\/td>\n<\/tr>\n<tr>\n<td>DROP<\/td>\n<td>(2022) Returns the array without certain rows or columns.<\/td>\n<\/tr>\n<tr>\n<td>EXPAND<\/td>\n<td>(2022) Returns the array expanded or padded to specific dimensions.<\/td>\n<\/tr>\n<tr>\n<td>HSTACK<\/td>\n<td>(2022) Returns the array after combining two arrays horizontally in sequence.<\/td>\n<\/tr>\n<tr>\n<td>IMAGE<\/td>\n<td>(2022) Returns the image from a web URL.<\/td>\n<\/tr>\n<tr>\n<td>TAKE<\/td>\n<td>(2022) Returns the intersection of specific rows and columns in an array.<\/td>\n<\/tr>\n<tr>\n<td>TEXTAFTER<\/td>\n<td>(2022) Returns the characters from the end of a text string after a delimiter.<\/td>\n<\/tr>\n<tr>\n<td>TEXTBEFORE<\/td>\n<td>(2022) Returns the characters from the start of a text string before a delimiter.<\/td>\n<\/tr>\n<tr>\n<td>TEXTSPLIT<\/td>\n<td>(2022) Returns the text string split into multiple columns using delimiters.<\/td>\n<\/tr>\n<tr>\n<td>TOCOL<\/td>\n<td>(2022) Returns the array transformed into a single column.<\/td>\n<\/tr>\n<tr>\n<td>TOROW<\/td>\n<td>(2022) Returns the array transformed into a single row.<\/td>\n<\/tr>\n<tr>\n<td>VSTACK<\/td>\n<td>(2022) Returns the array after combining two arrays vertically in sequence.<\/td>\n<\/tr>\n<tr>\n<td>WRAPCOLS<\/td>\n<td>(2022) Returns the array transformed into multiple columns.<\/td>\n<\/tr>\n<tr>\n<td>WRAPROWS<\/td>\n<td>(2022) Returns array transformed into multiple rows.<\/td>\n<\/tr>\n<tr>\n<td>GROUPBY<\/td>\n<td>(2023) Returns the grouping of your data along one axis and aggregates the associated values.<\/td>\n<\/tr>\n<tr>\n<td>PIVOTBY<\/td>\n<td>(2023) Returns the grouping of your data along two axis and aggregates the associated values.<\/td>\n<\/tr>\n<tr>\n<td>PY<\/td>\n<td>(2023) Returns the value or object after running code in a Python Editor.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h1><\/h1>\n[:]\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;2201&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;4&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 - (4 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Istorijat dodavanja funkcija u Excelu[:en]History of adding Functions into Excel[:]&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 - (4 votes)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr] Istorijat dodavanja funkcija u Excelu Funkcije radnog lista su kategorizovane po njihovoj funkcionalnosti. Kliknite na kategoriju da biste pregledali<\/p>\n","protected":false},"author":1,"featured_media":2139,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Istorijat dodavanja formula u Excelu<\/title>\n<meta name=\"description\" content=\"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.\" \/>\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\/istorijat-dodavanja-formula-u-excelu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Istorijat dodavanja formula u Excelu\" \/>\n<meta property=\"og:description\" content=\"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-27T12:21:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-27T12:40:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\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=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]Istorijat dodavanja funkcija u Excelu[:en]History of adding Functions into Excel[:]\",\"datePublished\":\"2024-08-27T12:21:36+00:00\",\"dateModified\":\"2024-08-27T12:40:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/\"},\"wordCount\":4380,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-2-icon.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/\",\"name\":\"Istorijat dodavanja formula u Excelu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-2-icon.png\",\"datePublished\":\"2024-08-27T12:21:36+00:00\",\"dateModified\":\"2024-08-27T12:40:28+00:00\",\"description\":\"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-2-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-2-icon.png\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorijat-dodavanja-formula-u-excelu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Istorijat dodavanja 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":"Istorijat dodavanja formula u Excelu","description":"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.","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\/istorijat-dodavanja-formula-u-excelu\/","og_locale":"en_US","og_type":"article","og_title":"Istorijat dodavanja formula u Excelu","og_description":"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.","og_url":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2024-08-27T12:21:36+00:00","article_modified_time":"2024-08-27T12:40:28+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]Istorijat dodavanja funkcija u Excelu[:en]History of adding Functions into Excel[:]","datePublished":"2024-08-27T12:21:36+00:00","dateModified":"2024-08-27T12:40:28+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/"},"wordCount":4380,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png","articleSection":["Poslovni Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/","url":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/","name":"Istorijat dodavanja formula u Excelu","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png","datePublished":"2024-08-27T12:21:36+00:00","dateModified":"2024-08-27T12:40:28+00:00","description":"Istorijat dodavanja formula u Excelu pokazuje kako je Microsoft uva\u017eavao potrebe korisnika. Najve\u0107i napredak se dogodio od 2019 do danas.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-2-icon.png","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Istorijat dodavanja 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\/2201","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=2201"}],"version-history":[{"count":84,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2201\/revisions"}],"predecessor-version":[{"id":3818,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/2201\/revisions\/3818"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/2139"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}