# List of Excel Formulas

## Full List of EXCEL Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on
www.Myelesson.org

### Formula Name and Description of the Excel Formula

1 ABS function Math and trigonometry: Returns the absolute value of a number

2 ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest

3 ACCRINTM function Financial: Returns the accrued interest for a security that pays Interest at maturity

4 ACOS function Math and trigonometry: Returns the arccosine of a number

5 ACOSH function Math and trigonometry: Returns the inverse hyperbolic cosine of a number

6 ADDRESS function Lookup and reference: Returns a reference as text to a single cell in a worksheet

7 AMORDEGRC function Financial: Returns the depreciation for each accounting period by using a depreciation coefficient

8 AMORLINC function Financial: Returns the depreciation for each accounting period AND function Logical: Returns TRUE if all of its arguments are TRUE

9 AREAS function Lookup and reference: Returns the number of areas in a reference

10 ASC function Text: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

11 ASIN function Math and trigonometry: Returns the arcsine of a number

12 ASINH function Math and trigonometry: Returns the inverse hyperbolic sine of a number

13 ATAN function Math and trigonometry: Returns the arctangent of a number

14 ATAN2 function Math and trigonometry: Returns the arctangent from x- and ycoordinates

15 ATANH function Math and trigonometry: Returns the inverse hyperbolic tangent of a number

16 AVEDEV function Statistical: Returns the average of the absolute deviations of data points from their mean

17 AVERAGE function Statistical: Returns the average of its arguments

18 AVERAGEA function Statistical: Returns the average of its arguments, including numbers, text, and logical values

19 AVERAGEIF function Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

20 AVERAGEIFS function Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.

21 BAHTTEXT function Text: Converts a number to text, using the ß (baht) currency format

22 BESSELI function Engineering: Returns the modified Bessel function In(x)

23 BESSELJ function Engineering: Returns the Bessel function Jn(x)

24 BESSELK function Engineering: Returns the modified Bessel function Kn(x)

25 BESSELY function Engineering: Returns the Bessel function Yn(x)

26 BETADIST function Statistical: Returns the beta cumulative distribution function

27 BETAINV function Statistical: Returns the inverse of the cumulative distribution function for a specified beta distribution

28 BIN2DEC function Engineering: Converts a binary number to decimal

29 BIN2HEX function Engineering: Converts a binary number to hexadecimal

30 BIN2OCT function Engineering: Converts a binary number to octal

31 BINOMDIST function Statistical: Returns the individual term binomial distribution probability

32 CALL function Add-in and Automation: Calls a procedure in a dynamic link library or code resource

33 CEILING function Math and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance

34 CELL function Information: Returns information about the formatting, location, or contents of a cell

35 CHAR function Text: Returns the character specified by the code number

36 CHIDIST function Statistical: Returns the one-tailed probability of the chi-squared distribution

37 CHIINV function Statistical: Returns the inverse of the one-tailed probability of the chi-squared distribution

38 CHITEST function Statistical: Returns the test for independence

39 CHOOSE function Lookup and reference: Chooses a value from a list of values

40 CLEAN function Text: Removes all nonprintable characters from text

41 CODE function Text: Returns a numeric code for the first character in a text string

42 COLUMN function Lookup and reference: Returns the column number of a reference

43 COLUMNS function Lookup and reference: Returns the number of columns in a reference

44 COMBIN function Math and trigonometry: Returns the number of combinations for a given number of objects

45 COMPLEX function Engineering: Converts real and imaginary coefficients into a complex number

46 CONCATENATE function Text: Joins several text items into one text item

47 CONFIDENCE function Statistical: Returns the confidence interval for a population mean

48 CONVERT function Engineering: Converts a number from one measurement system to another

49 CORREL function Statistical: Returns the correlation coefficient between two data sets

50 COS function Math and trigonometry: Returns the cosine of a number

51 COSH function Math and trigonometry: Returns the hyperbolic cosine of a number

52 COUNT function Statistical: Counts how many numbers are in the list of arguments

53 COUNTA function Statistical: Counts how many values are in the list of arguments

54 COUNTBLANK function Statistical: Counts the number of blank cells within a range

55 COUNTIF function Statistical: Counts the number of cells within a range that meet the given criteria

