formula with detailed description Type and Version supported
| SL# | Function Name | Type and Description | Office Version |
|---|---|---|---|
| 1 | CALL function | Calls a procedure in a dynamic link library or code resource | 2007,2010,2013, Office 365 |
| 2 | EUROCONVERT function | Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). | 2007,2010,2013, Office 365 |
| 3 | REGISTER.ID function | Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered | 2007,2010,2013, Office 365 |
| 4 | BETADIST function | Returns the beta cumulative distribution functionIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 5 | BETAINV function | Returns the inverse of the cumulative distribution function for a specified beta distributionIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 6 | BINOMDIST function | Returns the individual term binomial distribution probabilityIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 7 | CHIDIST function | Returns the one-tailed probability of the chi-squared distributionNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 8 | CHIINV function | Returns the inverse of the one-tailed probability of the chi-squared distributionNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 9 | CHITEST function | Returns the test for independenceNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 10 | CONFIDENCE function | Returns the confidence interval for a population meanIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 11 | COVAR function | Returns covariance, the average of the products of paired deviationsIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 12 | CRITBINOM function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion valueIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 13 | EXPONDIST function | Returns the exponential distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 14 | FDIST function | Returns the F probability distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 15 | FLOOR function | Rounds a number down, toward zeroIn Excel 2007 and Excel 2010, this is a Math and trigonometry function. | Excel 2007,2010,2013, Office 365 |
| 16 | FTEST function | Returns the result of an F-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 17 | GAMMADIST function | Returns the gamma distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 18 | GAMMAINV function | Returns the inverse of the gamma cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 19 | HYPGEOMDIST function | Returns the hypergeometric distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 20 | LOGINV function | Returns the inverse of the lognormal cumulative distribution | Excel 2007,2010,2013, Office 365 |
| 21 | LOGNORMDIST function | Returns the cumulative lognormal distribution | Excel 2007,2010,2013, Office 365 |
| 22 | MODE function | Returns the most common value in a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 23 | NEGBINOMDIST function | Returns the negative binomial distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 24 | NORM.INV function | Returns the inverse of the normal cumulative distribution Note: In Excel 2007, this is a Statistical function. | Excel 2010, 2013, office 365 |
| 25 | NORMDIST function | Returns the normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 26 | NORMSDIST function | Returns the standard normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 27 | NORMSINV function | Returns the inverse of the standard normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 28 | PERCENTILE function | Returns the k-th percentile of values in a rangeIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 29 | PERCENTRANK function | Returns the percentage rank of a value in a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 30 | POISSON function | Returns the Poisson distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 31 | QUARTILE function | Returns the quartile of a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 32 | RANK function | Returns the rank of a number in a list of numbersIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 33 | STDEV function | Estimates standard deviation based on a sample | Excel 2007,2010,2013, Office 365 |
| 34 | STDEVP function | Calculates standard deviation based on the entire populationIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 35 | TDIST function | Returns the Student's t-distribution | Excel 2007,2010,2013, Office 365 |
| 36 | TINV function | Returns the inverse of the Student's t-distribution | Excel 2007,2010,2013, Office 365 |
| 37 | TTEST function | Returns the probability associated with a Student's t-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 38 | VAR function | Estimates variance based on a sampleIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 39 | VARP function | Calculates variance based on the entire populationIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 40 | WEIBULL function | Calculates variance based on the entire population, including numbers, text, and logical valuesIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 41 | ZTEST function | Returns the one-tailed probability-value of a z-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 42 | CUBEKPIMEMBER function | Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. | Excel 2007,2010,2013, Office 365 |
| 43 | CUBEMEMBER function | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. | Excel 2007,2010,2013, Office 365 |
| 44 | CUBEMEMBERPROPERTY function | Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. | Excel 2007,2010,2013, Office 365 |
| 45 | CUBERANKEDMEMBER function | Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. | Excel 2007,2010,2013, Office 365 |
| 46 | CUBESET function | Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. | Excel 2007,2010,2013, Office 365 |
| 47 | CUBESETCOUNT function | Returns the number of items in a set. | Excel 2007,2010,2013, Office 365 |
| 48 | CUBEVALUE function | Returns an aggregated value from a cube. | Excel 2007,2010,2013, Office 365 |
| 49 | DAVERAGE function | Returns the average of selected database entries | Excel 2007,2010,2013, Office 365 |
| 50 | DCOUNT function | Counts the cells that contain numbers in a database | Excel 2007,2010,2013, Office 365 |
| 51 | DCOUNTA function | Counts nonblank cells in a database | Excel 2007,2010,2013, Office 365 |
| 52 | DGET function | Extracts from a database a single record that matches the specified criteria | Excel 2007,2010,2013, Office 365 |
| 53 | DMAX function | Returns the maximum value from selected database entries | Excel 2007,2010,2013, Office 365 |
| 54 | DMIN function | Returns the minimum value from selected database entries | Excel 2007,2010,2013, Office 365 |
| 55 | DPRODUCT function | Multiplies the values in a particular field of records that match the criteria in a database | Excel 2007,2010,2013, Office 365 |
| 56 | DSTDEV function | Estimates the standard deviation based on a sample of selected database entries | Excel 2007,2010,2013, Office 365 |
| 57 | DSTDEVP function | Calculates the standard deviation based on the entire population of selected database entries | Excel 2007,2010,2013, Office 365 |
| 58 | DSUM function | Adds the numbers in the field column of records in the database that match the criteria | Excel 2007,2010,2013, Office 365 |
| 59 | DVAR function | Estimates variance based on a sample from selected database entries | Excel 2007,2010,2013, Office 365 |
| 60 | DVARP function | Calculates variance based on the entire population of selected database entries | Excel 2007,2010,2013, Office 365 |
| 61 | DATE function | Returns the serial number of a particular date | Excel 2007,2010,2013, Office 365 |
| 62 | DATEDIF function | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. | Excel 2007,2010,2013, Office 365 |
| 63 | DATEVALUE function | Converts a date in the form of text to a serial number | Excel 2007,2010,2013, Office 365 |
| 64 | DAY function | Converts a serial number to a day of the month | Excel 2007,2010,2013, Office 365 |
| 65 | DAYS function | Returns the number of days between two dates | Excel 2013, Office 365 |
| 66 | DAYS360 function | Calculates the number of days between two dates based on a 360-day year | Excel 2007,2010,2013, Office 365 |
| 67 | EDATE function | Returns the serial number of the date that is the indicated number of months before or after the start date | Excel 2007,2010,2013, Office 365 |
| 68 | EOMONTH function | Returns the serial number of the last day of the month before or after a specified number of months | Excel 2007,2010,2013, Office 365 |
| 69 | HOUR function | Converts a serial number to an hour | Excel 2007,2010,2013, Office 365 |
| 70 | ISOWEEKNUM function | Returns the number of the ISO week number of the year for a given date | Excel 2013, Office 365 |
| 71 | MINUTE function | Converts a serial number to a minute | Excel 2007,2010,2013, Office 365 |
| 72 | MONTH function | Converts a serial number to a month | Excel 2007,2010,2013, Office 365 |
| 73 | NETWORKDAYS function | Returns the number of whole workdays between two dates | Excel 2007,2010,2013, Office 365 |
| 74 | NETWORKDAYS.INTL function | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days | Excel 2010, 2013, office 365 |
| 75 | NOW function | Returns the serial number of the current date and time | Excel 2007,2010,2013, Office 365 |
| 76 | SECOND function | Converts a serial number to a second | Excel 2007,2010,2013, Office 365 |
| 77 | TIME function | Returns the serial number of a particular time | Excel 2007,2010,2013, Office 365 |
| 78 | TIMEVALUE function | Converts a time in the form of text to a serial number | Excel 2007,2010,2013, Office 365 |
| 79 | TODAY function | Returns the serial number of today's date | Excel 2007,2010,2013, Office 365 |
| 80 | WEEKDAY function | Converts a serial number to a day of the week | Excel 2007,2010,2013, Office 365 |
| 81 | WEEKNUM function | Converts a serial number to a number representing where the week falls numerically with a year | Excel 2007,2010,2013, Office 365 |
| 82 | WORKDAY function | Returns the serial number of the date before or after a specified number of workdays | Excel 2007,2010,2013, Office 365 |
| 83 | WORKDAY.INTL function | Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days | Excel 2010, 2013, office 365 |
| 84 | YEAR function | Converts a serial number to a year | Excel 2007,2010,2013, Office 365 |
| 85 | YEARFRAC function | Returns the year fraction representing the number of whole days between start_date and end_date | Excel 2007,2010,2013, Office 365 |
| 86 | BESSELI function | Returns the modified Bessel function In(x) | Excel 2007,2010,2013, Office 365 |
| 87 | BESSELJ function | Returns the Bessel function Jn(x) | Excel 2007,2010,2013, Office 365 |
| 88 | BESSELK function | Returns the modified Bessel function Kn(x) | Excel 2007,2010,2013, Office 365 |
| 89 | BESSELY function | Returns the Bessel function Yn(x) | Excel 2007,2010,2013, Office 365 |
| 90 | BIN2DEC function | Converts a binary number to decimal | Excel 2007,2010,2013, Office 365 |
| 91 | BIN2HEX function | Converts a binary number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 92 | BIN2OCT function | Converts a binary number to octal | Excel 2007,2010,2013, Office 365 |
| 93 | BITAND function | Returns a 'Bitwise And' of two numbers | Excel 2013, Office 365 |
| 94 | BITLSHIFT function | Returns a value number shifted left by shift_amount bits | Excel 2013, Office 365 |
| 95 | BITOR function | Returns a bitwise OR of 2 numbers | Excel 2013, Office 365 |
| 96 | BITRSHIFT function | Returns a value number shifted right by shift_amount bits | Excel 2013, Office 365 |
| 97 | BITXOR function | Returns a bitwise 'Exclusive Or' of two numbers | Excel 2013, Office 365 |
| 98 | COMPLEX function | Converts real and imaginary coefficients into a complex number | Excel 2007,2010,2013, Office 365 |
| 99 | CONVERT function | Converts a number from one measurement system to another | Excel 2007,2010,2013, Office 365 |
| 100 | DEC2BIN function | Converts a decimal number to binary | Excel 2007,2010,2013, Office 365 |
| 101 | DEC2HEX function | Converts a decimal number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 102 | DEC2OCT function | Converts a decimal number to octal | Excel 2007,2010,2013, Office 365 |
| 103 | DELTA function | Tests whether two values are equal | Excel 2007,2010,2013, Office 365 |
| 104 | ERF function | Returns the error function | Excel 2007,2010,2013, Office 365 |
| 105 | ERF.PRECISE function | Returns the error function | Excel 2010, 2013, office 365 |
| 106 | ERFC function | Returns the complementary error function | Excel 2007,2010,2013, Office 365 |
| 107 | ERFC.PRECISE function | Returns the complementary ERF function integrated between x and infinity | Excel 2010, 2013, office 365 |
| 108 | GESTEP function | Tests whether a number is greater than a threshold value | Excel 2007,2010,2013, Office 365 |
| 109 | HEX2BIN function | Converts a hexadecimal number to binary | Excel 2007,2010,2013, Office 365 |
| 110 | HEX2DEC function | Converts a hexadecimal number to decimal | Excel 2007,2010,2013, Office 365 |
| 111 | HEX2OCT function | Converts a hexadecimal number to octal | Excel 2007,2010,2013, Office 365 |
| 112 | IMABS function | Returns the absolute value (modulus) of a complex number | Excel 2007,2010,2013, Office 365 |
| 113 | IMAGINARY function | Returns the imaginary coefficient of a complex number | Excel 2007,2010,2013, Office 365 |
| 114 | IMARGUMENT function | Returns the argument theta, an angle expressed in radians | Excel 2007,2010,2013, Office 365 |
| 115 | IMCONJUGATE function | Returns the complex conjugate of a complex number | Excel 2007,2010,2013, Office 365 |
| 116 | IMCOS function | Returns the cosine of a complex number | Excel 2007,2010,2013, Office 365 |
| 117 | IMCOSH function | Returns the hyperbolic cosine of a complex number | Excel 2013, Office 365 |
| 118 | IMCOT function | Returns the cotangent of a complex number | Excel 2013, Office 365 |
| 119 | IMCSC function | Returns the cosecant of a complex number | Excel 2013, Office 365 |
| 120 | IMCSCH function | Returns the hyperbolic cosecant of a complex number | Excel 2013, Office 365 |
| 121 | IMDIV function | Returns the quotient of two complex numbers | Excel 2007,2010,2013, Office 365 |
| 122 | IMEXP function | Returns the exponential of a complex number | Excel 2007,2010,2013, Office 365 |
| 123 | IMLN function | Returns the natural logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 124 | IMLOG10 function | Returns the base-10 logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 125 | IMLOG2 function | Returns the base-2 logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 126 | IMPOWER function | Returns a complex number raised to an integer power | Excel 2007,2010,2013, Office 365 |
| 127 | IMPRODUCT function | Returns the product of complex numbers | Excel 2007,2010,2013, Office 365 |
| 128 | IMREAL function | Returns the real coefficient of a complex number | Excel 2007,2010,2013, Office 365 |
| 129 | IMSEC function | Returns the secant of a complex number | Excel 2013, Office 365 |
| 130 | IMSECH function | Returns the hyperbolic secant of a complex number | Excel 2013, Office 365 |
| 131 | IMSIN function | Returns the sine of a complex number | Excel 2007,2010,2013, Office 365 |
| 132 | IMSINH function | Returns the hyperbolic sine of a complex number | Excel 2013, Office 365 |
| 133 | IMSQRT function | Returns the square root of a complex number | Excel 2007,2010,2013, Office 365 |
| 134 | IMSUB function | Returns the difference between two complex numbers | Excel 2007,2010,2013, Office 365 |
| 135 | IMSUM function | Returns the sum of complex numbers | Excel 2007,2010,2013, Office 365 |
| 136 | IMTAN function | Returns the tangent of a complex number | Excel 2013, Office 365 |
| 137 | OCT2BIN function | Converts an octal number to binary | Excel 2007,2010,2013, Office 365 |
| 138 | OCT2DEC function | Converts an octal number to decimal | Excel 2007,2010,2013, Office 365 |
| 139 | OCT2HEX function | Converts an octal number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 140 | ACCRINT function | Returns the accrued interest for a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 141 | ACCRINTM function | Returns the accrued interest for a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 142 | AMORDEGRC function | Returns the depreciation for each accounting period by using a depreciation coefficient | Excel 2007,2010,2013, Office 365 |
| 143 | AMORLINC function | Returns the depreciation for each accounting period | Excel 2007,2010,2013, Office 365 |
| 144 | COUPDAYBS function | Returns the number of days from the beginning of the coupon period to the settlement date | Excel 2007,2010,2013, Office 365 |
| 145 | COUPDAYS function | Returns the number of days in the coupon period that contains the settlement date | Excel 2007,2010,2013, Office 365 |
| 146 | COUPDAYSNC function | Returns the number of days from the settlement date to the next coupon date | Excel 2007,2010,2013, Office 365 |
| 147 | COUPNCD function | Returns the next coupon date after the settlement date | Excel 2007,2010,2013, Office 365 |
| 148 | COUPNUM function | Returns the number of coupons payable between the settlement date and maturity date | Excel 2007,2010,2013, Office 365 |
| 149 | COUPPCD function | Returns the previous coupon date before the settlement date | Excel 2007,2010,2013, Office 365 |
| 150 | CUMIPMT function | Returns the cumulative interest paid between two periods | Excel 2007,2010,2013, Office 365 |
| 151 | CUMPRINC function | Returns the cumulative principal paid on a loan between two periods | Excel 2007,2010,2013, Office 365 |
| 152 | DB function | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method | Excel 2007,2010,2013, Office 365 |
| 153 | DDB function | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify | Excel 2007,2010,2013, Office 365 |
| 154 | DISC function | Returns the discount rate for a security | Excel 2007,2010,2013, Office 365 |
| 155 | DOLLARDE function | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number | Excel 2007,2010,2013, Office 365 |
| 156 | DOLLARFR function | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction | Excel 2007,2010,2013, Office 365 |
| 157 | DURATION function | Returns the annual duration of a security with periodic interest payments | Excel 2007,2010,2013, Office 365 |
| 158 | EFFECT function | Returns the effective annual interest rate | Excel 2007,2010,2013, Office 365 |
| 159 | FV function | Returns the future value of an investment | Excel 2007,2010,2013, Office 365 |
| 160 | FVSCHEDULE function | Returns the future value of an initial principal after applying a series of compound interest rates | Excel 2007,2010,2013, Office 365 |
| 161 | INTRATE function | Returns the interest rate for a fully invested security | Excel 2007,2010,2013, Office 365 |
| 162 | IPMT function | Returns the interest payment for an investment for a given period | Excel 2007,2010,2013, Office 365 |
| 163 | IRR function | Returns the internal rate of return for a series of cash flows | Excel 2007,2010,2013, Office 365 |
| 164 | ISPMT function | Calculates the interest paid during a specific period of an investment | Excel 2007,2010,2013, Office 365 |
| 165 | MDURATION function | Returns the Macauley modified duration for a security with an assumed par value of $100 | Excel 2007,2010,2013, Office 365 |
| 166 | MIRR function | Returns the internal rate of return where positive and negative cash flows are financed at different rates | Excel 2007,2010,2013, Office 365 |
| 167 | NOMINAL function | Returns the annual nominal interest rate | Excel 2007,2010,2013, Office 365 |
| 168 | NPER function | Returns the number of periods for an investment | Excel 2007,2010,2013, Office 365 |
| 169 | NPV function | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate | Excel 2007,2010,2013, Office 365 |
| 170 | ODDFPRICE function | Returns the price per $100 face value of a security with an odd first period | Excel 2007,2010,2013, Office 365 |
| 171 | ODDFYIELD function | Returns the yield of a security with an odd first period | Excel 2007,2010,2013, Office 365 |
| 172 | ODDLPRICE function | Returns the price per $100 face value of a security with an odd last period | Excel 2007,2010,2013, Office 365 |
| 173 | ODDLYIELD function | Returns the yield of a security with an odd last period | Excel 2007,2010,2013, Office 365 |
| 174 | PDURATION function | Returns the number of periods required by an investment to reach a specified value | Excel 2013, Office 365 |
| 175 | PMT function | Returns the periodic payment for an annuity | Excel 2007,2010,2013, Office 365 |
| 176 | PPMT function | Returns the payment on the principal for an investment for a given period | Excel 2007,2010,2013, Office 365 |
| 177 | PRICE function | Returns the price per $100 face value of a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 178 | PRICEDISC function | Returns the price per $100 face value of a discounted security | Excel 2007,2010,2013, Office 365 |
| 179 | PRICEMAT function | Returns the price per $100 face value of a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 180 | PV function | Returns the present value of an investment | Excel 2007,2010,2013, Office 365 |
| 181 | RATE function | Returns the interest rate per period of an annuity | Excel 2007,2010,2013, Office 365 |
| 182 | RECEIVED function | Returns the amount received at maturity for a fully invested security | Excel 2007,2010,2013, Office 365 |
| 183 | RRI function | Returns an equivalent interest rate for the growth of an investment | Excel 2013, Office 365 |
| 184 | SLN function | Returns the straight-line depreciation of an asset for one period | Excel 2007,2010,2013, Office 365 |
| 185 | SYD function | Returns the sum-of-years' digits depreciation of an asset for a specified period | Excel 2007,2010,2013, Office 365 |
| 186 | TBILLEQ function | Returns the bond-equivalent yield for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 187 | TBILLPRICE function | Returns the price per $100 face value for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 188 | TBILLYIELD function | Returns the yield for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 189 | VDB function | Returns the depreciation of an asset for a specified or partial period by using a declining balance method | Excel 2007,2010,2013, Office 365 |
| 190 | XIRR function | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic | Excel 2007,2010,2013, Office 365 |
| 191 | XNPV function | Returns the net present value for a schedule of cash flows that is not necessarily periodic | Excel 2007,2010,2013, Office 365 |
| 192 | YIELD function | Returns the yield on a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 193 | YIELDDISC function | Returns the annual yield for a discounted security; for example, a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 194 | YIELDMAT function | Returns the annual yield of a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 195 | CELL function | Returns information about the formatting, location, or contents of a cell AND This function is not available in Excel for the web. | Excel 2007,2010,2013, Office 365 |
| 196 | ERROR.TYPE function | Returns a number corresponding to an error type | Excel 2007,2010,2013, Office 365 |
| 197 | INFO function | Returns information about the current operating environmentThis function is not available in Excel for the web. | Excel 2007,2010,2013, Office 365 |
| 198 | ISBLANK function | Returns TRUE if the value is blank | Excel 2007,2010,2013, Office 365 |
| 199 | ISERR function | Returns TRUE if the value is any error value except #N/A | Excel 2007,2010,2013, Office 365 |
| 200 | ISERROR function | Returns TRUE if the value is any error value | Excel 2007,2010,2013, Office 365 |
| 201 | ISEVEN function | Returns TRUE if the number is even | Excel 2007,2010,2013, Office 365 |
| 202 | ISFORMULA function | Returns TRUE if there is a reference to a cell that contains a formula | Excel 2013, Office 365 |
| 203 | ISLOGICAL function | Returns TRUE if the value is a logical value | Excel 2007,2010,2013, Office 365 |
| 204 | ISNA function | Returns TRUE if the value is the #N/A error value | Excel 2007,2010,2013, Office 365 |
| 205 | ISNONTEXT function | Returns TRUE if the value is not text | Excel 2007,2010,2013, Office 365 |
| 206 | ISNUMBER function | Returns TRUE if the value is a number | Excel 2007,2010,2013, Office 365 |
| 207 | ISODD function | Returns TRUE if the number is odd | Excel 2007,2010,2013, Office 365 |
| 208 | ISREF function | Returns TRUE if the value is a reference | Excel 2007,2010,2013, Office 365 |
| 209 | ISTEXT function | Returns TRUE if the value is text | Excel 2007,2010,2013, Office 365 |
| 210 | N function | Returns a value converted to a number | Excel 2007,2010,2013, Office 365 |
| 211 | NA function | Returns the error value #N/A | Excel 2007,2010,2013, Office 365 |
| 212 | SHEET function | Returns the sheet number of the referenced sheet | Excel 2013, Office 365 |
| 213 | SHEETS function | Returns the number of sheets in a reference | Excel 2013, Office 365 |
| 214 | TYPE function | Returns a number indicating the data type of a value | Excel 2007,2010,2013, Office 365 |
| 215 | AND function | Returns TRUE if all of its arguments are TRUE | Excel 2007,2010,2013, Office 365 |
| 216 | FALSE function | Returns the logical value FALSE | Excel 2007,2010,2013, Office 365 |
| 217 | IF function | Specifies a logical test to perform | Excel 2007,2010,2013, Office 365 |
| 218 | IFERROR function | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | Excel 2007,2010,2013, Office 365 |
| 219 | IFNA function | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression | Excel 2013, Office 365 |
| 220 | IFS function | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. | Excel 2007,2010,2013, Office 365 |
| 221 | NOT function | Reverses the logic of its argument | Excel 2007,2010,2013, Office 365 |
| 222 | OR function | Returns TRUE if any argument is TRUE | Excel 2007,2010,2013, Office 365 |
| 223 | SWITCH function | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. | Excel 2016 |
| 224 | TRUE function | Returns the logical value TRUE | Excel 2007,2010,2013, Office 365 |
| 225 | XOR function | Returns a logical exclusive OR of all arguments | Excel 2013, Office 365 |
| 226 | ADDRESS function | Returns a reference as text to a single cell in a worksheet | Excel 2007,2010,2013, Office 365 |
| 227 | AREAS function | Returns the number of areas in a reference | Excel 2007,2010,2013, Office 365 |
| 228 | CHOOSE function | Chooses a value from a list of values | Excel 2007,2010,2013, Office 365 |
| 229 | COLUMN function | Returns the column number of a reference | Excel 2007,2010,2013, Office 365 |
| 230 | COLUMNS function | Returns the number of columns in a reference | Excel 2007,2010,2013, Office 365 |
| 231 | FILTER function | Filters a range of data based on criteria you define | Office 365 button |
| 232 | FORMULATEXT function | Returns the formula at the given reference as text | Excel 2013, Office 365 |
| 233 | GETPIVOTDATA function | Returns data stored in a PivotTable report | Excel 2007,2010,2013, Office 365 |
| 234 | HLOOKUP function | Looks in the top row of an array and returns the value of the indicated cell | Excel 2007,2010,2013, Office 365 |
| 235 | HYPERLINK function | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | Excel 2007,2010,2013, Office 365 |
| 236 | INDEX function | Uses an index to choose a value from a reference or array | Excel 2007,2010,2013, Office 365 |
| 237 | INDIRECT function | Returns a reference indicated by a text value | Excel 2007,2010,2013, Office 365 |
| 238 | LOOKUP function | Looks up values in a vector or array | Excel 2007,2010,2013, Office 365 |
| 239 | MATCH function | Looks up values in a reference or array | Excel 2007,2010,2013, Office 365 |
| 240 | OFFSET function | Returns a reference offset from a given reference | Excel 2007,2010,2013, Office 365 |
| 241 | ROW function | Returns the row number of a reference | Excel 2007,2010,2013, Office 365 |
| 242 | ROWS function | Returns the number of rows in a reference | Excel 2007,2010,2013, Office 365 |
| 243 | RTD function | Retrieves real-time data from a program that supports COM automation | Excel 2007,2010,2013, Office 365 |
| 244 | SORT function | Sorts the contents of a range or array | Office 365 button |
| 245 | SORTBY function | Sorts the contents of a range or array based on the values in a corresponding range or array | Office 365 button |
| 246 | TRANSPOSE function | Returns the transpose of an array | Excel 2007,2010,2013, Office 365 |
| 247 | UNIQUE function | Returns a list of unique values in a list or range | Office 365 button |
| 248 | VLOOKUP function | Looks in the first column of an array and moves across the row to return the value of a cell | Excel 2007,2010,2013, Office 365 |
| 249 | XLOOKUP function | Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. | Office 365 button |
| 250 | XMATCH function | Returns the relative position of an item in an array or range of cells. | Office 365 button |
| 251 | ABS function | Returns the absolute value of a number | Excel 2007,2010,2013, Office 365 |
| 252 | ACOS function | Returns the arccosine of a number | Excel 2007,2010,2013, Office 365 |
| 253 | ACOSH function | Returns the inverse hyperbolic cosine of a number | Excel 2007,2010,2013, Office 365 |
| 254 | ACOT function | Returns the arccotangent of a number | Excel 2013, Office 365 |
| 255 | ACOTH function | Returns the hyperbolic arccotangent of a number | Excel 2013, Office 365 |
| 256 | AGGREGATE function | Returns an aggregate in a list or database | Excel 2007,2010,2013, Office 365 |
| 257 | ARABIC function | Converts a Roman number to Arabic, as a number | Excel 2013, Office 365 |
| 258 | ASIN function | Returns the arcsine of a number | Excel 2007,2010,2013, Office 365 |
| 259 | ASINH function | Returns the inverse hyperbolic sine of a number | Excel 2007,2010,2013, Office 365 |
| 260 | ATAN function | Returns the arctangent of a number | Excel 2007,2010,2013, Office 365 |
| 261 | ATAN2 function | Returns the arctangent from x- and y-coordinates | Excel 2007,2010,2013, Office 365 |
| 262 | ATANH function | Returns the inverse hyperbolic tangent of a number | Excel 2007,2010,2013, Office 365 |
| 263 | BASE function | Converts a number into a text representation with the given radix (base) | Excel 2007,2010,2013, Office 365 |
| 264 | CEILING function | Rounds a number to the nearest integer or to the nearest multiple of significance | Excel 2007,2010,2013, Office 365 |
| 265 | CEILING.MATH function | Rounds a number up, to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 266 | CEILING.PRECISE function | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | Excel 2007,2010,2013, Office 365 |
| 267 | COMBIN function | Returns the number of combinations for a given number of objects | Excel 2007,2010,2013, Office 365 |
| 268 | COMBINA function | eturns the number of combinations with repetitions for a given number of items | Excel 2013, Office 365 |
| 269 | COS function | Returns the cosine of a number | Excel 2007,2010,2013, Office 365 |
| 270 | COSH function | Returns the hyperbolic cosine of a number | Excel 2007,2010,2013, Office 365 |
| 271 | COT function | Returns the hyperbolic cosine of a number | Excel 2013, Office 365 |
| 272 | COTH function | Returns the cotangent of an angle | Excel 2013, Office 365 |
| 273 | CSC function | Returns the cosecant of an angle | Excel 2013, Office 365 |
| 274 | CSCH function | Returns the hyperbolic cosecant of an angle | Excel 2013, Office 365 |
| 275 | DECIMAL function | Converts a text representation of a number in a given base into a decimal number | Excel 2013, Office 365 |
| 276 | DEGREES function | Converts radians to degrees | Excel 2007,2010,2013, Office 365 |
| 277 | EVEN function | Rounds a number up to the nearest even integer | Excel 2007,2010,2013, Office 365 |
| 278 | EXP function | Returns e raised to the power of a given number | Excel 2007,2010,2013, Office 365 |
| 279 | FACT function | Returns the factorial of a number | Excel 2007,2010,2013, Office 365 |
| 280 | FACTDOUBLE function | Returns the double factorial of a number | Excel 2007,2010,2013, Office 365 |
| 281 | FLOOR.MATH function | Rounds a number down, to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 282 | FLOOR.PRECISE function | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | Excel 2007,2010,2013, Office 365 |
| 283 | GCD function | Returns the greatest common divisor | Excel 2007,2010,2013, Office 365 |
| 284 | INT function | Rounds a number down to the nearest integer | Excel 2007,2010,2013, Office 365 |
| 285 | ISO.CEILING function | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 286 | LCM function | Returns the least common multiple | Excel 2007,2010,2013, Office 365 |
| 287 | LN function | Returns the natural logarithm of a number | Excel 2007,2010,2013, Office 365 |
| 288 | LOG function | Returns the logarithm of a number to a specified base | Excel 2007,2010,2013, Office 365 |
| 289 | LOG10 function | Returns the base-10 logarithm of a number | Excel 2007,2010,2013, Office 365 |
| 290 | MDETERM function | Returns the matrix determinant of an array | Excel 2007,2010,2013, Office 365 |
| 291 | MINVERSE function | Returns the matrix inverse of an array | Excel 2007,2010,2013, Office 365 |
| 292 | MMULT function | Returns the matrix product of two arrays | Excel 2007,2010,2013, Office 365 |
| 293 | MOD function | Returns the remainder from division | Excel 2007,2010,2013, Office 365 |
| 294 | MROUND function | Returns a number rounded to the desired multiple | Excel 2007,2010,2013, Office 365 |
| 295 | MULTINOMIAL function | Returns the multinomial of a set of numbers | Excel 2007,2010,2013, Office 365 |
| 296 | MUNIT function | Returns the unit matrix or the specified dimension | Excel 2013, Office 365 |
| 297 | ODD function | Rounds a number up to the nearest odd integer | Excel 2007,2010,2013, Office 365 |
| 298 | PI function | Returns the value of pi | Excel 2007,2010,2013, Office 365 |
| 299 | POWER function | Returns the result of a number raised to a power | Excel 2007,2010,2013, Office 365 |
| 300 | PRODUCT function | Multiplies its arguments | Excel 2007,2010,2013, Office 365 |
| 301 | QUOTIENT function | Returns the integer portion of a division | Excel 2007,2010,2013, Office 365 |
| 302 | RADIANS function | Converts degrees to radians | Excel 2007,2010,2013, Office 365 |
| 303 | RAND function | Returns a random number between 0 and 1 | Excel 2007,2010,2013, Office 365 |
| 304 | RANDARRAY function | Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. | Office 365 button |
| 305 | RANDBETWEEN function | Returns a random number between the numbers you specify | Excel 2007,2010,2013, Office 365 |
| 306 | ROMAN function | Converts an arabic numeral to roman, as text | Excel 2007,2010,2013, Office 365 |
| 307 | ROUND function | Rounds a number to a specified number of digits | Excel 2007,2010,2013, Office 365 |
| 308 | ROUNDDOWN function | Rounds a number down, toward zero | Excel 2007,2010,2013, Office 365 |
| 309 | ROUNDUP function | Rounds a number up, away from zero | Excel 2007,2010,2013, Office 365 |
| 310 | SEC function | Returns the secant of an angle | Excel 2013, Office 365 |
| 311 | SECH function | Returns the hyperbolic secant of an angle | Excel 2013, Office 365 |
| 312 | SEQUENCE function | Generates a list of sequential numbers in an array, such as 1, 2, 3, 4 | Office 365 button |
| 313 | SERIESSUM function | Returns the sum of a power series based on the formula | Excel 2007,2010,2013, Office 365 |
| 314 | SIGN function | Returns the sign of a number | Excel 2007,2010,2013, Office 365 |
| 315 | SIN function | Returns the sine of the given angle | Excel 2007,2010,2013, Office 365 |
| 316 | SINH function | Returns the hyperbolic sine of a number | Excel 2007,2010,2013, Office 365 |
| 317 | SQRT function | Returns a positive square root | Excel 2007,2010,2013, Office 365 |
| 318 | SQRTPI function | Returns the square root of (number * pi) | Excel 2007,2010,2013, Office 365 |
| 319 | SUBTOTAL function | Returns a subtotal in a list or database | Excel 2007,2010,2013, Office 365 |
| 320 | SUM function | Adds its arguments | Excel 2007,2010,2013, Office 365 |
| 321 | SUMIF function | Adds the cells specified by a given criteria | Excel 2007,2010,2013, Office 365 |
| 322 | SUMIFS function | Adds the cells in a range that meet multiple criteria | Excel 2007,2010,2013, Office 365 |
| 323 | SUMPRODUCT function | Returns the sum of the products of corresponding array components | Excel 2007,2010,2013, Office 365 |
| 324 | SUMSQ function | Returns the sum of the squares of the arguments | Excel 2007,2010,2013, Office 365 |
| 325 | SUMX2MY2 function | Returns the sum of the difference of squares of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 326 | SUMX2PY2 function | Returns the sum of the sum of squares of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 327 | SUMXMY2 function | Returns the sum of squares of differences of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 328 | TAN function | Returns the tangent of a number | Excel 2007,2010,2013, Office 365 |
| 329 | TANH function | Returns the hyperbolic tangent of a number | Excel 2007,2010,2013, Office 365 |
| 330 | TRUNC function | Truncates a number to an integer | Excel 2007,2010,2013, Office 365 |
| 331 | AVEDEV function | Returns the average of the absolute deviations of data points from their mean | Excel 2007,2010,2013, Office 365 |
| 332 | AVERAGE function | Returns the average of its arguments | Excel 2007,2010,2013, Office 365 |
| 333 | AVERAGEA function | Returns the average of its arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 334 | AVERAGEIF function | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | Excel 2007,2010,2013, Office 365 |
| 335 | AVERAGEIFS function | Returns the average (arithmetic mean) of all cells that meet multiple criteria. | Excel 2007,2010,2013, Office 365 |
| 336 | BETA.DIST function | Returns the beta cumulative distribution function | Excel 2010, 2013, office 365 |
| 337 | BETA.INV function | Returns the inverse of the cumulative distribution function for a specified beta distribution | Excel 2010, 2013, office 365 |
| 338 | BINOM.DIST function | Returns the individual term binomial distribution probability | Excel 2010, 2013, office 365 |
| 339 | BINOM.DIST.RANGE function | Returns the probability of a trial result using a binomial distribution | Excel 2013, Office 365 |
| 340 | BINOM.INV function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | Excel 2010, 2013, office 365 |
| 341 | CHISQ.DIST function | Returns the cumulative beta probability density function | Excel 2010, 2013, office 365 |
| 342 | CHISQ.DIST.RT function | Returns the one-tailed probability of the chi-squared distribution | Excel 2010, 2013, office 365 |
| 343 | CHISQ.INV function | Returns the cumulative beta probability density function | Excel 2010, 2013, office 365 |
| 344 | CHISQ.INV.RT function | Returns the inverse of the one-tailed probability of the chi-squared distribution | Excel 2010, 2013, office 365 |
| 345 | CHISQ.TEST function | Returns the test for independence | Excel 2010, 2013, office 365 |
| 346 | CONFIDENCE.NORM function | Returns the confidence interval for a population mean | Excel 2010, 2013, office 365 |
| 347 | CONFIDENCE.T function | Returns the confidence interval for a population mean, using a Student's t distribution | Excel 2010, 2013, office 365 |
| 348 | CORREL function | Returns the correlation coefficient between two data sets | Excel 2007,2010,2013, Office 365 |
| 349 | COUNT function | Counts how many numbers are in the list of arguments | Excel 2007,2010,2013, Office 365 |
| 350 | COUNTA function | Counts how many values are in the list of arguments | Excel 2007,2010,2013, Office 365 |
| 351 | COUNTBLANK function | Counts the number of blank cells within a range | Excel 2007,2010,2013, Office 365 |
| 352 | COUNTIF function | Counts the number of cells within a range that meet the given criteria | Excel 2007,2010,2013, Office 365 |
| 353 | COUNTIFS function | Counts the number of cells within a range that meet multiple criteria | Excel 2007,2010,2013, Office 365 |
| 354 | COVARIANCE.P function | Returns covariance, the average of the products of paired deviations | Excel 2010, 2013, office 365 |
| 355 | COVARIANCE.S function | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets | Excel 2010, 2013, office 365 |
| 356 | DEVSQ function | Returns the sum of squares of deviations | Excel 2007,2010,2013, Office 365 |
| 357 | EXPON.DIST function | Returns the exponential distribution | Excel 2010, 2013, office 365 |
| 358 | F.DIST function | Returns the F probability distribution | Excel 2010, 2013, office 365 |
| 359 | F.DIST.RT function | Returns the F probability distribution | Excel 2010, 2013, office 365 |
| 360 | F.INV function | Returns the inverse of the F probability distribution | Excel 2010, 2013, office 365 |
| 361 | F.INV.RT function | Returns the inverse of the F probability distribution | Excel 2010, 2013, office 365 |
| 362 | F.TEST function | Returns the result of an F-test | Excel 2010, 2013, office 365 |
| 363 | FINV function | Returns the inverse of the F probability distribution | Excel 2007,2010,2013, Office 365 |
| 364 | FISHER function | Returns the Fisher transformation | Excel 2007,2010,2013, Office 365 |
| 365 | FISHERINV function | Returns the inverse of the Fisher transformation | Excel 2007,2010,2013, Office 365 |
| 366 | FORECAST function | Returns a value along a linear trendIn Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions. | Excel 2007,2010,2013, Office 365 |
| 367 | FORECAST.ETS function | Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm | Excel 2016 |
| 368 | FORECAST.ETS.CONFINT function | Returns a confidence interval for the forecast value at the specified target date | Excel 2016 |
| 369 | FORECAST.ETS.SEASONALITY function | Returns the length of the repetitive pattern Excel detects for the specified time series | Excel 2016 |
| 370 | FORECAST.ETS.STAT function | Returns a statistical value as a result of time series forecasting | Excel 2016 |
| 371 | FORECAST.LINEAR function | Returns a future value based on existing values | Excel 2016 |
| 372 | FREQUENCY function | Returns a frequency distribution as a vertical array | Excel 2007,2010,2013, Office 365 |
| 373 | GAMMA function | Returns the Gamma function value | Excel 2013, Office 365 |
| 374 | GAMMA.DIST function | Returns the gamma distribution | Excel 2010, 2013, office 365 |
| 375 | GAMMA.INV function | Returns the inverse of the gamma cumulative distribution | Excel 2010, 2013, office 365 |
| 376 | GAMMALN function | Returns the natural logarithm of the gamma function, Γ(x) | Excel 2007,2010,2013, Office 365 |
| 377 | GAMMALN.PRECISE function | Returns the natural logarithm of the gamma function, Γ(x) | Excel 2010, 2013, office 365 |
| 378 | GAUSS function | Returns 0.5 less than the standard normal cumulative distribution | Excel 2013, Office 365 |
| 379 | GEOMEAN function | Returns the geometric mean | Excel 2007,2010,2013, Office 365 |
| 380 | GROWTH function | Returns values along an exponential trend | Excel 2007,2010,2013, Office 365 |
| 381 | HARMEAN function | Returns the harmonic mean | Excel 2007,2010,2013, Office 365 |
| 382 | HYPGEOM.DIST function | Returns the hypergeometric distribution | Excel 2007,2010,2013, Office 365 |
| 383 | INTERCEPT function | Returns the intercept of the linear regression line | Excel 2007,2010,2013, Office 365 |
| 384 | KURT function | Returns the kurtosis of a data set | Excel 2007,2010,2013, Office 365 |
| 385 | LARGE function | Returns the k-th largest value in a data set | Excel 2007,2010,2013, Office 365 |
| 386 | LINEST function | Returns the parameters of a linear trend | Excel 2007,2010,2013, Office 365 |
| 387 | LOGEST function | Returns the parameters of an exponential trend | Excel 2007,2010,2013, Office 365 |
| 388 | LOGNORM.DIST function | Returns the cumulative lognormal distribution | Excel 2010, 2013, office 365 |
| 389 | LOGNORM.INV function | Returns the inverse of the lognormal cumulative distribution | Excel 2010, 2013, office 365 |
| 390 | MAX function | Returns the maximum value in a list of arguments | Excel 2007,2010,2013, Office 365 |
| 391 | MAXA function | Returns the maximum value in a list of arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 392 | MAXIFS function | Returns the maximum value among cells specified by a given set of conditions or criteria | Excel 2007,2010,2013, Office 365 |
| 393 | MEDIAN function | Returns the median of the given numbers | Excel 2007,2010,2013, Office 365 |
| 394 | MIN function | Returns the minimum value in a list of arguments | Excel 2007,2010,2013, Office 365 |
| 395 | MINA function | Returns the smallest value in a list of arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 396 | MINIFS function | Returns the minimum value among cells specified by a given set of conditions or criteria. | Excel 2007,2010,2013, Office 365 |
| 397 | MODE.MULT function | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data | Excel 2010, 2013, office 365 |
| 398 | MODE.SNGL function | Returns the most common value in a data set | Excel 2010, 2013, office 365 |
| 399 | NEGBINOM.DIST function | Returns the negative binomial distribution | Excel 2010, 2013, office 365 |
| 400 | NORM.DIST function | Returns the normal cumulative distribution | Excel 2010, 2013, office 365 |
| 401 | NORM.S.DIST function | Returns the standard normal cumulative distribution | Excel 2010, 2013, office 365 |
| 402 | NORM.S.INV function | Returns the inverse of the standard normal cumulative distribution | Excel 2010, 2013, office 365 |
| 403 | NORMINV function | Returns the inverse of the normal cumulative distribution | Excel 2007,2010,2013, Office 365 |
| 404 | PEARSON function | Returns the Pearson product moment correlation coefficient | Excel 2007,2010,2013, Office 365 |
| 405 | PERCENTILE.EXC function | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive | Excel 2010, 2013, office 365 |
| 406 | PERCENTILE.INC function | Returns the k-th percentile of values in a range | Excel 2010, 2013, office 365 |
| 407 | PERCENTRANK.EXC function | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set | Excel 2010, 2013, office 365 |
| 408 | PERCENTRANK.INC function | Returns the percentage rank of a value in a data set | Excel 2010, 2013, office 365 |
| 409 | PERMUT function | Returns the number of permutations for a given number of objects | Excel 2007,2010,2013, Office 365 |
| 410 | PERMUTATIONA function | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects | Excel 2013, Office 365 |
| 411 | PHI function | Returns the value of the density function for a standard normal distribution | Excel 2013, Office 365 |
| 412 | POISSON.DIST function | Returns the Poisson distribution | Excel 2010, 2013, office 365 |
| 413 | PROB function | Returns the probability that values in a range are between two limits | Excel 2007,2010,2013, Office 365 |
| 414 | QUARTILE.EXC function | Returns the quartile of the data set, based on percentile values from 0..1, exclusive | Excel 2010, 2013, office 365 |
| 415 | QUARTILE.INC function | Returns the quartile of a data set | Excel 2010, 2013, office 365 |
| 416 | RANK.AVG function | Returns the rank of a number in a list of numbers | Excel 2010, 2013, office 365 |
| 417 | RANK.EQ function | Returns the rank of a number in a list of numbers | Excel 2010, 2013, office 365 |
| 418 | RSQ function | Returns the square of the Pearson product moment correlation coefficient | Excel 2007,2010,2013, Office 365 |
| 419 | SKEW function | Returns the skewness of a distribution | Excel 2007,2010,2013, Office 365 |
| 420 | SKEW.P function | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean | Excel 2013, Office 365 |
| 421 | SLOPE function | Returns the slope of the linear regression line | Excel 2007,2010,2013, Office 365 |
| 422 | SMALL function | Returns the k-th smallest value in a data set | Excel 2007,2010,2013, Office 365 |
| 423 | STANDARDIZE function | Returns a normalized value | Excel 2007,2010,2013, Office 365 |
| 424 | STDEV.P function | Calculates standard deviation based on the entire population | Excel 2010, 2013, office 365 |
| 425 | STDEV.S function | Estimates standard deviation based on a sample | Excel 2010, 2013, office 365 |
| 426 | STDEVA function | Estimates standard deviation based on a sample, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 427 | STDEVPA function | Calculates standard deviation based on the entire population, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 428 | STEYX function | Returns the standard error of the predicted y-value for each x in the regression | Excel 2007,2010,2013, Office 365 |
| 429 | T.DIST function | Returns the Percentage Points (probability) for the Student t-distribution | Excel 2010, 2013, office 365 |
| 430 | T.DIST.2T function | Returns the Percentage Points (probability) for the Student t-distribution | Excel 2010, 2013, office 365 |
| 431 | T.DIST.RT function | Returns the Student's t-distribution | Excel 2010, 2013, office 365 |
| 432 | T.INV function | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom | Excel 2010, 2013, office 365 |
| 433 | T.INV.2T function | Returns the inverse of the Student's t-distribution | Excel 2010, 2013, office 365 |
| 434 | T.TEST function | Returns the probability associated with a Student's t-test | Excel 2010, 2013, office 365 |
| 435 | TREND function | Returns values along a linear trend | Excel 2007,2010,2013, Office 365 |
| 436 | TRIMMEAN function | Returns the mean of the interior of a data set | Excel 2007,2010,2013, Office 365 |
| 437 | VAR.P function | Calculates variance based on the entire population | Excel 2010, 2013, office 365 |
| 438 | VAR.S function | Estimates variance based on a sample | Excel 2010, 2013, office 365 |
| 439 | VARA function | Estimates variance based on a sample, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 440 | VARPA function | Calculates variance based on the entire population, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 441 | WEIBULL.DIST function | Returns the Weibull distribution | Excel 2010, 2013, office 365 |
| 442 | Z.TEST function | Returns the one-tailed probability-value of a z-test | Excel 2010, 2013, office 365 |
| 443 | ASC function | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | Excel 2007,2010,2013, Office 365 |
| 444 | BAHTTEXT function | Converts a number to text, using the ß (baht) currency format | Excel 2007,2010,2013, Office 365 |
| 445 | CHAR function | Returns the character specified by the code number | Excel 2007,2010,2013, Office 365 |
| 446 | CLEAN function | Removes all nonprintable characters from text | Excel 2007,2010,2013, Office 365 |
| 447 | CODE function | Returns a numeric code for the first character in a text string | Excel 2007,2010,2013, Office 365 |
| 448 | CONCAT function | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. | Excel 2007,2010,2013, Office 365 |
| 449 | CONCATENATE function | Joins several text items into one text item | Excel 2007,2010,2013, Office 365 |
| 450 | DBCS function | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters | Excel 2013, Office 365 |
| 451 | DOLLAR function | Converts a number to text, using the $ (dollar) currency format | Excel 2007,2010,2013, Office 365 |
| 452 | EXACT function | Checks to see if two text values are identical | Excel 2007,2010,2013, Office 365 |
| 453 | FIND, FINDB functions | Finds one text value within another (case-sensitive) | Excel 2007,2010,2013, Office 365 |
| 454 | FIXED function | Formats a number as text with a fixed number of decimals | Excel 2007,2010,2013, Office 365 |
| 455 | JIS function | hanges half-width (single-byte) characters within a string to full-width (double-byte) characters | Excel 2007,2010,2013, Office 365 |
| 456 | LEFT, LEFTB functions | Returns the leftmost characters from a text value | Excel 2007,2010,2013, Office 365 |
| 457 | LEN, LENB functions | Returns the number of characters in a text string | Excel 2007,2010,2013, Office 365 |
| 458 | LOWER function | Converts text to lowercase | Excel 2007,2010,2013, Office 365 |
| 459 | MID, MIDB functions | Returns a specific number of characters from a text string starting at the position you specify | Excel 2007,2010,2013, Office 365 |
| 460 | NUMBERVALUE function | Converts text to number in a locale-independent manner | Excel 2013, Office 365 |
| 461 | PHONETIC function | Extracts the phonetic (furigana) characters from a text string | Excel 2007,2010,2013, Office 365 |
| 462 | PROPER function | Capitalizes the first letter in each word of a text value | Excel 2007,2010,2013, Office 365 |
| 463 | REPLACE, REPLACEB functions | Replaces characters within text | Excel 2007,2010,2013, Office 365 |
| 464 | REPT function | Repeats text a given number of times | Excel 2007,2010,2013, Office 365 |
| 465 | RIGHT, RIGHTB functions | Returns the rightmost characters from a text value | Excel 2007,2010,2013, Office 365 |
| 466 | SEARCH, SEARCHB functions | Finds one text value within another (not case-sensitive) | Excel 2007,2010,2013, Office 365 |
| 467 | SUBSTITUTE function | Substitutes new text for old text in a text string | Excel 2007,2010,2013, Office 365 |
| 468 | T function | Converts its arguments to text | Excel 2007,2010,2013, Office 365 |
| 469 | TEXT function | Formats a number and converts it to text | Excel 2007,2010,2013, Office 365 |
| 470 | TEXTJOIN function | Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. | Excel 2007,2010,2013, Office 365 |
| 471 | TRIM function | Removes spaces from text | Excel 2007,2010,2013, Office 365 |
| 472 | UNICHAR function | Returns the Unicode character that is references by the given numeric value | Excel 2013, Office 365 |
| 473 | UNICODE function | Returns the number (code point) that corresponds to the first character of the text | Excel 2013, Office 365 |
| 474 | UPPER function | Converts text to uppercase | Excel 2007,2010,2013, Office 365 |
| 475 | VALUE function | Converts a text argument to a number | Excel 2007,2010,2013, Office 365 |
| 476 | ENCODEURL function | Returns a URL-encoded stringThis function is not available in Excel for the web. | Excel 2013, Office 365 |
| 477 | FILTERXML function | Returns specific data from the XML content by using the specified XPathThis function is not available in Excel for the web. | Excel 2013, Office 365 |
| 478 | WEBSERVICE function | Returns data from a web service.This function is not available in Excel for the web. | Excel 2013, Office 365 |
400+ Excel Functions list with detailed description of function with Type and Version supported
Reference: https://docs.microsoft.com/| SL# | Function Name | Type and Description | Office Version |
|---|---|---|---|
| 1 | CALL function | Calls a procedure in a dynamic link library or code resource | 2007,2010,2013, Office 365 |
| 2 | EUROCONVERT function | Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). | 2007,2010,2013, Office 365 |
| 3 | REGISTER.ID function | Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered | 2007,2010,2013, Office 365 |
| 4 | BETADIST function | Returns the beta cumulative distribution functionIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 5 | BETAINV function | Returns the inverse of the cumulative distribution function for a specified beta distributionIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 6 | BINOMDIST function | Returns the individual term binomial distribution probabilityIn 2007, this is a Statistical function. | 2007,2010,2013, Office 365 |
| 7 | CHIDIST function | Returns the one-tailed probability of the chi-squared distributionNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 8 | CHIINV function | Returns the inverse of the one-tailed probability of the chi-squared distributionNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 9 | CHITEST function | Returns the test for independenceNote: In Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 10 | CONFIDENCE function | Returns the confidence interval for a population meanIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 11 | COVAR function | Returns covariance, the average of the products of paired deviationsIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 12 | CRITBINOM function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion valueIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 13 | EXPONDIST function | Returns the exponential distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 14 | FDIST function | Returns the F probability distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 15 | FLOOR function | Rounds a number down, toward zeroIn Excel 2007 and Excel 2010, this is a Math and trigonometry function. | Excel 2007,2010,2013, Office 365 |
| 16 | FTEST function | Returns the result of an F-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 17 | GAMMADIST function | Returns the gamma distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 18 | GAMMAINV function | Returns the inverse of the gamma cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 19 | HYPGEOMDIST function | Returns the hypergeometric distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 20 | LOGINV function | Returns the inverse of the lognormal cumulative distribution | Excel 2007,2010,2013, Office 365 |
| 21 | LOGNORMDIST function | Returns the cumulative lognormal distribution | Excel 2007,2010,2013, Office 365 |
| 22 | MODE function | Returns the most common value in a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 23 | NEGBINOMDIST function | Returns the negative binomial distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 24 | NORM.INV function | Returns the inverse of the normal cumulative distribution Note: In Excel 2007, this is a Statistical function. | Excel 2010, 2013, office 365 |
| 25 | NORMDIST function | Returns the normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 26 | NORMSDIST function | Returns the standard normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 27 | NORMSINV function | Returns the inverse of the standard normal cumulative distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 28 | PERCENTILE function | Returns the k-th percentile of values in a rangeIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 29 | PERCENTRANK function | Returns the percentage rank of a value in a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 30 | POISSON function | Returns the Poisson distributionIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 31 | QUARTILE function | Returns the quartile of a data setIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 32 | RANK function | Returns the rank of a number in a list of numbersIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 33 | STDEV function | Estimates standard deviation based on a sample | Excel 2007,2010,2013, Office 365 |
| 34 | STDEVP function | Calculates standard deviation based on the entire populationIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 35 | TDIST function | Returns the Student's t-distribution | Excel 2007,2010,2013, Office 365 |
| 36 | TINV function | Returns the inverse of the Student's t-distribution | Excel 2007,2010,2013, Office 365 |
| 37 | TTEST function | Returns the probability associated with a Student's t-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 38 | VAR function | Estimates variance based on a sampleIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 39 | VARP function | Calculates variance based on the entire populationIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 40 | WEIBULL function | Calculates variance based on the entire population, including numbers, text, and logical valuesIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 41 | ZTEST function | Returns the one-tailed probability-value of a z-testIn Excel 2007, this is a Statistical function. | Excel 2007,2010,2013, Office 365 |
| 42 | CUBEKPIMEMBER function | Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. | Excel 2007,2010,2013, Office 365 |
| 43 | CUBEMEMBER function | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. | Excel 2007,2010,2013, Office 365 |
| 44 | CUBEMEMBERPROPERTY function | Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. | Excel 2007,2010,2013, Office 365 |
| 45 | CUBERANKEDMEMBER function | Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. | Excel 2007,2010,2013, Office 365 |
| 46 | CUBESET function | Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. | Excel 2007,2010,2013, Office 365 |
| 47 | CUBESETCOUNT function | Returns the number of items in a set. | Excel 2007,2010,2013, Office 365 |
| 48 | CUBEVALUE function | Returns an aggregated value from a cube. | Excel 2007,2010,2013, Office 365 |
| 49 | DAVERAGE function | Returns the average of selected database entries | Excel 2007,2010,2013, Office 365 |
| 50 | DCOUNT function | Counts the cells that contain numbers in a database | Excel 2007,2010,2013, Office 365 |
| 51 | DCOUNTA function | Counts nonblank cells in a database | Excel 2007,2010,2013, Office 365 |
| 52 | DGET function | Extracts from a database a single record that matches the specified criteria | Excel 2007,2010,2013, Office 365 |
| 53 | DMAX function | Returns the maximum value from selected database entries | Excel 2007,2010,2013, Office 365 |
| 54 | DMIN function | Returns the minimum value from selected database entries | Excel 2007,2010,2013, Office 365 |
| 55 | DPRODUCT function | Multiplies the values in a particular field of records that match the criteria in a database | Excel 2007,2010,2013, Office 365 |
| 56 | DSTDEV function | Estimates the standard deviation based on a sample of selected database entries | Excel 2007,2010,2013, Office 365 |
| 57 | DSTDEVP function | Calculates the standard deviation based on the entire population of selected database entries | Excel 2007,2010,2013, Office 365 |
| 58 | DSUM function | Adds the numbers in the field column of records in the database that match the criteria | Excel 2007,2010,2013, Office 365 |
| 59 | DVAR function | Estimates variance based on a sample from selected database entries | Excel 2007,2010,2013, Office 365 |
| 60 | DVARP function | Calculates variance based on the entire population of selected database entries | Excel 2007,2010,2013, Office 365 |
| 61 | DATE function | Returns the serial number of a particular date | Excel 2007,2010,2013, Office 365 |
| 62 | DATEDIF function | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. | Excel 2007,2010,2013, Office 365 |
| 63 | DATEVALUE function | Converts a date in the form of text to a serial number | Excel 2007,2010,2013, Office 365 |
| 64 | DAY function | Converts a serial number to a day of the month | Excel 2007,2010,2013, Office 365 |
| 65 | DAYS function | Returns the number of days between two dates | Excel 2013, Office 365 |
| 66 | DAYS360 function | Calculates the number of days between two dates based on a 360-day year | Excel 2007,2010,2013, Office 365 |
| 67 | EDATE function | Returns the serial number of the date that is the indicated number of months before or after the start date | Excel 2007,2010,2013, Office 365 |
| 68 | EOMONTH function | Returns the serial number of the last day of the month before or after a specified number of months | Excel 2007,2010,2013, Office 365 |
| 69 | HOUR function | Converts a serial number to an hour | Excel 2007,2010,2013, Office 365 |
| 70 | ISOWEEKNUM function | Returns the number of the ISO week number of the year for a given date | Excel 2013, Office 365 |
| 71 | MINUTE function | Converts a serial number to a minute | Excel 2007,2010,2013, Office 365 |
| 72 | MONTH function | Converts a serial number to a month | Excel 2007,2010,2013, Office 365 |
| 73 | NETWORKDAYS function | Returns the number of whole workdays between two dates | Excel 2007,2010,2013, Office 365 |
| 74 | NETWORKDAYS.INTL function | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days | Excel 2010, 2013, office 365 |
| 75 | NOW function | Returns the serial number of the current date and time | Excel 2007,2010,2013, Office 365 |
| 76 | SECOND function | Converts a serial number to a second | Excel 2007,2010,2013, Office 365 |
| 77 | TIME function | Returns the serial number of a particular time | Excel 2007,2010,2013, Office 365 |
| 78 | TIMEVALUE function | Converts a time in the form of text to a serial number | Excel 2007,2010,2013, Office 365 |
| 79 | TODAY function | Returns the serial number of today's date | Excel 2007,2010,2013, Office 365 |
| 80 | WEEKDAY function | Converts a serial number to a day of the week | Excel 2007,2010,2013, Office 365 |
| 81 | WEEKNUM function | Converts a serial number to a number representing where the week falls numerically with a year | Excel 2007,2010,2013, Office 365 |
| 82 | WORKDAY function | Returns the serial number of the date before or after a specified number of workdays | Excel 2007,2010,2013, Office 365 |
| 83 | WORKDAY.INTL function | Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days | Excel 2010, 2013, office 365 |
| 84 | YEAR function | Converts a serial number to a year | Excel 2007,2010,2013, Office 365 |
| 85 | YEARFRAC function | Returns the year fraction representing the number of whole days between start_date and end_date | Excel 2007,2010,2013, Office 365 |
| 86 | BESSELI function | Returns the modified Bessel function In(x) | Excel 2007,2010,2013, Office 365 |
| 87 | BESSELJ function | Returns the Bessel function Jn(x) | Excel 2007,2010,2013, Office 365 |
| 88 | BESSELK function | Returns the modified Bessel function Kn(x) | Excel 2007,2010,2013, Office 365 |
| 89 | BESSELY function | Returns the Bessel function Yn(x) | Excel 2007,2010,2013, Office 365 |
| 90 | BIN2DEC function | Converts a binary number to decimal | Excel 2007,2010,2013, Office 365 |
| 91 | BIN2HEX function | Converts a binary number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 92 | BIN2OCT function | Converts a binary number to octal | Excel 2007,2010,2013, Office 365 |
| 93 | BITAND function | Returns a 'Bitwise And' of two numbers | Excel 2013, Office 365 |
| 94 | BITLSHIFT function | Returns a value number shifted left by shift_amount bits | Excel 2013, Office 365 |
| 95 | BITOR function | Returns a bitwise OR of 2 numbers | Excel 2013, Office 365 |
| 96 | BITRSHIFT function | Returns a value number shifted right by shift_amount bits | Excel 2013, Office 365 |
| 97 | BITXOR function | Returns a bitwise 'Exclusive Or' of two numbers | Excel 2013, Office 365 |
| 98 | COMPLEX function | Converts real and imaginary coefficients into a complex number | Excel 2007,2010,2013, Office 365 |
| 99 | CONVERT function | Converts a number from one measurement system to another | Excel 2007,2010,2013, Office 365 |
| 100 | DEC2BIN function | Converts a decimal number to binary | Excel 2007,2010,2013, Office 365 |
| 101 | DEC2HEX function | Converts a decimal number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 102 | DEC2OCT function | Converts a decimal number to octal | Excel 2007,2010,2013, Office 365 |
| 103 | DELTA function | Tests whether two values are equal | Excel 2007,2010,2013, Office 365 |
| 104 | ERF function | Returns the error function | Excel 2007,2010,2013, Office 365 |
| 105 | ERF.PRECISE function | Returns the error function | Excel 2010, 2013, office 365 |
| 106 | ERFC function | Returns the complementary error function | Excel 2007,2010,2013, Office 365 |
| 107 | ERFC.PRECISE function | Returns the complementary ERF function integrated between x and infinity | Excel 2010, 2013, office 365 |
| 108 | GESTEP function | Tests whether a number is greater than a threshold value | Excel 2007,2010,2013, Office 365 |
| 109 | HEX2BIN function | Converts a hexadecimal number to binary | Excel 2007,2010,2013, Office 365 |
| 110 | HEX2DEC function | Converts a hexadecimal number to decimal | Excel 2007,2010,2013, Office 365 |
| 111 | HEX2OCT function | Converts a hexadecimal number to octal | Excel 2007,2010,2013, Office 365 |
| 112 | IMABS function | Returns the absolute value (modulus) of a complex number | Excel 2007,2010,2013, Office 365 |
| 113 | IMAGINARY function | Returns the imaginary coefficient of a complex number | Excel 2007,2010,2013, Office 365 |
| 114 | IMARGUMENT function | Returns the argument theta, an angle expressed in radians | Excel 2007,2010,2013, Office 365 |
| 115 | IMCONJUGATE function | Returns the complex conjugate of a complex number | Excel 2007,2010,2013, Office 365 |
| 116 | IMCOS function | Returns the cosine of a complex number | Excel 2007,2010,2013, Office 365 |
| 117 | IMCOSH function | Returns the hyperbolic cosine of a complex number | Excel 2013, Office 365 |
| 118 | IMCOT function | Returns the cotangent of a complex number | Excel 2013, Office 365 |
| 119 | IMCSC function | Returns the cosecant of a complex number | Excel 2013, Office 365 |
| 120 | IMCSCH function | Returns the hyperbolic cosecant of a complex number | Excel 2013, Office 365 |
| 121 | IMDIV function | Returns the quotient of two complex numbers | Excel 2007,2010,2013, Office 365 |
| 122 | IMEXP function | Returns the exponential of a complex number | Excel 2007,2010,2013, Office 365 |
| 123 | IMLN function | Returns the natural logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 124 | IMLOG10 function | Returns the base-10 logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 125 | IMLOG2 function | Returns the base-2 logarithm of a complex number | Excel 2007,2010,2013, Office 365 |
| 126 | IMPOWER function | Returns a complex number raised to an integer power | Excel 2007,2010,2013, Office 365 |
| 127 | IMPRODUCT function | Returns the product of complex numbers | Excel 2007,2010,2013, Office 365 |
| 128 | IMREAL function | Returns the real coefficient of a complex number | Excel 2007,2010,2013, Office 365 |
| 129 | IMSEC function | Returns the secant of a complex number | Excel 2013, Office 365 |
| 130 | IMSECH function | Returns the hyperbolic secant of a complex number | Excel 2013, Office 365 |
| 131 | IMSIN function | Returns the sine of a complex number | Excel 2007,2010,2013, Office 365 |
| 132 | IMSINH function | Returns the hyperbolic sine of a complex number | Excel 2013, Office 365 |
| 133 | IMSQRT function | Returns the square root of a complex number | Excel 2007,2010,2013, Office 365 |
| 134 | IMSUB function | Returns the difference between two complex numbers | Excel 2007,2010,2013, Office 365 |
| 135 | IMSUM function | Returns the sum of complex numbers | Excel 2007,2010,2013, Office 365 |
| 136 | IMTAN function | Returns the tangent of a complex number | Excel 2013, Office 365 |
| 137 | OCT2BIN function | Converts an octal number to binary | Excel 2007,2010,2013, Office 365 |
| 138 | OCT2DEC function | Converts an octal number to decimal | Excel 2007,2010,2013, Office 365 |
| 139 | OCT2HEX function | Converts an octal number to hexadecimal | Excel 2007,2010,2013, Office 365 |
| 140 | ACCRINT function | Returns the accrued interest for a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 141 | ACCRINTM function | Returns the accrued interest for a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 142 | AMORDEGRC function | Returns the depreciation for each accounting period by using a depreciation coefficient | Excel 2007,2010,2013, Office 365 |
| 143 | AMORLINC function | Returns the depreciation for each accounting period | Excel 2007,2010,2013, Office 365 |
| 144 | COUPDAYBS function | Returns the number of days from the beginning of the coupon period to the settlement date | Excel 2007,2010,2013, Office 365 |
| 145 | COUPDAYS function | Returns the number of days in the coupon period that contains the settlement date | Excel 2007,2010,2013, Office 365 |
| 146 | COUPDAYSNC function | Returns the number of days from the settlement date to the next coupon date | Excel 2007,2010,2013, Office 365 |
| 147 | COUPNCD function | Returns the next coupon date after the settlement date | Excel 2007,2010,2013, Office 365 |
| 148 | COUPNUM function | Returns the number of coupons payable between the settlement date and maturity date | Excel 2007,2010,2013, Office 365 |
| 149 | COUPPCD function | Returns the previous coupon date before the settlement date | Excel 2007,2010,2013, Office 365 |
| 150 | CUMIPMT function | Returns the cumulative interest paid between two periods | Excel 2007,2010,2013, Office 365 |
| 151 | CUMPRINC function | Returns the cumulative principal paid on a loan between two periods | Excel 2007,2010,2013, Office 365 |
| 152 | DB function | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method | Excel 2007,2010,2013, Office 365 |
| 153 | DDB function | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify | Excel 2007,2010,2013, Office 365 |
| 154 | DISC function | Returns the discount rate for a security | Excel 2007,2010,2013, Office 365 |
| 155 | DOLLARDE function | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number | Excel 2007,2010,2013, Office 365 |
| 156 | DOLLARFR function | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction | Excel 2007,2010,2013, Office 365 |
| 157 | DURATION function | Returns the annual duration of a security with periodic interest payments | Excel 2007,2010,2013, Office 365 |
| 158 | EFFECT function | Returns the effective annual interest rate | Excel 2007,2010,2013, Office 365 |
| 159 | FV function | Returns the future value of an investment | Excel 2007,2010,2013, Office 365 |
| 160 | FVSCHEDULE function | Returns the future value of an initial principal after applying a series of compound interest rates | Excel 2007,2010,2013, Office 365 |
| 161 | INTRATE function | Returns the interest rate for a fully invested security | Excel 2007,2010,2013, Office 365 |
| 162 | IPMT function | Returns the interest payment for an investment for a given period | Excel 2007,2010,2013, Office 365 |
| 163 | IRR function | Returns the internal rate of return for a series of cash flows | Excel 2007,2010,2013, Office 365 |
| 164 | ISPMT function | Calculates the interest paid during a specific period of an investment | Excel 2007,2010,2013, Office 365 |
| 165 | MDURATION function | Returns the Macauley modified duration for a security with an assumed par value of $100 | Excel 2007,2010,2013, Office 365 |
| 166 | MIRR function | Returns the internal rate of return where positive and negative cash flows are financed at different rates | Excel 2007,2010,2013, Office 365 |
| 167 | NOMINAL function | Returns the annual nominal interest rate | Excel 2007,2010,2013, Office 365 |
| 168 | NPER function | Returns the number of periods for an investment | Excel 2007,2010,2013, Office 365 |
| 169 | NPV function | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate | Excel 2007,2010,2013, Office 365 |
| 170 | ODDFPRICE function | Returns the price per $100 face value of a security with an odd first period | Excel 2007,2010,2013, Office 365 |
| 171 | ODDFYIELD function | Returns the yield of a security with an odd first period | Excel 2007,2010,2013, Office 365 |
| 172 | ODDLPRICE function | Returns the price per $100 face value of a security with an odd last period | Excel 2007,2010,2013, Office 365 |
| 173 | ODDLYIELD function | Returns the yield of a security with an odd last period | Excel 2007,2010,2013, Office 365 |
| 174 | PDURATION function | Returns the number of periods required by an investment to reach a specified value | Excel 2013, Office 365 |
| 175 | PMT function | Returns the periodic payment for an annuity | Excel 2007,2010,2013, Office 365 |
| 176 | PPMT function | Returns the payment on the principal for an investment for a given period | Excel 2007,2010,2013, Office 365 |
| 177 | PRICE function | Returns the price per $100 face value of a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 178 | PRICEDISC function | Returns the price per $100 face value of a discounted security | Excel 2007,2010,2013, Office 365 |
| 179 | PRICEMAT function | Returns the price per $100 face value of a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 180 | PV function | Returns the present value of an investment | Excel 2007,2010,2013, Office 365 |
| 181 | RATE function | Returns the interest rate per period of an annuity | Excel 2007,2010,2013, Office 365 |
| 182 | RECEIVED function | Returns the amount received at maturity for a fully invested security | Excel 2007,2010,2013, Office 365 |
| 183 | RRI function | Returns an equivalent interest rate for the growth of an investment | Excel 2013, Office 365 |
| 184 | SLN function | Returns the straight-line depreciation of an asset for one period | Excel 2007,2010,2013, Office 365 |
| 185 | SYD function | Returns the sum-of-years' digits depreciation of an asset for a specified period | Excel 2007,2010,2013, Office 365 |
| 186 | TBILLEQ function | Returns the bond-equivalent yield for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 187 | TBILLPRICE function | Returns the price per $100 face value for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 188 | TBILLYIELD function | Returns the yield for a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 189 | VDB function | Returns the depreciation of an asset for a specified or partial period by using a declining balance method | Excel 2007,2010,2013, Office 365 |
| 190 | XIRR function | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic | Excel 2007,2010,2013, Office 365 |
| 191 | XNPV function | Returns the net present value for a schedule of cash flows that is not necessarily periodic | Excel 2007,2010,2013, Office 365 |
| 192 | YIELD function | Returns the yield on a security that pays periodic interest | Excel 2007,2010,2013, Office 365 |
| 193 | YIELDDISC function | Returns the annual yield for a discounted security; for example, a Treasury bill | Excel 2007,2010,2013, Office 365 |
| 194 | YIELDMAT function | Returns the annual yield of a security that pays interest at maturity | Excel 2007,2010,2013, Office 365 |
| 195 | CELL function | Returns information about the formatting, location, or contents of a cell AND This function is not available in Excel for the web. | Excel 2007,2010,2013, Office 365 |
| 196 | ERROR.TYPE function | Returns a number corresponding to an error type | Excel 2007,2010,2013, Office 365 |
| 197 | INFO function | Returns information about the current operating environmentThis function is not available in Excel for the web. | Excel 2007,2010,2013, Office 365 |
| 198 | ISBLANK function | Returns TRUE if the value is blank | Excel 2007,2010,2013, Office 365 |
| 199 | ISERR function | Returns TRUE if the value is any error value except #N/A | Excel 2007,2010,2013, Office 365 |
| 200 | ISERROR function | Returns TRUE if the value is any error value | Excel 2007,2010,2013, Office 365 |
| 201 | ISEVEN function | Returns TRUE if the number is even | Excel 2007,2010,2013, Office 365 |
| 202 | ISFORMULA function | Returns TRUE if there is a reference to a cell that contains a formula | Excel 2013, Office 365 |
| 203 | ISLOGICAL function | Returns TRUE if the value is a logical value | Excel 2007,2010,2013, Office 365 |
| 204 | ISNA function | Returns TRUE if the value is the #N/A error value | Excel 2007,2010,2013, Office 365 |
| 205 | ISNONTEXT function | Returns TRUE if the value is not text | Excel 2007,2010,2013, Office 365 |
| 206 | ISNUMBER function | Returns TRUE if the value is a number | Excel 2007,2010,2013, Office 365 |
| 207 | ISODD function | Returns TRUE if the number is odd | Excel 2007,2010,2013, Office 365 |
| 208 | ISREF function | Returns TRUE if the value is a reference | Excel 2007,2010,2013, Office 365 |
| 209 | ISTEXT function | Returns TRUE if the value is text | Excel 2007,2010,2013, Office 365 |
| 210 | N function | Returns a value converted to a number | Excel 2007,2010,2013, Office 365 |
| 211 | NA function | Returns the error value #N/A | Excel 2007,2010,2013, Office 365 |
| 212 | SHEET function | Returns the sheet number of the referenced sheet | Excel 2013, Office 365 |
| 213 | SHEETS function | Returns the number of sheets in a reference | Excel 2013, Office 365 |
| 214 | TYPE function | Returns a number indicating the data type of a value | Excel 2007,2010,2013, Office 365 |
| 215 | AND function | Returns TRUE if all of its arguments are TRUE | Excel 2007,2010,2013, Office 365 |
| 216 | FALSE function | Returns the logical value FALSE | Excel 2007,2010,2013, Office 365 |
| 217 | IF function | Specifies a logical test to perform | Excel 2007,2010,2013, Office 365 |
| 218 | IFERROR function | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula | Excel 2007,2010,2013, Office 365 |
| 219 | IFNA function | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression | Excel 2013, Office 365 |
| 220 | IFS function | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. | Excel 2007,2010,2013, Office 365 |
| 221 | NOT function | Reverses the logic of its argument | Excel 2007,2010,2013, Office 365 |
| 222 | OR function | Returns TRUE if any argument is TRUE | Excel 2007,2010,2013, Office 365 |
| 223 | SWITCH function | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. | Excel 2016 |
| 224 | TRUE function | Returns the logical value TRUE | Excel 2007,2010,2013, Office 365 |
| 225 | XOR function | Returns a logical exclusive OR of all arguments | Excel 2013, Office 365 |
| 226 | ADDRESS function | Returns a reference as text to a single cell in a worksheet | Excel 2007,2010,2013, Office 365 |
| 227 | AREAS function | Returns the number of areas in a reference | Excel 2007,2010,2013, Office 365 |
| 228 | CHOOSE function | Chooses a value from a list of values | Excel 2007,2010,2013, Office 365 |
| 229 | COLUMN function | Returns the column number of a reference | Excel 2007,2010,2013, Office 365 |
| 230 | COLUMNS function | Returns the number of columns in a reference | Excel 2007,2010,2013, Office 365 |
| 231 | FILTER function | Filters a range of data based on criteria you define | Office 365 button |
| 232 | FORMULATEXT function | Returns the formula at the given reference as text | Excel 2013, Office 365 |
| 233 | GETPIVOTDATA function | Returns data stored in a PivotTable report | Excel 2007,2010,2013, Office 365 |
| 234 | HLOOKUP function | Looks in the top row of an array and returns the value of the indicated cell | Excel 2007,2010,2013, Office 365 |
| 235 | HYPERLINK function | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | Excel 2007,2010,2013, Office 365 |
| 236 | INDEX function | Uses an index to choose a value from a reference or array | Excel 2007,2010,2013, Office 365 |
| 237 | INDIRECT function | Returns a reference indicated by a text value | Excel 2007,2010,2013, Office 365 |
| 238 | LOOKUP function | Looks up values in a vector or array | Excel 2007,2010,2013, Office 365 |
| 239 | MATCH function | Looks up values in a reference or array | Excel 2007,2010,2013, Office 365 |
| 240 | OFFSET function | Returns a reference offset from a given reference | Excel 2007,2010,2013, Office 365 |
| 241 | ROW function | Returns the row number of a reference | Excel 2007,2010,2013, Office 365 |
| 242 | ROWS function | Returns the number of rows in a reference | Excel 2007,2010,2013, Office 365 |
| 243 | RTD function | Retrieves real-time data from a program that supports COM automation | Excel 2007,2010,2013, Office 365 |
| 244 | SORT function | Sorts the contents of a range or array | Office 365 button |
| 245 | SORTBY function | Sorts the contents of a range or array based on the values in a corresponding range or array | Office 365 button |
| 246 | TRANSPOSE function | Returns the transpose of an array | Excel 2007,2010,2013, Office 365 |
| 247 | UNIQUE function | Returns a list of unique values in a list or range | Office 365 button |
| 248 | VLOOKUP function | Looks in the first column of an array and moves across the row to return the value of a cell | Excel 2007,2010,2013, Office 365 |
| 249 | XLOOKUP function | Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. | Office 365 button |
| 250 | XMATCH function | Returns the relative position of an item in an array or range of cells. | Office 365 button |
| 251 | ABS function | Returns the absolute value of a number | Excel 2007,2010,2013, Office 365 |
| 252 | ACOS function | Returns the arccosine of a number | Excel 2007,2010,2013, Office 365 |
| 253 | ACOSH function | Returns the inverse hyperbolic cosine of a number | Excel 2007,2010,2013, Office 365 |
| 254 | ACOT function | Returns the arccotangent of a number | Excel 2013, Office 365 |
| 255 | ACOTH function | Returns the hyperbolic arccotangent of a number | Excel 2013, Office 365 |
| 256 | AGGREGATE function | Returns an aggregate in a list or database | Excel 2007,2010,2013, Office 365 |
| 257 | ARABIC function | Converts a Roman number to Arabic, as a number | Excel 2013, Office 365 |
| 258 | ASIN function | Returns the arcsine of a number | Excel 2007,2010,2013, Office 365 |
| 259 | ASINH function | Returns the inverse hyperbolic sine of a number | Excel 2007,2010,2013, Office 365 |
| 260 | ATAN function | Returns the arctangent of a number | Excel 2007,2010,2013, Office 365 |
| 261 | ATAN2 function | Returns the arctangent from x- and y-coordinates | Excel 2007,2010,2013, Office 365 |
| 262 | ATANH function | Returns the inverse hyperbolic tangent of a number | Excel 2007,2010,2013, Office 365 |
| 263 | BASE function | Converts a number into a text representation with the given radix (base) | Excel 2007,2010,2013, Office 365 |
| 264 | CEILING function | Rounds a number to the nearest integer or to the nearest multiple of significance | Excel 2007,2010,2013, Office 365 |
| 265 | CEILING.MATH function | Rounds a number up, to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 266 | CEILING.PRECISE function | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | Excel 2007,2010,2013, Office 365 |
| 267 | COMBIN function | Returns the number of combinations for a given number of objects | Excel 2007,2010,2013, Office 365 |
| 268 | COMBINA function | eturns the number of combinations with repetitions for a given number of items | Excel 2013, Office 365 |
| 269 | COS function | Returns the cosine of a number | Excel 2007,2010,2013, Office 365 |
| 270 | COSH function | Returns the hyperbolic cosine of a number | Excel 2007,2010,2013, Office 365 |
| 271 | COT function | Returns the hyperbolic cosine of a number | Excel 2013, Office 365 |
| 272 | COTH function | Returns the cotangent of an angle | Excel 2013, Office 365 |
| 273 | CSC function | Returns the cosecant of an angle | Excel 2013, Office 365 |
| 274 | CSCH function | Returns the hyperbolic cosecant of an angle | Excel 2013, Office 365 |
| 275 | DECIMAL function | Converts a text representation of a number in a given base into a decimal number | Excel 2013, Office 365 |
| 276 | DEGREES function | Converts radians to degrees | Excel 2007,2010,2013, Office 365 |
| 277 | EVEN function | Rounds a number up to the nearest even integer | Excel 2007,2010,2013, Office 365 |
| 278 | EXP function | Returns e raised to the power of a given number | Excel 2007,2010,2013, Office 365 |
| 279 | FACT function | Returns the factorial of a number | Excel 2007,2010,2013, Office 365 |
| 280 | FACTDOUBLE function | Returns the double factorial of a number | Excel 2007,2010,2013, Office 365 |
| 281 | FLOOR.MATH function | Rounds a number down, to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 282 | FLOOR.PRECISE function | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. | Excel 2007,2010,2013, Office 365 |
| 283 | GCD function | Returns the greatest common divisor | Excel 2007,2010,2013, Office 365 |
| 284 | INT function | Rounds a number down to the nearest integer | Excel 2007,2010,2013, Office 365 |
| 285 | ISO.CEILING function | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance | Excel 2013, Office 365 |
| 286 | LCM function | Returns the least common multiple | Excel 2007,2010,2013, Office 365 |
| 287 | LN function | Returns the natural logarithm of a number | Excel 2007,2010,2013, Office 365 |
| 288 | LOG function | Returns the logarithm of a number to a specified base | Excel 2007,2010,2013, Office 365 |
| 289 | LOG10 function | Returns the base-10 logarithm of a number | Excel 2007,2010,2013, Office 365 |
| 290 | MDETERM function | Returns the matrix determinant of an array | Excel 2007,2010,2013, Office 365 |
| 291 | MINVERSE function | Returns the matrix inverse of an array | Excel 2007,2010,2013, Office 365 |
| 292 | MMULT function | Returns the matrix product of two arrays | Excel 2007,2010,2013, Office 365 |
| 293 | MOD function | Returns the remainder from division | Excel 2007,2010,2013, Office 365 |
| 294 | MROUND function | Returns a number rounded to the desired multiple | Excel 2007,2010,2013, Office 365 |
| 295 | MULTINOMIAL function | Returns the multinomial of a set of numbers | Excel 2007,2010,2013, Office 365 |
| 296 | MUNIT function | Returns the unit matrix or the specified dimension | Excel 2013, Office 365 |
| 297 | ODD function | Rounds a number up to the nearest odd integer | Excel 2007,2010,2013, Office 365 |
| 298 | PI function | Returns the value of pi | Excel 2007,2010,2013, Office 365 |
| 299 | POWER function | Returns the result of a number raised to a power | Excel 2007,2010,2013, Office 365 |
| 300 | PRODUCT function | Multiplies its arguments | Excel 2007,2010,2013, Office 365 |
| 301 | QUOTIENT function | Returns the integer portion of a division | Excel 2007,2010,2013, Office 365 |
| 302 | RADIANS function | Converts degrees to radians | Excel 2007,2010,2013, Office 365 |
| 303 | RAND function | Returns a random number between 0 and 1 | Excel 2007,2010,2013, Office 365 |
| 304 | RANDARRAY function | Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. | Office 365 button |
| 305 | RANDBETWEEN function | Returns a random number between the numbers you specify | Excel 2007,2010,2013, Office 365 |
| 306 | ROMAN function | Converts an arabic numeral to roman, as text | Excel 2007,2010,2013, Office 365 |
| 307 | ROUND function | Rounds a number to a specified number of digits | Excel 2007,2010,2013, Office 365 |
| 308 | ROUNDDOWN function | Rounds a number down, toward zero | Excel 2007,2010,2013, Office 365 |
| 309 | ROUNDUP function | Rounds a number up, away from zero | Excel 2007,2010,2013, Office 365 |
| 310 | SEC function | Returns the secant of an angle | Excel 2013, Office 365 |
| 311 | SECH function | Returns the hyperbolic secant of an angle | Excel 2013, Office 365 |
| 312 | SEQUENCE function | Generates a list of sequential numbers in an array, such as 1, 2, 3, 4 | Office 365 button |
| 313 | SERIESSUM function | Returns the sum of a power series based on the formula | Excel 2007,2010,2013, Office 365 |
| 314 | SIGN function | Returns the sign of a number | Excel 2007,2010,2013, Office 365 |
| 315 | SIN function | Returns the sine of the given angle | Excel 2007,2010,2013, Office 365 |
| 316 | SINH function | Returns the hyperbolic sine of a number | Excel 2007,2010,2013, Office 365 |
| 317 | SQRT function | Returns a positive square root | Excel 2007,2010,2013, Office 365 |
| 318 | SQRTPI function | Returns the square root of (number * pi) | Excel 2007,2010,2013, Office 365 |
| 319 | SUBTOTAL function | Returns a subtotal in a list or database | Excel 2007,2010,2013, Office 365 |
| 320 | SUM function | Adds its arguments | Excel 2007,2010,2013, Office 365 |
| 321 | SUMIF function | Adds the cells specified by a given criteria | Excel 2007,2010,2013, Office 365 |
| 322 | SUMIFS function | Adds the cells in a range that meet multiple criteria | Excel 2007,2010,2013, Office 365 |
| 323 | SUMPRODUCT function | Returns the sum of the products of corresponding array components | Excel 2007,2010,2013, Office 365 |
| 324 | SUMSQ function | Returns the sum of the squares of the arguments | Excel 2007,2010,2013, Office 365 |
| 325 | SUMX2MY2 function | Returns the sum of the difference of squares of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 326 | SUMX2PY2 function | Returns the sum of the sum of squares of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 327 | SUMXMY2 function | Returns the sum of squares of differences of corresponding values in two arrays | Excel 2007,2010,2013, Office 365 |
| 328 | TAN function | Returns the tangent of a number | Excel 2007,2010,2013, Office 365 |
| 329 | TANH function | Returns the hyperbolic tangent of a number | Excel 2007,2010,2013, Office 365 |
| 330 | TRUNC function | Truncates a number to an integer | Excel 2007,2010,2013, Office 365 |
| 331 | AVEDEV function | Returns the average of the absolute deviations of data points from their mean | Excel 2007,2010,2013, Office 365 |
| 332 | AVERAGE function | Returns the average of its arguments | Excel 2007,2010,2013, Office 365 |
| 333 | AVERAGEA function | Returns the average of its arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 334 | AVERAGEIF function | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria | Excel 2007,2010,2013, Office 365 |
| 335 | AVERAGEIFS function | Returns the average (arithmetic mean) of all cells that meet multiple criteria. | Excel 2007,2010,2013, Office 365 |
| 336 | BETA.DIST function | Returns the beta cumulative distribution function | Excel 2010, 2013, office 365 |
| 337 | BETA.INV function | Returns the inverse of the cumulative distribution function for a specified beta distribution | Excel 2010, 2013, office 365 |
| 338 | BINOM.DIST function | Returns the individual term binomial distribution probability | Excel 2010, 2013, office 365 |
| 339 | BINOM.DIST.RANGE function | Returns the probability of a trial result using a binomial distribution | Excel 2013, Office 365 |
| 340 | BINOM.INV function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | Excel 2010, 2013, office 365 |
| 341 | CHISQ.DIST function | Returns the cumulative beta probability density function | Excel 2010, 2013, office 365 |
| 342 | CHISQ.DIST.RT function | Returns the one-tailed probability of the chi-squared distribution | Excel 2010, 2013, office 365 |
| 343 | CHISQ.INV function | Returns the cumulative beta probability density function | Excel 2010, 2013, office 365 |
| 344 | CHISQ.INV.RT function | Returns the inverse of the one-tailed probability of the chi-squared distribution | Excel 2010, 2013, office 365 |
| 345 | CHISQ.TEST function | Returns the test for independence | Excel 2010, 2013, office 365 |
| 346 | CONFIDENCE.NORM function | Returns the confidence interval for a population mean | Excel 2010, 2013, office 365 |
| 347 | CONFIDENCE.T function | Returns the confidence interval for a population mean, using a Student's t distribution | Excel 2010, 2013, office 365 |
| 348 | CORREL function | Returns the correlation coefficient between two data sets | Excel 2007,2010,2013, Office 365 |
| 349 | COUNT function | Counts how many numbers are in the list of arguments | Excel 2007,2010,2013, Office 365 |
| 350 | COUNTA function | Counts how many values are in the list of arguments | Excel 2007,2010,2013, Office 365 |
| 351 | COUNTBLANK function | Counts the number of blank cells within a range | Excel 2007,2010,2013, Office 365 |
| 352 | COUNTIF function | Counts the number of cells within a range that meet the given criteria | Excel 2007,2010,2013, Office 365 |
| 353 | COUNTIFS function | Counts the number of cells within a range that meet multiple criteria | Excel 2007,2010,2013, Office 365 |
| 354 | COVARIANCE.P function | Returns covariance, the average of the products of paired deviations | Excel 2010, 2013, office 365 |
| 355 | COVARIANCE.S function | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets | Excel 2010, 2013, office 365 |
| 356 | DEVSQ function | Returns the sum of squares of deviations | Excel 2007,2010,2013, Office 365 |
| 357 | EXPON.DIST function | Returns the exponential distribution | Excel 2010, 2013, office 365 |
| 358 | F.DIST function | Returns the F probability distribution | Excel 2010, 2013, office 365 |
| 359 | F.DIST.RT function | Returns the F probability distribution | Excel 2010, 2013, office 365 |
| 360 | F.INV function | Returns the inverse of the F probability distribution | Excel 2010, 2013, office 365 |
| 361 | F.INV.RT function | Returns the inverse of the F probability distribution | Excel 2010, 2013, office 365 |
| 362 | F.TEST function | Returns the result of an F-test | Excel 2010, 2013, office 365 |
| 363 | FINV function | Returns the inverse of the F probability distribution | Excel 2007,2010,2013, Office 365 |
| 364 | FISHER function | Returns the Fisher transformation | Excel 2007,2010,2013, Office 365 |
| 365 | FISHERINV function | Returns the inverse of the Fisher transformation | Excel 2007,2010,2013, Office 365 |
| 366 | FORECAST function | Returns a value along a linear trendIn Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions. | Excel 2007,2010,2013, Office 365 |
| 367 | FORECAST.ETS function | Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm | Excel 2016 |
| 368 | FORECAST.ETS.CONFINT function | Returns a confidence interval for the forecast value at the specified target date | Excel 2016 |
| 369 | FORECAST.ETS.SEASONALITY function | Returns the length of the repetitive pattern Excel detects for the specified time series | Excel 2016 |
| 370 | FORECAST.ETS.STAT function | Returns a statistical value as a result of time series forecasting | Excel 2016 |
| 371 | FORECAST.LINEAR function | Returns a future value based on existing values | Excel 2016 |
| 372 | FREQUENCY function | Returns a frequency distribution as a vertical array | Excel 2007,2010,2013, Office 365 |
| 373 | GAMMA function | Returns the Gamma function value | Excel 2013, Office 365 |
| 374 | GAMMA.DIST function | Returns the gamma distribution | Excel 2010, 2013, office 365 |
| 375 | GAMMA.INV function | Returns the inverse of the gamma cumulative distribution | Excel 2010, 2013, office 365 |
| 376 | GAMMALN function | Returns the natural logarithm of the gamma function, Γ(x) | Excel 2007,2010,2013, Office 365 |
| 377 | GAMMALN.PRECISE function | Returns the natural logarithm of the gamma function, Γ(x) | Excel 2010, 2013, office 365 |
| 378 | GAUSS function | Returns 0.5 less than the standard normal cumulative distribution | Excel 2013, Office 365 |
| 379 | GEOMEAN function | Returns the geometric mean | Excel 2007,2010,2013, Office 365 |
| 380 | GROWTH function | Returns values along an exponential trend | Excel 2007,2010,2013, Office 365 |
| 381 | HARMEAN function | Returns the harmonic mean | Excel 2007,2010,2013, Office 365 |
| 382 | HYPGEOM.DIST function | Returns the hypergeometric distribution | Excel 2007,2010,2013, Office 365 |
| 383 | INTERCEPT function | Returns the intercept of the linear regression line | Excel 2007,2010,2013, Office 365 |
| 384 | KURT function | Returns the kurtosis of a data set | Excel 2007,2010,2013, Office 365 |
| 385 | LARGE function | Returns the k-th largest value in a data set | Excel 2007,2010,2013, Office 365 |
| 386 | LINEST function | Returns the parameters of a linear trend | Excel 2007,2010,2013, Office 365 |
| 387 | LOGEST function | Returns the parameters of an exponential trend | Excel 2007,2010,2013, Office 365 |
| 388 | LOGNORM.DIST function | Returns the cumulative lognormal distribution | Excel 2010, 2013, office 365 |
| 389 | LOGNORM.INV function | Returns the inverse of the lognormal cumulative distribution | Excel 2010, 2013, office 365 |
| 390 | MAX function | Returns the maximum value in a list of arguments | Excel 2007,2010,2013, Office 365 |
| 391 | MAXA function | Returns the maximum value in a list of arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 392 | MAXIFS function | Returns the maximum value among cells specified by a given set of conditions or criteria | Excel 2007,2010,2013, Office 365 |
| 393 | MEDIAN function | Returns the median of the given numbers | Excel 2007,2010,2013, Office 365 |
| 394 | MIN function | Returns the minimum value in a list of arguments | Excel 2007,2010,2013, Office 365 |
| 395 | MINA function | Returns the smallest value in a list of arguments, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 396 | MINIFS function | Returns the minimum value among cells specified by a given set of conditions or criteria. | Excel 2007,2010,2013, Office 365 |
| 397 | MODE.MULT function | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data | Excel 2010, 2013, office 365 |
| 398 | MODE.SNGL function | Returns the most common value in a data set | Excel 2010, 2013, office 365 |
| 399 | NEGBINOM.DIST function | Returns the negative binomial distribution | Excel 2010, 2013, office 365 |
| 400 | NORM.DIST function | Returns the normal cumulative distribution | Excel 2010, 2013, office 365 |
| 401 | NORM.S.DIST function | Returns the standard normal cumulative distribution | Excel 2010, 2013, office 365 |
| 402 | NORM.S.INV function | Returns the inverse of the standard normal cumulative distribution | Excel 2010, 2013, office 365 |
| 403 | NORMINV function | Returns the inverse of the normal cumulative distribution | Excel 2007,2010,2013, Office 365 |
| 404 | PEARSON function | Returns the Pearson product moment correlation coefficient | Excel 2007,2010,2013, Office 365 |
| 405 | PERCENTILE.EXC function | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive | Excel 2010, 2013, office 365 |
| 406 | PERCENTILE.INC function | Returns the k-th percentile of values in a range | Excel 2010, 2013, office 365 |
| 407 | PERCENTRANK.EXC function | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set | Excel 2010, 2013, office 365 |
| 408 | PERCENTRANK.INC function | Returns the percentage rank of a value in a data set | Excel 2010, 2013, office 365 |
| 409 | PERMUT function | Returns the number of permutations for a given number of objects | Excel 2007,2010,2013, Office 365 |
| 410 | PERMUTATIONA function | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects | Excel 2013, Office 365 |
| 411 | PHI function | Returns the value of the density function for a standard normal distribution | Excel 2013, Office 365 |
| 412 | POISSON.DIST function | Returns the Poisson distribution | Excel 2010, 2013, office 365 |
| 413 | PROB function | Returns the probability that values in a range are between two limits | Excel 2007,2010,2013, Office 365 |
| 414 | QUARTILE.EXC function | Returns the quartile of the data set, based on percentile values from 0..1, exclusive | Excel 2010, 2013, office 365 |
| 415 | QUARTILE.INC function | Returns the quartile of a data set | Excel 2010, 2013, office 365 |
| 416 | RANK.AVG function | Returns the rank of a number in a list of numbers | Excel 2010, 2013, office 365 |
| 417 | RANK.EQ function | Returns the rank of a number in a list of numbers | Excel 2010, 2013, office 365 |
| 418 | RSQ function | Returns the square of the Pearson product moment correlation coefficient | Excel 2007,2010,2013, Office 365 |
| 419 | SKEW function | Returns the skewness of a distribution | Excel 2007,2010,2013, Office 365 |
| 420 | SKEW.P function | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean | Excel 2013, Office 365 |
| 421 | SLOPE function | Returns the slope of the linear regression line | Excel 2007,2010,2013, Office 365 |
| 422 | SMALL function | Returns the k-th smallest value in a data set | Excel 2007,2010,2013, Office 365 |
| 423 | STANDARDIZE function | Returns a normalized value | Excel 2007,2010,2013, Office 365 |
| 424 | STDEV.P function | Calculates standard deviation based on the entire population | Excel 2010, 2013, office 365 |
| 425 | STDEV.S function | Estimates standard deviation based on a sample | Excel 2010, 2013, office 365 |
| 426 | STDEVA function | Estimates standard deviation based on a sample, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 427 | STDEVPA function | Calculates standard deviation based on the entire population, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 428 | STEYX function | Returns the standard error of the predicted y-value for each x in the regression | Excel 2007,2010,2013, Office 365 |
| 429 | T.DIST function | Returns the Percentage Points (probability) for the Student t-distribution | Excel 2010, 2013, office 365 |
| 430 | T.DIST.2T function | Returns the Percentage Points (probability) for the Student t-distribution | Excel 2010, 2013, office 365 |
| 431 | T.DIST.RT function | Returns the Student's t-distribution | Excel 2010, 2013, office 365 |
| 432 | T.INV function | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom | Excel 2010, 2013, office 365 |
| 433 | T.INV.2T function | Returns the inverse of the Student's t-distribution | Excel 2010, 2013, office 365 |
| 434 | T.TEST function | Returns the probability associated with a Student's t-test | Excel 2010, 2013, office 365 |
| 435 | TREND function | Returns values along a linear trend | Excel 2007,2010,2013, Office 365 |
| 436 | TRIMMEAN function | Returns the mean of the interior of a data set | Excel 2007,2010,2013, Office 365 |
| 437 | VAR.P function | Calculates variance based on the entire population | Excel 2010, 2013, office 365 |
| 438 | VAR.S function | Estimates variance based on a sample | Excel 2010, 2013, office 365 |
| 439 | VARA function | Estimates variance based on a sample, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 440 | VARPA function | Calculates variance based on the entire population, including numbers, text, and logical values | Excel 2007,2010,2013, Office 365 |
| 441 | WEIBULL.DIST function | Returns the Weibull distribution | Excel 2010, 2013, office 365 |
| 442 | Z.TEST function | Returns the one-tailed probability-value of a z-test | Excel 2010, 2013, office 365 |
| 443 | ASC function | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | Excel 2007,2010,2013, Office 365 |
| 444 | BAHTTEXT function | Converts a number to text, using the ß (baht) currency format | Excel 2007,2010,2013, Office 365 |
| 445 | CHAR function | Returns the character specified by the code number | Excel 2007,2010,2013, Office 365 |
| 446 | CLEAN function | Removes all nonprintable characters from text | Excel 2007,2010,2013, Office 365 |
| 447 | CODE function | Returns a numeric code for the first character in a text string | Excel 2007,2010,2013, Office 365 |
| 448 | CONCAT function | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. | Excel 2007,2010,2013, Office 365 |
| 449 | CONCATENATE function | Joins several text items into one text item | Excel 2007,2010,2013, Office 365 |
| 450 | DBCS function | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters | Excel 2013, Office 365 |
| 451 | DOLLAR function | Converts a number to text, using the $ (dollar) currency format | Excel 2007,2010,2013, Office 365 |
| 452 | EXACT function | Checks to see if two text values are identical | Excel 2007,2010,2013, Office 365 |
| 453 | FIND, FINDB functions | Finds one text value within another (case-sensitive) | Excel 2007,2010,2013, Office 365 |
| 454 | FIXED function | Formats a number as text with a fixed number of decimals | Excel 2007,2010,2013, Office 365 |
| 455 | JIS function | hanges half-width (single-byte) characters within a string to full-width (double-byte) characters | Excel 2007,2010,2013, Office 365 |
| 456 | LEFT, LEFTB functions | Returns the leftmost characters from a text value | Excel 2007,2010,2013, Office 365 |
| 457 | LEN, LENB functions | Returns the number of characters in a text string | Excel 2007,2010,2013, Office 365 |
| 458 | LOWER function | Converts text to lowercase | Excel 2007,2010,2013, Office 365 |
| 459 | MID, MIDB functions | Returns a specific number of characters from a text string starting at the position you specify | Excel 2007,2010,2013, Office 365 |
| 460 | NUMBERVALUE function | Converts text to number in a locale-independent manner | Excel 2013, Office 365 |
| 461 | PHONETIC function | Extracts the phonetic (furigana) characters from a text string | Excel 2007,2010,2013, Office 365 |
| 462 | PROPER function | Capitalizes the first letter in each word of a text value | Excel 2007,2010,2013, Office 365 |
| 463 | REPLACE, REPLACEB functions | Replaces characters within text | Excel 2007,2010,2013, Office 365 |
| 464 | REPT function | Repeats text a given number of times | Excel 2007,2010,2013, Office 365 |
| 465 | RIGHT, RIGHTB functions | Returns the rightmost characters from a text value | Excel 2007,2010,2013, Office 365 |
| 466 | SEARCH, SEARCHB functions | Finds one text value within another (not case-sensitive) | Excel 2007,2010,2013, Office 365 |
| 467 | SUBSTITUTE function | Substitutes new text for old text in a text string | Excel 2007,2010,2013, Office 365 |
| 468 | T function | Converts its arguments to text | Excel 2007,2010,2013, Office 365 |
| 469 | TEXT function | Formats a number and converts it to text | Excel 2007,2010,2013, Office 365 |
| 470 | TEXTJOIN function | Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. | Excel 2007,2010,2013, Office 365 |
| 471 | TRIM function | Removes spaces from text | Excel 2007,2010,2013, Office 365 |
| 472 | UNICHAR function | Returns the Unicode character that is references by the given numeric value | Excel 2013, Office 365 |
| 473 | UNICODE function | Returns the number (code point) that corresponds to the first character of the text | Excel 2013, Office 365 |
| 474 | UPPER function | Converts text to uppercase | Excel 2007,2010,2013, Office 365 |
| 475 | VALUE function | Converts a text argument to a number | Excel 2007,2010,2013, Office 365 |
| 476 | ENCODEURL function | Returns a URL-encoded stringThis function is not available in Excel for the web. | Excel 2013, Office 365 |
| 477 | FILTERXML function | Returns specific data from the XML content by using the specified XPathThis function is not available in Excel for the web. | Excel 2013, Office 365 |
| 478 | WEBSERVICE function | Returns data from a web service.This function is not available in Excel for the web. | Excel 2013, Office 365 |
400+ Excel Functions list with detailed description of function with Type and Version supported
Reference: https://docs.microsoft.com/470+ Excel Functions list with detailed description of function with Type and Version supported
Reference: https://docs.microsoft.com/