Excel Functions

Category Logical Statistical Statistical Statistical Math & Trig Cube Cube Cube Cube Cube Cube Cube Database Database Database Database Database Database Database Database Database Database Database Database Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Date & Time Engineering Engineering

Function IFERROR AVERAGEIF AVERAGEIFS COUNTIFS SUMIFS CUBEMEMBER CUBEVALUE CUBESET CUBERANKEDMEMBER CUBEKPIMEMBER CUBEMEMBERPROPERTY CUBESETCOUNT DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP DATE DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY YEAR YEARFRAC BESSELI BESSELJ

Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial

BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC GESTEP HEX2BIN HEX2DEC HEX2OCT IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD

Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Financial Information Statistical Information Information Information Information Information Information

CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FVSCHEDULE INTRATE IPMT IRR ISPMT MDURATION MIRR NOMINAL NPER ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PRICE PRICEDISC PRICEMAT PV RATE RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT CELL COUNTBLANK ERROR.TYPE INFO ISEVEN ISODD N NA

Information Logical Logical Logical Logical Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig

TYPE FALSE NOT OR TRUE ADDRESS AREAS COLUMN COLUMNS HLOOKUP HYPERLINK INDIRECT MATCH OFFSET ROWS RTD ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR GCD INT LCM LN LOG LOG10 MDETERM MOD MROUND MULTINOMIAL ODD PI POWER

Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Math & Trig Lookup & Reference Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical

PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIN SQRT SQRTPI SUBTOTAL SUM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC GETPIVOTDATA AVEDEV AVERAGE AVERAGEA BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE CORREL COUNT COUNTA COVAR CRITBINOM DEVSQ EXPONDIST FDIST FINV FISHER FISHERINV

Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical

FORECAST FREQUENCY FTEST GAMMADIST GAMMAINV GAMMALN GEOMEAN GROWTH HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMDIST NORMINV NORMSDIST NORMSINV PEARSON PERCENTILE PERCENTRANK PERMUT POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TREND

Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Financial Financial Financial Financial Information Information Information Information Information Information Information Information Information Logical Logical Lookup & Reference

TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST BAHTTEXT CHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIXED LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SEARCH SUBSTITUTE T TEXT TRIM UPPER VALUE FV NPV PMT PPMT ISBLANK ISERR ISERROR ISLOGICAL ISNA ISNONTEXT ISNUMBER ISREF ISTEXT AND IF CHOOSE

Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Lookup & Reference Text Statistical Statistical Statistical Math & Trig Math & Trig Math & Trig

INDEX LOOKUP ROW TRANSPOSE VLOOKUP FIND LINEST LOGEST COUNTIF MINVERSE MMULT SINH

Description New? TRUE Returns a different result if the first argument evaluates to an error TRUE Returns the average for the cells specified by a given criterion TRUE Returns the average for the cells specified by multiple criteria TRUE Counts the number of cells that meet multiple criteria TRUE Adds the cells specified by a multiple criteria TRUE Returns a member or tuple in a cube hierarchy TRUE Returns an aggregated value from a cube TRUE Defines a calculated set of members or tuples by sending a set expression to the cube on the server TRUE Returns the nth, or ranked, member in a set Returns a key performance indicator name, property, and measure, and TRUE displays the name and prope TRUE Returns the value of a member property in the cube TRUE Returns the number of items in a set FALSE Averages the values in a column of a list or database that match conditions you specify FALSE Counts the cells that contain numbers in a column of a list or database that match conditions you spe FALSE Counts the nonblank cells in a column of a list or database that match conditions you specify Extracts a single value from a column of a list or database that matchesFALSE conditions you specify FALSE Returns the largest number in a column of a list or database that matches conditions you specify FALSE Returns the smallest number in a column of a list or database that matches conditions you specify FALSE Multiplies the values in a column of a list or database that match conditions you specify Estimates the standard deviation of a population based on a sample by FALSE using the numbers in a colum FALSE Calculates the standard deviation of a population based on the entire population, using the numbers i FALSE Adds the numbers in a column of a list or database that match conditions you specify Estimates the variance of a population based on a sample by using the FALSE numbers in a column of a list o FALSE Calculates the variance of a population based on the entire population by using the numbers in a colu FALSE Returns the serial number of a particular date FALSE Converts a date in the form of text to a serial number FALSE Converts a serial number to a day of the month Calculates the number of days between two dates, based on a 360-day FALSE year FALSE before or after the start Returns the serial number of the date that is the indicated number of months Returns the serial number of the last day of the month before or after aFALSE specified number of months FALSE Converts a serial number to an hour FALSE Converts a serial number to a minute FALSE Converts a serial number to a month FALSE Returns the number of whole workdays between two dates FALSE Returns the serial number of the current date and time FALSE Converts a serial number to a second FALSE Returns the serial number of a particular time FALSE Converts a time in the form of text to a serial number FALSE Returns the serial number of today’s date FALSE Converts a serial number to a day of the week FALSE Returns the week number in the year FALSE Returns the serial number of the date before or after a specified number of workdays FALSE Converts a serial number to a year FALSE Returns the year fraction representing the number of whole days between FALSE Returns the modified Bessel function In(x) FALSE Returns the Bessel function Jn(x)