56 COUNTIFS function Statistical: Counts the number of cells within a range that meet multiple criteria

57 COUPDAYBS function Financial: Returns the number of days from the beginning of the coupon period to the settlement date

58 COUPDAYS function Financial: Returns the number of days in the coupon period that contains the settlement date

59 COUPDAYSNC function Financial: Returns the number of days from the settlement date to the next coupon date

60 COUPNCD function Financial: Returns the next coupon date after the settlement date

61 COUPNUM function Financial: Returns the number of coupons payable between the settlement date and maturity date

62 COUPPCD function Financial: Returns the previous coupon date before the settlement date

63 COVAR function Statistical: Returns covariance, the average of the products of paired deviations

64 CRITBINOM function Statistical: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

65 CUBEKPIMEMBER function Cube: Returns a key performance indicator (KPI) name, property, and
66 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.

67 CUBEMEMBER function Cube: Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.

68 CUBEMEMBERPROPERTY function

69 Cube: 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.

70 CUBERANKEDMEMBER function

71 Cube: 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.

72 CUBESET function Cube: Defines a calculated set of members or tuples by sending a set
73 expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.

74 CUBESETCOUNT function Cube: Returns the number of items in a set.

75 CUBEVALUE function Cube: Returns an aggregated value from a cube.

76 CUMIPMT function Financial: Returns the cumulative interest paid between two periods

77 CUMPRINC function Financial: Returns the cumulative principal paid on a loan between two periods

78 DATE function Date and time: Returns the serial number of a particular date

79 DATEVALUE function Date and time: Converts a date in the form of text to a serial number

80 DAVERAGE function Database: Returns the average of selected database entries

81 DAY function Date and time: Converts a serial number to a day of the month

82 DAYS360 function Date and time: Calculates the number of days between two dates based on a 360-day year

83 DB function Financial: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method

84 DCOUNT function Database: Counts the cells that contain numbers in a database

85 DCOUNTA function Database: Counts nonblank cells in a database

86 DDB function Financial: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify

87 DEC2BIN function Engineering: Converts a decimal number to binary

88 DEC2HEX function Engineering: Converts a decimal number to hexadecimal

89 DEC2OCT function Engineering: Converts a decimal number to octal

90 DEGREES function Math and trigonometry: Converts radians to degrees

91 DELTA function Engineering: Tests whether two values are equal

92 DEVSQ function Statistical: Returns the sum of squares of deviations

93 DGET function Database: Extracts from a database a single record that matches the specified criteria

94 DISC function Financial: Returns the discount rate for a security

95 DMAX function Database: Returns the maximum value from selected database entries

96 DMIN function Database: Returns the minimum value from selected database entries

97 DOLLAR function Text: Converts a number to text, using the \$ (dollar) currency format

98 DOLLARDE function Financial: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number

99 DOLLARFR function Financial: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction

100 DPRODUCT function Database: Multiplies the values in a particular field of records that match the criteria in a database

101 DSTDEV function Database: Estimates the standard deviation based on a sample of selected database entries

102 DSTDEVP function Database: Calculates the standard deviation based on the entire population of selected database entries

103 DSUM function Database: Adds the numbers in the field column of records in the database that match the criteria

104 DURATION function Financial: Returns the annual duration of a security with periodic interest payments

105 DVAR function Database: Estimates variance based on a sample from selected database entries

106 DVARP function Database: Calculates variance based on the entire population of selected database entries

107 EDATE function Date and time: Returns the serial number of the date that is the indicated number of months before or after the start date

108 EFFECT function Financial: Returns the effective annual interest rate

109 EOMONTH function Date and time: Returns the serial number of the last day of the month before or after a specified number of months

110 ERF function Engineering: Returns the error function

111 ERFC function Engineering: Returns the complementary error function

112 ERROR.TYPE function Information: Returns a number corresponding to an error type

113 EUROCONVERT function Add-in and Automation: Converts a number to euros, converts a number from euros to a euro member currency, or converts a number

114 from one euro member currency to another by using the euro as an intermediary (triangulation).

115 EVEN function Math and trigonometry: Rounds a number up to the nearest even integer

116 EXACT function Text: Checks to see if two text values are identical

