{"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\/en\/istorijat-dodavanja-formula-u-excelu\/","title":{"rendered":"History of adding Functions into Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/istorijat-dodavanja-formula-u-excelu\/#Formulas_added_to_Excel_365\" >Formulas added to Excel 365<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\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 id=\"Excel_2007\" class=\"ez-toc-section\"><\/span><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>\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;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;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>","protected":false},"excerpt":{"rendered":"<p>History of adding formulas in Excel Worksheet functions are categorized by their functionality.\u00a0Click on a category to view its features.\u00a0Or<\/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 v27.5 - 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=\"Calculation in essence of everything!\" \/>\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\":\"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\":[\"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\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"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":"Calculation in essence of everything!","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":"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":["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":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/2201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=2201"}],"version-history":[{"count":84,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/2201\/revisions"}],"predecessor-version":[{"id":3818,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/2201\/revisions\/3818"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/2139"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=2201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=2201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=2201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}