FALSE Returns the modified Bessel function Kn(x) FALSE Returns the Bessel function Yn(x) FALSE Converts a binary number to decimal FALSE Converts a binary number to hexadecimal FALSE Converts a binary number to octal FALSE Converts real and imaginary coefficients into a complex number FALSE Converts a number from one measurement system to another FALSE Converts a decimal number to binary FALSE Converts a decimal number to hexadecimal FALSE Converts a decimal number to octal FALSE Tests whether two values are equal FALSE Returns the error function FALSE Returns the complementary error function FALSE Tests whether a number is greater than a threshold value FALSE Converts a hexadecimal number to binary FALSE Converts a hexadecimal number to decimal FALSE Converts a hexadecimal number to octal FALSE Returns the absolute value (modulus) of a complex number FALSE Returns the imaginary coefficient of a complex number FALSE Returns the argument theta, an angle expressed in radians FALSE Returns the complex conjugate of a complex number FALSE Returns the cosine of a complex number FALSE Returns the quotient of two complex numbers FALSE Returns the exponential of a complex number FALSE Returns the natural logarithm of a complex number FALSE Returns the base-10 logarithm of a complex number FALSE Returns the base-2 logarithm of a complex number FALSE Returns a complex number raised to an integer power FALSE Returns the product of complex numbers FALSE Returns the real coefficient of a complex number FALSE Returns the sine of a complex number FALSE Returns the square root of a complex number FALSE Returns the difference of two complex numbers FALSE Returns the sum of complex numbers FALSE Converts an octal number to binary FALSE Converts an octal number to decimal FALSE Converts an octal number to hexadecimal Returns the accrued interest for a security that pays periodic interest FALSE FALSE Returns the accrued interest for a security that pays interest at maturity FALSE Returns the depreciation for each accounting period FALSE Returns the depreciation for each accounting period (the depreciation coefficient depends on the life o Returns the number of days from the beginning of the coupon period toFALSE the settlement date FALSE date Returns the number of days in the coupon period that contains the settlement FALSE Returns the number of days from the settlement date to the next coupon date FALSE Returns the next coupon date after the settlement date FALSE Returns the number of coupons payable between the settlement date and maturity date FALSE Returns the previous coupon date before the settlement date

FALSE Returns the cumulative interest paid between two periods Returns the cumulative principal paid on a loan between two periods FALSE FALSE Returns the depreciation of an asset for a specified period, using the fixed-declining-balance method FALSE Returns the depreciation of an asset for a specified period, using the double-declining-balance method FALSE Returns the discount rate for a security FALSE as a decimal number Converts a dollar price, expressed as a fraction, into a dollar price, expressed FALSE Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction FALSE Returns the annual duration of a security with periodic interest payments FALSE Returns the effective annual interest rate Returns the future value of an initial principal after applying a series of FALSE compound interest rates FALSE Returns the interest rate for a fully invested security FALSE Returns the interest payment for an investment for a given period FALSE Returns the internal rate of return for a series of cash flows FALSE Returns the interest associated with a specific loan payment Returns the Macauley modified duration for a security with an assumedFALSE par value of $100 FALSE Returns the internal rate of return where positive and negative cash flows are financed at different rat FALSE Returns the annual nominal interest rate FALSE Returns the number of periods for an investment FALSE Returns the price per $100 face value of a security with an odd first period FALSE Returns the yield of a security with an odd first period FALSE Returns the price per $100 face value of a security with an odd last period FALSE Returns the yield of a security with an odd last period FALSE Returns the price per $100 face value of a security that pays periodic interest FALSE Returns the price per $100 face value of a discounted security Returns the price per $100 face value of a security that pays interest atFALSE maturity FALSE Returns the present value of an investment FALSE Returns the interest rate per period of an annuity Returns the amount received at maturity for a fully invested security FALSE FALSE Returns the straight-line depreciation of an asset for one period Returns the sum-of-years’ digits depreciation of an asset for a specifiedFALSE period FALSE Returns the bond-equivalent yield for a Treasury bill FALSE Returns the price per $100 face value for a Treasury bill FALSE Returns the yield for a Treasury bill FALSE Returns the depreciation of an asset for a specified or partial period using a declining-balance method FALSE Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic FALSE Returns the net present value for a schedule of cash flows that is not necessarily periodic FALSE Returns the yield on a security that pays periodic interest FALSE Returns the annual yield for a discounted security, for example, a Treasury bill FALSE Returns the annual yield of a security that pays interest at maturity Returns information about the formatting, location, or contents of a cellFALSE FALSE Counts the number of blank cells in the argument range FALSE Returns a number corresponding to an error type FALSE Returns information about the current operating environment FALSE Returns TRUE if the number is even FALSE Returns TRUE if the number is odd FALSE Returns a value converted to a number FALSE Returns the error value #N/A

FALSE Returns a number indicating the data type of a value FALSE Returns the logical value FALSE FALSE Reverses the logic of its argument FALSE Returns TRUE if any argument is TRUE FALSE Returns the logical value TRUE FALSE Returns a reference as text to a single cell in a worksheet FALSE Returns the number of areas in a reference FALSE Returns the column number of a reference FALSE Returns the number of columns in a reference FALSE Searches for a value in the top column of a table and then returns a value in the same column from a Creates a shortcut that opens a document on your hard drive, a server,FALSE or the Internet FALSE Returns a reference indicated by a text value FALSE Returns the relative position of an item in an array FALSE Returns a reference offset from a given reference FALSE Returns the number of rows in a reference Returns real-time data from a program that supports COM automation FALSE FALSE Returns the absolute value of a number FALSE Returns the arccosine of a number FALSE Returns the inverse hyperbolic cosine of a number FALSE Returns the arcsine of a number FALSE Returns the inverse hyperbolic sine of a number FALSE Returns the arctangent of a number FALSE Returns the arctangent from x and y coordinates FALSE Returns the inverse hyperbolic tangent of a number FALSE Rounds a number to the nearest integer or to the nearest multiple of significance FALSE Returns the number of combinations for a given number of objects FALSE Returns the cosine of a number FALSE Returns the hyperbolic cosine of a number FALSE Converts radians to degrees FALSE Rounds a number up to the nearest even integer FALSE Returns e raised to the power of a given number FALSE Returns the factorial of a number FALSE Returns the double factorial of a number FALSE Rounds a number down, toward 0 FALSE Returns the greatest common divisor FALSE Rounds a number down to the nearest integer FALSE Returns the least common multiple FALSE Returns the natural logarithm of a number FALSE Returns the logarithm of a number to a specified base FALSE Returns the base-10 logarithm of a number FALSE Returns the matrix determinant of an array FALSE Returns the remainder from division FALSE Returns a number rounded to the desired multiple FALSE Returns the multinomial of a set of numbers FALSE Rounds a number up to the nearest odd integer FALSE Returns the value of pi FALSE Returns the result of a number raised to a power

FALSE Multiplies its arguments FALSE Returns the integer portion of a division FALSE Converts degrees to radians FALSE Returns a random number between 0 and 1 FALSE Returns a random number between the numbers that you specify FALSE Converts an Arabic numeral to Roman, as text FALSE Rounds a number to a specified number of digits FALSE Rounds a number down, toward 0 FALSE Rounds a number up, away from 0 FALSE Returns the sum of a power series based on the formula FALSE Returns the sign of a number FALSE Returns the sine of the given angle FALSE Returns a positive square root FALSE Returns the square root of pi FALSE Returns a subtotal in a list or database FALSE Adds its arguments FALSE Adds the cells specified by a given criteria Returns the sum of the products of corresponding array components FALSE FALSE Returns the sum of the squares of the arguments Returns the sum of the difference of squares of corresponding values inFALSE two arrays FALSE Returns the sum of the sum of squares of corresponding values in two arrays FALSE Returns the sum of squares of differences of corresponding values in two arrays FALSE Returns the tangent of a number FALSE Returns the hyperbolic tangent of a number FALSE Truncates a number (you specify the precision of the truncation) FALSE Returns data stored in a PivotTable Returns the average of the absolute deviations of data points from theirFALSE mean FALSE Returns the average of its arguments FALSE Returns the average of its arguments and includes evaluation of text and logical values FALSE Returns the cumulative beta probability density function Returns the inverse of the cumulative beta probability density function FALSE FALSE Returns the individual term binomial distribution probability FALSE Returns the one-tailed probability of the chi-squared distribution FALSE Returns the inverse of the one-tailed probability of the chi-squared distribution FALSE Returns the test for independence FALSE Returns the confidence interval for a population mean FALSE Returns the correlation coefficient between two data sets FALSE Counts how many numbers are in the list of arguments FALSE Counts how many values are in the list of arguments Returns covariance, the average of the products of paired deviations FALSE FALSE Returns the smallest value for which the cumulative binomial distribution is less than or equal to a crit FALSE Returns the sum of squares of deviations FALSE Returns the exponential distribution FALSE Returns the F probability distribution FALSE Returns the inverse of the F probability distribution FALSE Returns the Fisher transformation FALSE Returns the inverse of the Fisher transformation

FALSE Returns a value along a linear trend FALSE Returns a frequency distribution as a vertical array FALSE Returns the result of an F-Test FALSE Returns the gamma distribution FALSE Returns the inverse of the gamma cumulative distribution FALSE Returns the natural logarithm of the gamma function, G(x) FALSE Returns the geometric mean FALSE Returns values along an exponential trend FALSE Returns the harmonic mean FALSE Returns the hypergeometric distribution FALSE Returns the intercept of the linear regression line FALSE Returns the kurtosis of a data set FALSE Returns the kth largest value in a data set FALSE Returns the inverse of the lognormal distribution FALSE Returns the cumulative lognormal distribution FALSE Returns the maximum value in a list of arguments, ignoring logical values and text FALSE Returns the maximum value in a list of arguments, including logical values and text FALSE Returns the median of the given numbers FALSE Returns the minimum value in a list of arguments, ignoring logical values and text FALSE Returns the minimum value in a list of arguments, including logical values and text FALSE Returns the most common value in a data set FALSE Returns the negative binomial distribution FALSE Returns the normal cumulative distribution FALSE Returns the inverse of the normal cumulative distribution FALSE Returns the standard normal cumulative distribution FALSE Returns the inverse of the standard normal cumulative distribution FALSE Returns the Pearson product moment correlation coefficient FALSE Returns the kth percentile of values in a range FALSE Returns the percentage rank of a value in a data set FALSE Returns the number of permutations for a given number of objects FALSE Returns the Poisson distribution Returns the probability that values in a range are between two limits FALSE FALSE Returns the quartile of a data set FALSE Returns the rank of a number in a list of numbers FALSE Returns the square of the Pearson product moment correlation coefficient FALSE Returns the skewness of a distribution FALSE Returns the slope of the linear regression line FALSE Returns the kth smallest value in a data set FALSE Returns a normalized value FALSE Estimates standard deviation based on a sample, ignoring text and logical values FALSE Estimates standard deviation based on a sample, including text and logical values FALSE Calculates standard deviation based on the entire population, ignoring text and logical values Calculates standard deviation based on the entire population, includingFALSE text and logical values FALSE Returns the standard error of the predicted y-value for each x in the regression FALSE Returns the student’s t-distribution FALSE Returns the inverse of the student’s t-distribution FALSE Returns values along a linear trend

FALSE Returns the mean of the interior of a data set FALSE Returns the probability associated with a student’s t-Test Estimates variance based on a sample, ignoring logical values and text FALSE Estimates variance based on a sample, including logical values and textFALSE FALSE Calculates variance based on the entire population, ignoring logical values and text FALSE Calculates variance based on the entire population, including logical values and text FALSE Returns the Weibull distribution FALSE Returns the two-tailed P-value of a z-test FALSE Converts a number to Baht text FALSE Returns the character specified by the code number FALSE Removes all nonprintable characters from text FALSE Returns a numeric code for the first character in a text string FALSE Joins several text items into one text item FALSE Converts a number to text, using currency format FALSE Checks to see whether two text values are identical FALSE Formats a number as text with a fixed number of decimals FALSE Returns the leftmost characters from a text value FALSE Returns the number of characters in a text string FALSE Converts text to lowercase FALSE Returns a specific number of characters from a text string, starting at the position you specify FALSE Capitalizes the first letter in each word of a text value FALSE Replaces characters within text FALSE Repeats text a given number of times FALSE Returns the rightmost characters from a text value FALSE Finds one text value within another (not case sensitive) FALSE Substitutes new text for old text in a text string FALSE Returns the text referred to by value FALSE Formats a number and converts it to text FALSE Removes excess spaces from text FALSE Converts text to uppercase FALSE Converts a text argument to a number FALSE Returns the future value of an investment FALSEcash flows and a discoun Returns the net present value of an investment based on a series of periodic FALSE Returns the periodic payment for an annuity FALSE Returns the payment on the principal for an investment for a given period FALSE Returns TRUE if the value is blank FALSE Returns TRUE if the value is any error value except #N/A FALSE Returns TRUE if the value is any error value FALSE Returns TRUE if the value is a logical value FALSE Returns TRUE if the value is the #N/A error value FALSE Returns TRUE if the value is not text FALSE Returns TRUE if the value is a number FALSE Returns TRUE if the value is a reference FALSE Returns TRUE if the value is text FALSE Returns TRUE if all its arguments are TRUE FALSE Specifies a logical test to perform FALSE Chooses a value from a list of values

FALSE Uses an index to choose a value from a reference or array FALSE Returns a value either from a one-row or one-column range or from an array FALSE Returns the row number of a reference FALSE Returns the transpose of an array Searches for a value in the leftmost column of a table and then returns FALSE a value in the same row from FALSE Finds one text value within another (case sensitive) FALSE Returns the parameters of a linear trend FALSE Returns the parameters of an exponential trend FALSE Counts the number of cells that meet the criteria you specify in the argument FALSE Returns the matrix inverse of an array FALSE Returns the matrix product of two arrays FALSE Returns the hyperbolic sine of a number

Help Topic HA01231765 HA10047433 HA10047493 HA10047494 HA10047504 HA10083017 HA10083018 HA10083019 HA10083020 HA10083021 HA10083023 HA10083024 HP10062266 HP10062267 HP10062268 HP10062269 HP10062270 HP10062271 HP10062272 HP10062273 HP10062274 HP10062275 HP10062276 HP10062277 HP10062283 HP10062284 HP10062285 HP10062286 HP10062287 HP10062288 HP10062289 HP10062290 HP10062291 HP10062292 HP10062293 HP10062294 HP10062295 HP10062296 HP10062297 HP10062298 HP10062299 HP10062300 HP10062301 HP10062302 HP10062303 HP10062304

Help <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

Clicking a link in this column takes you to the Help topic at Microsoft's Office site.

HP10062305 HP10062306 HP10062307 HP10062308 HP10062309 HP10062310 HP10062311 HP10062312 HP10062313 HP10062314 HP10062315 HP10062316 HP10062317 HP10062318 HP10062319 HP10062321 HP10062322 HP10062323 HP10062324 HP10062325 HP10062326 HP10062327 HP10062328 HP10062329 HP10062330 HP10062331 HP10062332 HP10062333 HP10062334 HP10062335 HP10062336 HP10062337 HP10062338 HP10062339 HP10062340 HP10062341 HP10062342 HP10062343 HP10062344 HP10062345 HP10062346 HP10062347 HP10062348 HP10062349 HP10062350 HP10062351 HP10062352

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10062353 HP10062354 HP10062355 HP10062356 HP10062357 HP10062358 HP10062359 HP10062360 HP10062361 HP10062362 HP10062363 HP10062364 HP10062365 HP10062366 HP10062367 HP10062368 HP10062369 HP10062370 HP10062371 HP10062372 HP10062373 HP10062374 HP10062375 HP10062376 HP10062377 HP10062378 HP10062379 HP10062380 HP10062381 HP10062382 HP10062383 HP10062384 HP10062385 HP10062386 HP10062387 HP10062388 HP10062389 HP10062390 HP10062391 HP10062392 HP10062393 HP10062394 HP10062395 HP10062396 HP10062397 HP10062398 HP10062399

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10062400 HP10062401 HP10062402 HP10062403 HP10062404 HP10062407 HP10062408 HP10062409 HP10062410 HP10062411 HP10062412 HP10062413 HP10062414 HP10062415 HP10062416 HP10062417 HP10062418 HP10062419 HP10062420 HP10062421 HP10062422 HP10062423 HP10062424 HP10062425 HP10062426 HP10062427 HP10062428 HP10062429 HP10062430 HP10062431 HP10062432 HP10062433 HP10062434 HP10062435 HP10062436 HP10062437 HP10062438 HP10062439 HP10062440 HP10062441 HP10062442 HP10062443 HP10062444 HP10062445 HP10062446 HP10062447 HP10062448

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10062449 HP10062450 HP10062451 HP10062452 HP10062453 HP10062454 HP10062455 HP10062456 HP10062457 HP10062458 HP10062459 HP10062460 HP10062461 HP10062462 HP10062463 HP10062464 HP10062465 HP10062466 HP10062467 HP10062468 HP10062469 HP10062470 HP10062471 HP10062472 HP10062473 HP10062477 HP10062481 HP10062482 HP10062483 HP10062484 HP10062485 HP10062486 HP10062487 HP10062488 HP10062489 HP10062490 HP10062491 HP10062492 HP10062493 HP10062494 HP10062495 HP10062496 HP10062497 HP10062498 HP10062499 HP10062500 HP10062501

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10062502 HP10062503 HP10062504 HP10062505 HP10062506 HP10062507 HP10062508 HP10062509 HP10062510 HP10062511 HP10062512 HP10062513 HP10062514 HP10062515 HP10062516 HP10062517 HP10062518 HP10062519 HP10062520 HP10062521 HP10062522 HP10062523 HP10062524 HP10062525 HP10062526 HP10062527 HP10062528 HP10062529 HP10062530 HP10062531 HP10062532 HP10062533 HP10062534 HP10062535 HP10062536 HP10062537 HP10062538 HP10062539 HP10062540 HP10062541 HP10062542 HP10062543 HP10062544 HP10062545 HP10062546 HP10062547 HP10062548

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10062549 HP10062550 HP10062551 HP10062552 HP10062553 HP10062554 HP10062555 HP10062556 HP10062558 HP10062559 HP10062560 HP10062561 HP10062562 HP10062563 HP10062564 HP10062565 HP10062568 HP10062569 HP10062570 HP10062571 HP10062573 HP10062574 HP10062575 HP10062576 HP10062577 HP10062578 HP10062579 HP10062580 HP10062581 HP10062582 HP10062583 HP10069823 HP10069824 HP10069825 HP10069826 HP10069827 HP10069827 HP10069827 HP10069827 HP10069827 HP10069827 HP10069827 HP10069827 HP10069827 HP10069828 HP10069829 HP10069830

<More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

HP10069831 HP10069832 HP10069833 HP10069834 HP10069835 HP10069836 HP10069838 HP10069839 HP10069840 HP10069841 HP10069842 HP10069843

<More <More <More <More <More <More <More <More <More <More <More <More

Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info> Info>

New Count - Function Category Statistical Math & Trig Financial Engineering Text Date & Time Lookup & Reference Information Database Cube Logical Total Result

- all -

83 60 53 39 24 20 18 17 12 7 7 340

DPCache

Category Function Description New Cube CUBEKPIMEMBER* Returns a key performance TRUE indicator name, property, and measure, and displ Cube CUBEMEMBER* Returns a member TRUE or tuple in a cube hierarchy Cube CUBEMEMBERPROPERTY* Returns the valueTRUE of a member property in the cube Cube CUBERANKEDMEMBER* Returns the nth, or TRUE ranked, member in a set Cube CUBESET* Defines a calculated TRUE set of members or tuples by sending a set expression to Cube CUBESETCOUNT* Returns the number TRUE of items in a set Cube CUBEVALUE* Returns an aggregated TRUE value from a cube Database DAVERAGE Averages the values FALSE in a column of a list or database that match conditions y Database DCOUNT Counts the cells that FALSE contain numbers in a column of a list or database that m Database DCOUNTA Counts the nonblank FALSE cells in a column of a list or database that match conditi Database DGET Extracts a single FALSE value from a column of a list or database that matches cond Database DMAX Returns the largest FALSE number in a column of a list or database that matches con Database DMIN Returns the smallest FALSE number in a column of a list or database that matches c Database DPRODUCT Multiplies the values FALSE in a column of a list or database that match conditions y Database DSTDEV Estimates the standard FALSE deviation of a population based on a sample by using Database DSTDEVP Calculates the standard FALSE deviation of a population based on the entire populat Database DSUM Adds the numbers FALSE in a column of a list or database that match conditions you Database DVAR Estimates the variance FALSE of a population based on a sample by using the numb Database DVARP Calculates the variance FALSE of a population based on the entire population by usin Date & TimeDATE Returns the serial FALSE number of a particular date Date & TimeDATEVALUEConverts a date in FALSE the form of text to a serial number Date & TimeDAY Converts a serialFALSE number to a day of the month Date & TimeDAYS360 Calculates the number FALSE of days between two dates, based on a 360-day year Date & TimeEDATE Returns the serial FALSE number of the date that is the indicated number of months Date & TimeEOMONTH Returns the serial FALSE number of the last day of the month before or after a speci Date & TimeHOUR Converts a serialFALSE number to an hour Date & TimeMINUTE Converts a serialFALSE number to a minute Date & TimeMONTH Converts a serialFALSE number to a month Date & TimeNETWORKDAYS Returns the number FALSE of whole workdays between two dates Date & TimeNOW Returns the serial FALSE number of the current date and time Date & TimeSECOND Converts a serialFALSE number to a second Date & TimeTIME Returns the serial FALSE number of a particular time Date & TimeTIMEVALUE Converts a time in FALSE the form of text to a serial number Date & TimeTODAY Returns the serial FALSE number of today’s date Date & TimeWEEKDAY Converts a serialFALSE number to a day of the week Date & TimeWEEKNUM Returns the weekFALSE number in the year Date & TimeWORKDAY Returns the serial FALSE number of the date before or after a specified number of w Date & TimeYEAR Converts a serialFALSE number to a year Date & TimeYEARFRAC Returns the yearFALSE fraction representing the number of whole days between sta EngineeringBESSELI Returns the modified FALSE Bessel function In(x) EngineeringBESSELJ Returns the Bessel FALSE function Jn(x) EngineeringBESSELK Returns the modified FALSE Bessel function Kn(x) EngineeringBESSELY Returns the Bessel FALSE function Yn(x) EngineeringBIN2DEC Converts a binary FALSE number to decimal EngineeringBIN2HEX Converts a binary FALSE number to hexadecimal Page 26

DPCache

EngineeringBIN2OCT Converts a binary FALSE number to octal EngineeringCOMPLEX Converts real and FALSE imaginary coefficients into a complex number EngineeringCONVERT Converts a number FALSE from one measurement system to another EngineeringDEC2BIN Converts a decimal FALSE number to binary EngineeringDEC2HEX Converts a decimal FALSE number to hexadecimal EngineeringDEC2OCT Converts a decimal FALSE number to octal EngineeringDELTA Tests whether two FALSE values are equal EngineeringERF Returns the errorFALSE function EngineeringERFC Returns the complementary FALSE error function EngineeringGESTEP Tests whether a number FALSE is greater than a threshold value EngineeringHEX2BIN Converts a hexadecimal FALSE number to binary EngineeringHEX2DEC Converts a hexadecimal FALSE number to decimal EngineeringHEX2OCT Converts a hexadecimal FALSE number to octal EngineeringIMABS Returns the absolute FALSE value (modulus) of a complex number EngineeringIMAGINARY Returns the imaginary FALSE coefficient of a complex number EngineeringIMARGUMENT Returns the argument FALSEtheta, an angle expressed in radians EngineeringIMCONJUGATE Returns the complex FALSE conjugate of a complex number EngineeringIMCOS Returns the cosine FALSE of a complex number EngineeringIMDIV Returns the quotient FALSE of two complex numbers EngineeringIMEXP Returns the exponential FALSE of a complex number EngineeringIMLN Returns the natural FALSE logarithm of a complex number EngineeringIMLOG10 Returns the base-10 FALSE logarithm of a complex number EngineeringIMLOG2 Returns the base-2 FALSE logarithm of a complex number EngineeringIMPOWER Returns a complex FALSE number raised to an integer power EngineeringIMPRODUCTReturns the product FALSE of complex numbers EngineeringIMREAL Returns the real FALSE coefficient of a complex number EngineeringIMSIN Returns the sine FALSE of a complex number EngineeringIMSQRT Returns the square FALSE root of a complex number EngineeringIMSUB Returns the difference FALSE of two complex numbers EngineeringIMSUM Returns the sum FALSE of complex numbers EngineeringOCT2BIN Converts an octalFALSE number to binary EngineeringOCT2DEC Converts an octalFALSE number to decimal EngineeringOCT2HEX Converts an octalFALSE number to hexadecimal Financial ACCRINT Returns the accrued FALSE interest for a security that pays periodic interest Financial ACCRINTM Returns the accrued FALSE interest for a security that pays interest at maturity Financial AMORDEGRC Returns the depreciation FALSE for each accounting period Financial AMORLINC Returns the depreciation FALSE for each accounting period (the depreciation coeffici Financial COUPDAYBSReturns the number FALSE of days from the beginning of the coupon period to the s Financial COUPDAYS Returns the number FALSE of days in the coupon period that contains the settlemen Financial COUPDAYSNC Returns the number FALSE of days from the settlement date to the next coupon date Financial COUPNCD Returns the nextFALSE coupon date after the settlement date Financial COUPNUM Returns the number FALSE of coupons payable between the settlement date and ma Financial COUPPCD Returns the previous FALSE coupon date before the settlement date Financial CUMIPMT Returns the cumulative FALSE interest paid between two periods Financial CUMPRINC Returns the cumulative FALSE principal paid on a loan between two periods Financial DB Returns the depreciation FALSE of an asset for a specified period, using the fixed-de Page 27

DPCache

Financial DDB Returns the depreciation FALSE of an asset for a specified period, using the double-d Financial DISC Returns the discount FALSE rate for a security Financial DOLLARDE Converts a dollarFALSE price, expressed as a fraction, into a dollar price, expressed Financial DOLLARFR Converts a dollarFALSE price, expressed as a decimal number, into a dollar price, ex Financial DURATION Returns the annual FALSE duration of a security with periodic interest payments Financial EFFECT Returns the effective FALSE annual interest rate Financial FV Returns the future FALSE value of an investment Financial FVSCHEDULE Returns the future FALSE value of an initial principal after applying a series of compo Financial INTRATE Returns the interest FALSE rate for a fully invested security Financial IPMT Returns the interest FALSE payment for an investment for a given period Financial IRR Returns the internal FALSE rate of return for a series of cash flows Financial ISPMT Returns the interest FALSE associated with a specific loan payment Financial MDURATIONReturns the Macauley FALSEmodified duration for a security with an assumed par va Financial MIRR Returns the internal FALSE rate of return where positive and negative cash flows are Financial NOMINAL Returns the annual FALSE nominal interest rate Financial NPER Returns the number FALSE of periods for an investment Financial NPV Returns the net present FALSE value of an investment based on a series of periodic Financial ODDFPRICEReturns the priceFALSE per $100 face value of a security with an odd first period Financial ODDFYIELDReturns the yieldFALSE of a security with an odd first period Financial ODDLPRICEReturns the priceFALSE per $100 face value of a security with an odd last period Financial ODDLYIELDReturns the yieldFALSE of a security with an odd last period Financial PMT Returns the periodic FALSE payment for an annuity Financial PPMT Returns the payment FALSE on the principal for an investment for a given period Financial PRICE Returns the priceFALSE per $100 face value of a security that pays periodic interest Financial PRICEDISC Returns the priceFALSE per $100 face value of a discounted security Financial PRICEMAT Returns the priceFALSE per $100 face value of a security that pays interest at matu Financial PV Returns the present FALSE value of an investment Financial RATE Returns the interest FALSE rate per period of an annuity Financial RECEIVED Returns the amount FALSE received at maturity for a fully invested security Financial SLN Returns the straight-line FALSE depreciation of an asset for one period Financial SYD Returns the sum-of-years’ FALSE digits depreciation of an asset for a specified period Financial TBILLEQ Returns the bond-equivalent FALSE yield for a Treasury bill Financial TBILLPRICE Returns the priceFALSE per $100 face value for a Treasury bill Financial TBILLYIELD Returns the yieldFALSE for a Treasury bill Financial VDB Returns the depreciation FALSE of an asset for a specified or partial period using a d Financial XIRR Returns the internal FALSE rate of return for a schedule of cash flows that is not nec Financial XNPV Returns the net present FALSE value for a schedule of cash flows that is not necessa Financial YIELD Returns the yieldFALSE on a security that pays periodic interest Financial YIELDDISC Returns the annual FALSE yield for a discounted security, for example, a Treasury bi Financial YIELDMAT Returns the annual FALSE yield of a security that pays interest at maturity InformationCELL Returns information FALSE about the formatting, location, or contents of a cell InformationERROR.TYPEReturns a number FALSE corresponding to an error type InformationINFO Returns information FALSE about the current operating environment InformationISBLANK Returns TRUE if the FALSE value is blank InformationISERR Returns TRUE if the FALSE value is any error value except #N/A InformationISERROR Returns TRUE if the FALSE value is any error value Page 28

DPCache

InformationISEVEN Returns TRUE if the FALSE number is even InformationISLOGICAL Returns TRUE if the FALSE value is a logical value InformationISNA Returns TRUE if the FALSE value is the #N/A error value InformationISNONTEXTReturns TRUE if the FALSE value is not text InformationISNUMBER Returns TRUE if the FALSE value is a number InformationISODD Returns TRUE if the FALSE number is odd InformationISREF Returns TRUE if the FALSE value is a reference InformationISTEXT Returns TRUE if the FALSE value is text InformationN Returns a value converted FALSE to a number InformationNA Returns the errorFALSE value #N/A InformationTYPE Returns a number FALSE indicating the data type of a value Logical AND Returns TRUE if all FALSE its arguments are TRUE Logical FALSE Returns the logical FALSE value FALSE Logical IF Specifies a logical FALSE test to perform Logical IFERROR* Returns a different TRUE result if the first argument evaluates to an error Logical NOT Reverses the logic FALSE of its argument Logical OR Returns TRUE if any FALSE argument is TRUE Logical TRUE Returns the logical FALSE value TRUE Lookup & Reference ADDRESS Returns a reference FALSE as text to a single cell in a worksheet Lookup & Reference AREAS Returns the number FALSE of areas in a reference Lookup & Reference CHOOSE Chooses a value FALSE from a list of values Lookup & Reference COLUMN Returns the column FALSE number of a reference Lookup & Reference COLUMNS Returns the number FALSE of columns in a reference Lookup & Reference GETPIVOTDATA Returns data stored FALSE in a PivotTable Lookup & Reference HLOOKUP Searches for a value FALSE in the top column of a table and then returns a value in t Lookup & Reference HYPERLINK Creates a shortcut FALSE that opens a document on your hard drive, a server, or the Lookup & Reference INDEX Uses an index to FALSE choose a value from a reference or array Lookup & Reference INDIRECT Returns a reference FALSE indicated by a text value Lookup & Reference LOOKUP Returns a value either FALSEfrom a one-row or one-column range or from an array Lookup & Reference MATCH Returns the relative FALSE position of an item in an array Lookup & Reference OFFSET Returns a reference FALSE offset from a given reference Lookup & Reference ROW Returns the row number FALSE of a reference Lookup & Reference ROWS Returns the number FALSE of rows in a reference Lookup & Reference RTD Returns real-timeFALSE data from a program that supports COM automation Lookup & Reference TRANSPOSEReturns the transpose FALSEof an array Lookup & Reference VLOOKUP Searches for a value FALSE in the leftmost column of a table and then returns a valu Math & TrigABS Returns the absolute FALSE value of a number Math & TrigACOS Returns the arccosine FALSEof a number Math & TrigACOSH Returns the inverse FALSE hyperbolic cosine of a number Math & TrigASIN Returns the arcsine FALSE of a number Math & TrigASINH Returns the inverse FALSE hyperbolic sine of a number Math & TrigATAN Returns the arctangent FALSE of a number Math & TrigATAN2 Returns the arctangent FALSE from x and y coordinates Math & TrigATANH Returns the inverse FALSE hyperbolic tangent of a number Math & TrigCEILING Rounds a numberFALSE to the nearest integer or to the nearest multiple of significa Math & TrigCOMBIN Returns the number FALSE of combinations for a given number of objects Page 29

DPCache Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math Math

& & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &

TrigCOS Returns the cosine FALSE of a number TrigCOSH Returns the hyperbolic FALSE cosine of a number TrigDEGREES Converts radiansFALSE to degrees TrigEVEN Rounds a numberFALSE up to the nearest even integer TrigEXP Returns e raised FALSE to the power of a given number TrigFACT Returns the factorial FALSE of a number TrigFACTDOUBLE Returns the double FALSE factorial of a number TrigFLOOR Rounds a numberFALSE down, toward 0 TrigGCD Returns the greatest FALSE common divisor TrigINT Rounds a numberFALSE down to the nearest integer TrigLCM Returns the leastFALSE common multiple TrigLN Returns the natural FALSE logarithm of a number TrigLOG Returns the logarithm FALSEof a number to a specified base TrigLOG10 Returns the base-10 FALSE logarithm of a number TrigMDETERM Returns the matrix FALSE determinant of an array TrigMINVERSE Returns the matrix FALSE inverse of an array TrigMMULT Returns the matrix FALSE product of two arrays TrigMOD Returns the remainder FALSE from division TrigMROUND Returns a number FALSE rounded to the desired multiple TrigMULTINOMIAL Returns the multinomial FALSE of a set of numbers TrigODD Rounds a numberFALSE up to the nearest odd integer TrigPI Returns the value FALSE of pi TrigPOWER Returns the result FALSE of a number raised to a power TrigPRODUCT Multiplies its arguments FALSE TrigQUOTIENT Returns the integer FALSE portion of a division TrigRADIANS Converts degreesFALSE to radians TrigRAND Returns a random FALSE number between 0 and 1 TrigRANDBETWEEN Returns a random FALSE number between the numbers that you specify TrigROMAN Converts an Arabic FALSE numeral to Roman, as text TrigROUND Rounds a numberFALSE to a specified number of digits TrigROUNDDOWN Rounds a numberFALSE down, toward 0 TrigROUNDUP Rounds a numberFALSE up, away from 0 TrigSERIESSUMReturns the sum FALSE of a power series based on the formula TrigSIGN Returns the sign FALSE of a number TrigSIN Returns the sine FALSE of the given angle TrigSINH Returns the hyperbolic FALSE sine of a number TrigSQRT Returns a positive FALSE square root TrigSQRTPI Returns the square FALSE root of pi TrigSUBTOTAL Returns a subtotal FALSE in a list or database TrigSUM Adds its arguments FALSE TrigSUMIF Adds the cells specified FALSE by a given criteria TrigSUMIFS* Adds the cells specified TRUE by a multiple criteria TrigSUMPRODUCT Returns the sum FALSE of the products of corresponding array components TrigSUMSQ Returns the sum FALSE of the squares of the arguments TrigSUMX2MY2 Returns the sum FALSE of the difference of squares of corresponding values in two a TrigSUMX2PY2 Returns the sum FALSE of the sum of squares of corresponding values in two arrays Page 30

DPCache

Math & TrigSUMXMY2 Returns the sum FALSE of squares of differences of corresponding values in two arra Math & TrigTAN Returns the tangent FALSE of a number Math & TrigTANH Returns the hyperbolic FALSE tangent of a number Math & TrigTRUNC Truncates a number FALSE (you specify the precision of the truncation) Statistical AVEDEV Returns the average FALSE of the absolute deviations of data points from their mean Statistical AVERAGE Returns the average FALSE of its arguments Statistical AVERAGEA Returns the average FALSE of its arguments and includes evaluation of text and logi Statistical AVERAGEIF*Returns the average TRUE for the cells specified by a given criterion Statistical AVERAGEIFS* Returns the average TRUE for the cells specified by multiple criteria Statistical BETADIST Returns the cumulative FALSE beta probability density function Statistical BETAINV Returns the inverse FALSE of the cumulative beta probability density function Statistical BINOMDIST Returns the individual FALSEterm binomial distribution probability Statistical CHIDIST Returns the one-tailed FALSE probability of the chi-squared distribution Statistical CHIINV Returns the inverse FALSE of the one-tailed probability of the chi-squared distributio Statistical CHITEST Returns the test FALSE for independence Statistical CONFIDENCE Returns the confidence FALSE interval for a population mean Statistical CORREL Returns the correlation FALSE coefficient between two data sets Statistical COUNT Counts how many FALSE numbers are in the list of arguments Statistical COUNTA Counts how many FALSE values are in the list of arguments Statistical COUNTBLANK Counts the number FALSE of blank cells in the argument range Statistical COUNTIF Counts the number FALSE of cells that meet the criteria you specify in the argument Statistical COUNTIFS* Counts the number TRUE of cells that meet multiple criteria Statistical COVAR Returns covariance, FALSE the average of the products of paired deviations Statistical CRITBINOM Returns the smallest FALSE value for which the cumulative binomial distribution is le Statistical DEVSQ Returns the sum FALSE of squares of deviations Statistical EXPONDISTReturns the exponential FALSE distribution Statistical FDIST Returns the F probability FALSE distribution Statistical FINV Returns the inverse FALSE of the F probability distribution Statistical FISHER Returns the Fisher FALSE transformation Statistical FISHERINV Returns the inverse FALSE of the Fisher transformation Statistical FORECAST Returns a value along FALSEa linear trend Statistical FREQUENCYReturns a frequency FALSE distribution as a vertical array Statistical FTEST Returns the result FALSE of an F-Test Statistical GAMMADISTReturns the gamma FALSE distribution Statistical GAMMAINV Returns the inverse FALSE of the gamma cumulative distribution Statistical GAMMALN Returns the natural FALSE logarithm of the gamma function, G(x) Statistical GEOMEAN Returns the geometric FALSE mean Statistical GROWTH Returns values along FALSE an exponential trend Statistical HARMEAN Returns the harmonic FALSEmean Statistical HYPGEOMDIST Returns the hypergeometric FALSE distribution Statistical INTERCEPT Returns the intercept FALSEof the linear regression line Statistical KURT Returns the kurtosis FALSE of a data set Statistical LARGE Returns the kth largest FALSE value in a data set Statistical LINEST Returns the parameters FALSE of a linear trend Statistical LOGEST Returns the parameters FALSE of an exponential trend Statistical LOGINV Returns the inverse FALSE of the lognormal distribution Page 31

DPCache Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Statistical Text Text Text Text Text

LOGNORMDIST Returns the cumulative FALSE lognormal distribution MAX Returns the maximum FALSE value in a list of arguments, ignoring logical values and MAXA Returns the maximum FALSE value in a list of arguments, including logical values an MEDIAN Returns the median FALSE of the given numbers MIN Returns the minimum FALSEvalue in a list of arguments, ignoring logical values and MINA Returns the minimum FALSEvalue in a list of arguments, including logical values an MODE Returns the mostFALSE common value in a data set NEGBINOMDIST Returns the negative FALSE binomial distribution NORMDIST Returns the normal FALSE cumulative distribution NORMINV Returns the inverse FALSE of the normal cumulative distribution NORMSDISTReturns the standard FALSE normal cumulative distribution NORMSINV Returns the inverse FALSE of the standard normal cumulative distribution PEARSON Returns the Pearson FALSE product moment correlation coefficient PERCENTILEReturns the kth percentile FALSE of values in a range PERCENTRANK Returns the percentage FALSE rank of a value in a data set PERMUT Returns the number FALSE of permutations for a given number of objects POISSON Returns the Poisson FALSE distribution PROB Returns the probability FALSE that values in a range are between two limits QUARTILE Returns the quartile FALSE of a data set RANK Returns the rankFALSE of a number in a list of numbers RSQ Returns the square FALSE of the Pearson product moment correlation coefficient SKEW Returns the skewness FALSEof a distribution SLOPE Returns the slopeFALSE of the linear regression line SMALL Returns the kth smallest FALSE value in a data set STANDARDIZE Returns a normalized FALSEvalue STDEV Estimates standard FALSE deviation based on a sample, ignoring text and logical val STDEVA Estimates standard FALSE deviation based on a sample, including text and logical va STDEVP Calculates standard FALSE deviation based on the entire population, ignoring text an STDEVPA Calculates standard FALSE deviation based on the entire population, including text a STEYX Returns the standard FALSE error of the predicted y-value for each x in the regressio TDIST Returns the student’s FALSEt-distribution TINV Returns the inverse FALSE of the student’s t-distribution TREND Returns values along FALSE a linear trend TRIMMEAN Returns the mean FALSE of the interior of a data set TTEST Returns the probability FALSE associated with a student’s t-Test VAR Estimates variance FALSE based on a sample, ignoring logical values and text VARA Estimates variance FALSE based on a sample, including logical values and text VARP Calculates variance FALSE based on the entire population, ignoring logical values an VARPA Calculates variance FALSE based on the entire population, including logical values an WEIBULL Returns the Weibull FALSE distribution ZTEST Returns the two-tailed FALSEP-value of a z-test BAHTTEXT Converts a number FALSE to Baht text CHAR Returns the character FALSEspecified by the code number CLEAN Removes all nonprintable FALSE characters from text CODE Returns a numeric FALSE code for the first character in a text string CONCATENATE Joins several textFALSE items into one text item Page 32

DPCache Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text Text

DOLLAR Converts a number FALSE to text, using currency format EXACT Checks to see whether FALSE two text values are identical FIND Finds one text value FALSE within another (case sensitive) FIXED Formats a number FALSE as text with a fixed number of decimals LEFT Returns the leftmost FALSE characters from a text value LEN Returns the number FALSE of characters in a text string LOWER Converts text to FALSE lowercase MID Returns a specific FALSE number of characters from a text string, starting at the pos PROPER Capitalizes the first FALSE letter in each word of a text value REPLACE Replaces characters FALSE within text REPT Repeats text a given FALSE number of times RIGHT Returns the rightmost FALSEcharacters from a text value SEARCH Finds one text value FALSE within another (not case sensitive) SUBSTITUTESubstitutes new text FALSE for old text in a text string T Returns the text FALSE referred to by value TEXT Formats a number FALSE and converts it to text TRIM Removes excessFALSE spaces from text UPPER Converts text to FALSE uppercase VALUE Converts a text argument FALSE to a number

Page 33