117 EXP function Math and trigonometry: Returns e raised to the power of a given number

118 EXPONDIST function Statistical: Returns the exponential distribution

119 FACT function Math and trigonometry: Returns the factorial of a number

120 FACTDOUBLE function Math and trigonometry: Returns the double factorial of a number

121 FALSE function Logical: Returns the logical value FALSE

122 FDIST function Statistical: Returns the F probability distribution

123 FIND, FINDB functions Text: Finds one text value within another (case-sensitive)

124 FINV function Statistical: Returns the inverse of the F probability distribution

125 FISHER function Statistical: Returns the Fisher transformation

126 FISHERINV function Statistical: Returns the inverse of the Fisher transformation

127 FIXED function Text: Formats a number as text with a fixed number of decimals

128 FLOOR function Math and trigonometry: Rounds a number down, toward zero

129 FORECAST function Statistical: Returns a value along a linear trend

130 FREQUENCY function Statistical: Returns a frequency distribution as a vertical array

131 FTEST function Statistical:
132 FV function Financial: Returns the future value of an investment

133 FVSCHEDULE function Financial: Returns the future value of an initial principal after applying a series of compound interest rates

134 GAMMADIST function Statistical: Returns the gamma distribution

135 GAMMAINV function Statistical: Returns the inverse of the gamma cumulative distribution

136 GAMMALN function Statistical: Returns the natural logarithm of the gamma function, Γ(x)

137 GCD function Math and trigonometry: Returns the greatest common divisor

138 GEOMEAN function Statistical: Returns the geometric mean

139 GESTEP function Engineering: Tests whether a number is greater than a threshold value

140 GETPIVOTDATA function Add-in and Automation: Returns data stored in a PivotTable report

141 GROWTH function Statistical: Returns values along an exponential trend

142 HARMEAN function Statistical: Returns the harmonic mean

143 HEX2BIN function Engineering: Converts a hexadecimal number to binary

144 HEX2DEC function Engineering: Converts a hexadecimal number to decimal

145 HEX2OCT function Engineering: Converts a hexadecimal number to octal

146 HLOOKUP function Lookup and reference: Looks in the top row of an array and returns the value of the indicated cell

147 HOUR function Date and time: Converts a serial number to an hour

148 HYPERLINK function Lookup and reference: Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

149 HYPGEOMDIST function Statistical: Returns the hypergeometric distribution

150 IF function Logical: Specifies a logical test to perform

151 IFERROR function Logical: Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

152 IMABS function Engineering: Returns the absolute value (modulus) of a complex number

153 IMAGINARY function Engineering: Returns the imaginary coefficient of a complex number

154 IMARGUMENT function Engineering: Returns the argument theta, an angle expressed in radians

155 IMCONJUGATE function Engineering: Returns the complex conjugate of a complex number

156 IMCOS function Engineering: Returns the cosine of a complex number

157 IMDIV function Engineering: Returns the quotient of two complex numbers

158 IMEXP function Engineering: Returns the exponential of a complex number

159 IMLN function Engineering: Returns the natural logarithm of a complex number

160 IMLOG10 function Engineering: Returns the base-10 logarithm of a complex number

161 IMLOG2 function Engineering: Returns the base-2 logarithm of a complex number

162 IMPOWER function Engineering: Returns a complex number raised to an integer power

163 IMPRODUCT function Engineering: Returns the product of complex numbers

164 IMREAL function Engineering: Returns the real coefficient of a complex number

165 IMSIN function Engineering: Returns the sine of a complex number

166 IMSQRT function Engineering: Returns the square root of a complex number

167 IMSUB function Engineering: Returns the difference between two complex numbers

168 IMSUM function Engineering: Returns the sum of complex numbers

169 INDEX function Lookup and reference: Uses an index to choose a value from a reference or array

170 INDIRECT function Lookup and reference: Returns a reference indicated by a text value

171 INFO function Information: Returns information about the current operating environment

172 INT function Math and trigonometry: Rounds a number down to the nearest integer

173 INTERCEPT function Statistical: Returns the intercept of the linear regression line

174 INTRATE function Financial: Returns the interest rate for a fully invested security

175 IPMT function Financial: Returns the interest payment for an investment for a given period

176 IRR function Financial: Returns the internal rate of return for a series of cash flows

177 IS functions Provides comprehensive information about the  individual functions shown in the list on the right.

179 Information: For each of the following functions, returns TRUE based  on the specified condition.

181 ISBLANK Returns TRUE if the value is blank

182 ISERR Returns TRUE if the value is any error value except #N/A

183 ISERROR Returns TRUE if the value is any error value

184 ISEVEN Returns TRUE if the number is even

185 ISLOGICAL Returns TRUE if the value is a logical value

186 ISNA Returns TRUE if the value is the #N/A error value

187 ISNONTEXT Returns TRUE if the value is not text

188 ISNUMBER Returns TRUE if the value is a number

189 ISODD Returns TRUE if the number is odd

190 ISREF Returns TRUE if the value is a reference

191 ISTEXT Returns TRUE if the value is text

192 ISPMT function Financial: Calculates the interest paid during a specific period of an investment

193 JIS function Text: Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters

194 KURT function Statistical: Returns the kurtosis of a data set

195 LARGE function Statistical: Returns the k-th largest value in a data set

196 LCM function Math and trigonometry: Returns the least common multiple

197 LEFT, LEFTB functions Text: Returns the leftmost characters from a text value

198 LEN, LENB functions Text: Returns the number of characters in a text string

199 LINEST function Statistical: Returns the parameters of a linear trend

200 LN function Math and trigonometry: Returns the natural logarithm of a number

201 LOG function Math and trigonometry: Returns the logarithm of a number to a specified base

202 LOG10 function Math and trigonometry: Returns the base-10 logarithm of a number

203 LOGEST function Statistical: Returns the parameters of an exponential trend

204 LOGINV function Statistical: Returns the inverse of the lognormal distribution

205 LOGNORMDIST function Statistical: Returns the cumulative lognormal distribution

206 LOOKUP function Lookup and reference: Looks up values in a vector or array

207 LOWER function Text: Converts text to lowercase

208 MATCH function Lookup and reference: Looks up values in a reference or array

209 MAX function Statistical: Returns the maximum value in a list of arguments

210 MAXA function Statistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values

211 MDETERM function Math and trigonometry: Returns the matrix determinant of an array

212 MDURATION function Financial: Returns the Macauley modified duration for a security with an assumed par value of \$100

213 MEDIAN function Statistical: Returns the median of the given numbers

214 MID, MIDB functions Text: Returns a specific number of characters from a text string starting at the position you specify

215 MIN function Statistical: Returns the minimum value in a list of arguments

216 MINA function Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values

217 MINUTE function Date and time: Converts a serial number to a minute

218 MINVERSE function Math and trigonometry: Returns the matrix inverse of an array

219 MIRR function Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates

220 MMULT function Math and trigonometry: Returns the matrix product of two arrays

221 MOD function Math and trigonometry: Returns the remainder from division

222 MODE function Statistical: Returns the most common value in a data set

223 MONTH function Date and time: Converts a serial number to a month

224 MROUND function Math and trigonometry: Returns a number rounded to the desired multiple

225 MULTINOMIAL function Math and trigonometry: Returns the multinomial of a set of numbers

226 N function Information: Returns a value converted to a number

227 NA function Information: Returns the error value #N/A

228 NEGBINOMDIST function Statistical: Returns the negative binomial distribution

229 NETWORKDAYS function Date and time: Returns the number of whole workdays between two dates

230 NOMINAL function Financial: Returns the annual nominal interest rate

231 NORMDIST function Statistical: Returns the normal cumulative distribution

232 NORMINV function Statistical: Returns the inverse of the normal cumulative distribution

233 NORMSDIST function Statistical: Returns the standard normal cumulative distribution

234 NORMSINV function Statistical: Returns the inverse of the standard normal cumulative distribution

235 NOT function Logical: Reverses the logic of its argument

236 NOW function Date and time: Returns the serial number of the current date and time

237 NPER function Financial: Returns the number of periods for an investment

238 NPV function Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate

239 OCT2BIN function Engineering: Converts an octal number to binary

240 OCT2DEC function Engineering: Converts an octal number to decimal

241 OCT2HEX function Engineering: Converts an octal number to hexadecimal

242 ODD function Math and trigonometry: Rounds a number up to the nearest odd integer

243 ODDFPRICE function Financial: Returns the price per \$100 face value of a security with an odd first period

244 ODDFYIELD function Financial: Returns the yield of a security with an odd first period

245 ODDLPRICE function Financial: Returns the price per \$100 face value of a security with an odd last period

246 ODDLYIELD function Financial: Returns the yield of a security with an odd last period

247 OFFSET function Lookup and reference: Returns a reference offset from a given reference

248 OR function Logical: Returns TRUE if any argument is TRUE

249 PEARSON function Statistical: Returns the Pearson product moment correlation coefficient

250 PERCENTILE function Statistical: Returns the k-th percentile of values in a range

251 PERCENTRANK function Statistical: Returns the percentage rank of a value in a data set

252 PERMUT function Statistical: Returns the number of permutations for a given number of objects

253 PHONETIC function Text: Extracts the phonetic (furigana) characters from a text string

254 PI function Math and trigonometry: Returns the value of pi

255 PMT function Financial: Returns the periodic payment for an annuity

256 POISSON function Statistical: Returns the Poisson distribution

257 POWER function Math and trigonometry: Returns the result of a number raised to a power

258 PPMT function Financial: Returns the payment on the principal for an investment for a given period

259 PRICE function Financial: Returns the price per \$100 face value of a security that pays periodic interest

260 PRICEDISC function Financial: Returns the price per \$100 face value of a discounted security

261 PRICEMAT function Financial: Returns the price per \$100 face value of a security that pays interest at maturity

262 PROB function Statistical: Returns the probability that values in a range are between two limits

263 PRODUCT function Math and trigonometry: Multiplies its arguments

264 PROPER function Text: Capitalizes the first letter in each word of a text value

265 PV function Financial: Returns the present value of an investment

266 QUARTILE function Statistical: Returns the quartile of a data set

267 QUOTIENT function Math and trigonometry: Returns the integer portion of a division

269 RAND function Math and trigonometry: Returns a random number between 0 and 1

270 RANDBETWEEN function Math and trigonometry: Returns a random number between the numbers you specify

271 RANK function Statistical: Returns the rank of a number in a list of numbers

272 RATE function Financial: Returns the interest rate per period of an annuity

273 RECEIVED function Financial: Returns the amount received at maturity for a fully invested security

274 REGISTER.ID function Add-in and Automation: Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered

275 REPLACE, REPLACEB
276 functions

277 Text: Replaces characters within text

278 REPT function Text: Repeats text a given number of times

279 RIGHT, RIGHTB functions Text: Returns the rightmost characters from a text value

280 ROMAN function Math and trigonometry: Converts an arabic numeral to roman, as text

281 ROUND function Math and trigonometry: Rounds a number to a specified number of digits

282 ROUNDDOWN function Math and trigonometry: Rounds a number down, toward zero

283 ROUNDUP function Math and trigonometry: Rounds a number up, away from zero

284 ROW function Lookup and reference: Returns the row number of a reference

285 ROWS function Lookup and reference: Returns the number of rows in a reference

286 RSQ function Statistical: Returns the square of the Pearson product moment correlation coefficient

287 RTD function Lookup and reference: Retrieves real-time data from a program that supports COM automation

288 SEARCH, SEARCHB
289 functions

290 Text: Finds one text value within another (not case-sensitive)

291 SECOND function Date and time: Converts a serial number to a second

292 SERIESSUM function Math and trigonometry: Returns the sum of a power series based on the formula

293 SIGN function Math and trigonometry: Returns the sign of a number

294 SIN function Math and trigonometry: Returns the sine of the given angle

295 SINH function Math and trigonometry: Returns the hyperbolic sine of a number

296 SKEW function Statistical: Returns the skewness of a distribution

297 SLN function Financial: Returns the straight-line depreciation of an asset for one period

298 SLOPE function Statistical: Returns the slope of the linear regression line

299 SMALL function Statistical: Returns the k-th smallest value in a data set

300 SQL.REQUEST function Add-in and Automation: Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming

302 SQRT function Math and trigonometry: Returns a positive square root

303 SQRTPI function Math and trigonometry: Returns the square root of (number * pi)

304 STANDARDIZE function Statistical: Returns a normalized value

305 STDEV function Statistical: Estimates standard deviation based on a sample

306 STDEVA function Statistical: Estimates standard deviation based on a sample, including numbers, text, and logical values

307 STDEVP function Statistical: Calculates standard deviation based on the entire population

308 STDEVPA function Statistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values

309 STEYX function Statistical: Returns the standard error of the predicted y-value for each x in the regression

310 SUBSTITUTE function Text: Substitutes new text for old text in a text string

311 SUBTOTAL function Math and trigonometry: Returns a subtotal in a list or database

312 SUM function Math and trigonometry: Adds its arguments

313 SUMIF function Math and trigonometry: Adds the cells specified by a given criteria

314 SUMIFS function Math and trigonometry: Adds the cells in a range that meet multiple criteria

315 SUMPRODUCT function Math and trigonometry: Returns the sum of the products of corresponding array components

316 SUMSQ function Math and trigonometry: Returns the sum of the squares of the arguments

317 SUMX2MY2 function Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays

318 SUMX2PY2 function Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays

319 SUMXMY2 function Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays

320 SYD function Financial: Returns the sum-of-years’ digits depreciation of an asset for a specified period

321 T function Text: Converts its arguments to text

322 TAN function Math and trigonometry: Returns the tangent of a number

323 TANH function Math and trigonometry: Returns the hyperbolic tangent of a number

324 TBILLEQ function Financial: Returns the bond-equivalent yield for a Treasury bill

325 TBILLPRICE function Financial: Returns the price per \$100 face value for a Treasury bill

326 TBILLYIELD function Financial: Returns the yield for a Treasury bill

327 TDIST function Statistical: Returns the Student’s t-distribution

328 TEXT function Text: Formats a number and converts it to text

329 TIME function Date and time: Returns the serial number of a particular time

330 TIMEVALUE function Date and time: Converts a time in the form of text to a serial number

331 TINV function Statistical: Returns the inverse of the Student’s t-distribution

332 TODAY function Date and time: Returns the serial number of today’s date

333 TRANSPOSE function Lookup and reference: Returns the transpose of an array

334 TREND function Statistical: Returns values along a linear trend

335 TRIM function Text: Removes spaces from text

336 TRIMMEAN function Statistical: Returns the mean of the interior of a data set

337 TRUE function Logical: Returns the logical value TRUE

338 TRUNC function Math and trigonometry: Truncates a number to an integer

339 TTEST function Statistical: Returns the probability associated with a Student’s t-test

340 TYPE function Information: Returns a number indicating the data type of a value

341 UPPER function Text: Converts text to uppercase

342 VALUE function Text: Converts a text argument to a number

343 VAR function Statistical: Estimates variance based on a sample

344 VARA function Statistical: Estimates variance based on a sample, including numbers, text, and logical values

345 VARP function Statistical: Calculates variance based on the entire population

346 VARPA function Statistical: Calculates variance based on the entire population, including numbers, text, and logical values

347 VDB function Financial: Returns the depreciation of an asset for a specified or partial period by using a declining balance method

348 VLOOKUP function Lookup and reference: Looks in the first column of an array and moves across the row to return the value of a cell

349 WEEKDAY function Date and time: Converts a serial number to a day of the week

350 WEEKNUM function Date and time: Converts a serial number to a number representing where the week falls numerically with a year

351 WEIBULL function Statistical: Calculates variance based on the entire population, including numbers, text, and logical values

352 WORKDAY function Date and time: Returns the serial number of the date before or after a specified number of workdays

353 XIRR function Financial: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic

354 XNPV function Financial: Returns the net present value for a schedule of cash flows that is not necessarily periodic

355 YEAR function Date and time: Converts a serial number to a year

356 YEARFRAC function Date and time: Returns the year fraction representing the number of whole days between start_date and end_date

357 YIELD function Financial: Returns the yield on a security that pays periodic interest

358 YIELDDISC function Financial: Returns the annual yield for a discounted security; for example, a Treasury bill

359 YIELDMAT function Financial: Returns the annual yield of a security that pays interest at maturity

360 ZTEST function Statistical: Returns the one-tailed probability-value of a z-test

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on
www.Myelesson.org

# Our Other Services

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788

### Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!