Database Function: DAVERAGE [Description: Returns the average of selected database entries]
Database Function: DCOUNT [Description: Counts the cells that contain numbers in a database]
Database Function: DCOUNTA [Description: Counts nonblank cells in a database]
Database Function: DGET [Description: Extracts from a database a single record that matches the specified criteria]
Database Function: DMAX [Description: Returns the maximum value from selected database entries]
Database Function: DMIN [Description: Returns the minimum value from selected database entries]
Database Function: DPRODUCT [Description: Multiplies the values in a particular field of records that match the criteria in a database]
Database Function: DSTDEV [Description: Estimates the standard deviation based on a sample of selected database entries]
Database Function: DSTDEVP [Description: Calculates the standard deviation based on the entire population of selected database entries]
Database Function: DSUM [Description: Adds the numbers in the field column of records in the database that match the criteria]
Database Function: DVAR [Description: Estimates variance based on a sample from selected database entries]
Database Function: DVARP [Description: Calculates variance based on the entire population of selected database entries]
Date & Time Function: DATE [Description: Returns the serial number of a particular date]
Date & Time Function: DATEVALUE [Description: Converts a date in the form of text to a serial number]
Date & Time Function: DAY [Description: Converts a serial number to a day of the month]
Date & Time Function: DAYS360 [Description: Calculates the number of days between two dates based on a 360-day year]
Date & Time Function: EDATE [Description: Returns the serial number of the date that is the indicated number of months before or after the start date]
Date & Time Function: EOMONTH [Description: Returns the serial number of the last day of the month before or after a specified number of months]
Date & Time Function: HOUR [Description: Converts a serial number to an hour]
Date & Time Function: MINUTE [Description: Converts a serial number to a minute]
Date & Time Function: MONTH [Description: Converts a serial number to a month]
Date & Time Function: NETWORKDAYS [Description: Returns the number of whole workdays between two dates]
Date & Time Function: NOW [Description: Returns the serial number of the current date and time]
Date & Time Function: SECOND [Description: Converts a serial number to a second]
Date & Time Function: TIME [Description: Returns the serial number of a particular time]
Date & Time Function: TIMEVALUE [Description: Converts a time in the form of text to a serial number]
Date & Time Function: TODAY [Description: Returns the serial number of today's date]
Date & Time Function: WEEKDAY [Description: Converts a serial number to a day of the week]
Date & Time Function: WEEKNUM [Description: Converts a serial number to a number representing where the week falls numerically with a year]
Date & Time Function: WORKDAY [Description: Returns the serial number of the date before or after a specified number of workdays]
Date & Time Function: YEAR [Description: Converts a serial number to a year]
Date & Time Function: YEARFRAC [Description: Returns the year fraction representing the number of whole days between start_date and end_date]
Engineering Function: BESSELI [Description: Returns the modified Bessel function In(x)]
Engineering Function: BESSELJ [Description: Returns the Bessel function Jn(x)]
Engineering Function: BESSELK [Description: Returns the modified Bessel function Kn(x)]
Engineering Function: BESSELY [Description: Returns the Bessel function Yn(x)]
Engineering Function: BIN2DEC [Description: Converts a binary number to decimal]
Engineering Function: BIN2HEX [Description: Converts a binary number to hexadecimal]
Engineering Function: BIN2OCT [Description: Converts a binary number to octal]
Engineering Function: COMPLEX [Description: Converts real and imaginary coefficients into a complex number]
Engineering Function: CONVERT [Description: Converts a number from one measurement system to another]
Engineering Function: DEC2BIN [Description: Converts a decimal number to binary]
Engineering Function: DEC2HEX [Description: Converts a decimal number to hexadecimal]
Engineering Function: DEC2OCT [Description: Converts a decimal number to octal]
Engineering Function: DELTA [Description: Tests whether two values are equal]
Engineering Function: ERF [Description: Returns the error function]
Engineering Function: ERFC [Description: Returns the complementary error function]
Engineering Function: GESTEP [Description: Tests whether a number is greater than a threshold value]
Engineering Function: HEX2BIN [Description: Converts a hexadecimal number to binary]
Engineering Function: HEX2DEC [Description: Converts a hexadecimal number to decimal]
Engineering Function: HEX2OCT [Description: Converts a hexadecimal number to octal]
Engineering Function: IMABS [Description: Returns the absolute value (modulus) of a complex number]
Engineering Function: IMAGINARY [Description: Returns the imaginary coefficient of a complex number]
Engineering Function: IMARGUMENT [Description: Returns the argument theta, an angle expressed in radians]
Engineering Function: IMCONJUGATE [Description: Returns the complex conjugate of a complex number]
Engineering Function: IMCOS [Description: Returns the cosine of a complex number]
Engineering Function: IMDIV [Description: Returns the quotient of two complex numbers]
Engineering Function: IMEXP [Description: Returns the exponential of a complex number]
Engineering Function: IMLN [Description: Returns the natural logarithm of a complex number]
Engineering Function: IMLOG10 [Description: Returns the base-10 logarithm of a complex number]
Engineering Function: IMLOG2 [Description: Returns the base-2 logarithm of a complex number]
Engineering Function: IMPOWER [Description: Returns a complex number raised to an integer power]
Engineering Function: IMPRODUCT [Description: Returns the product of from 2 to 29 complex numbers]
Engineering Function: IMREAL [Description: Returns the real coefficient of a complex number]
Engineering Function: IMSIN [Description: Returns the sine of a complex number]
Engineering Function: IMSQRT [Description: Returns the square root of a complex number]
Engineering Function: IMSUB [Description: Returns the difference between two complex numbers]
Engineering Function: IMSUM [Description: Returns the sum of complex numbers]
Engineering Function: OCT2BIN [Description: Converts an octal number to binary]
Engineering Function: OCT2DEC [Description: Converts an octal number to decimal]
Engineering Function: OCT2HEX [Description: Converts an octal number to hexadecimal]
External Function: EUROCONVERT [Description: Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation)]
External Function: SQL.REQUEST [Description: 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]
Financial Function: ACCRINT [Description: Returns the accrued interest for a security that pays periodic interest]
Financial Function: ACCRINTM [Description: Returns the accrued interest for a security that pays interest at maturity]
Financial Function: AMORDEGRC [Description: Returns the depreciation for each accounting period by using a depreciation coefficient]
Financial Function: AMORLINC [Description: Returns the depreciation for each accounting period]
Financial Function: COUPDAYBS [Description: Returns the number of days from the beginning of the coupon period to the settlement date]
Financial Function: COUPDAYS [Description: Returns the number of days in the coupon period that contains the settlement date]
Financial Function: COUPDAYSNC [Description: Returns the number of days from the settlement date to the next coupon date]
Financial Function: COUPNCD [Description: Returns the next coupon date after the settlement date]
Financial Function: COUPNUM [Description: Returns the number of coupons payable between the settlement date and maturity date]
Financial Function: COUPPCD [Description: Returns the previous coupon date before the settlement date]
Financial Function: CUMIPMT [Description: Returns the cumulative interest paid between two periods]
Financial Function: CUMPRINC [Description: Returns the cumulative principal paid on a loan between two periods]
Financial Function: DB [Description: Returns the depreciation of an asset for a specified period by using the fixed-declining balance method]
Financial Function: DDB [Description: Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify]
Financial Function: DISC [Description: Returns the discount rate for a security]
Financial Function: DOLLARDE [Description: Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number]
Financial Function: DOLLARFR [Description: Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction]
Financial Function: DURATION [Description: Returns the annual duration of a security with periodic interest payments]
Financial Function: EFFECT [Description: Returns the effective annual interest rate]
Financial Function: FV [Description: Returns the future value of an investment]
Financial Function: FVSCHEDULE [Description: Returns the future value of an initial principal after applying a series of compound interest rates]
Financial Function: INTRATE [Description: Returns the interest rate for a fully invested security]
Financial Function: IPMT [Description: Returns the interest payment for an investment for a given period]
Financial Function: IRR [Description: Returns the internal rate of return for a series of cash flows]
Financial Function: ISPMT [Description: Calculates the interest paid during a specific period of an investment]
Financial Function: MDURATION [Description: Returns the Macauley modified duration for a security with an assumed par value of $100]
Financial Function: MIRR [Description: Returns the internal rate of return where positive and negative cash flows are financed at different rates]
Financial Function: NOMINAL [Description: Returns the annual nominal interest rate]
Financial Function: NPER [Description: Returns the number of periods for an investment]
Financial Function: NPV [Description: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate]
Financial Function: ODDFPRICE [Description: Returns the price per $100 face value of a security with an odd first period]
Financial Function: ODDFYIELD [Description: Returns the yield of a security with an odd first period]
Financial Function: ODDLPRICE [Description: Returns the price per $100 face value of a security with an odd last period]
Financial Function: ODDLYIELD [Description: Returns the yield of a security with an odd last period]
Financial Function: PMT [Description: Returns the periodic payment for an annuity]
Financial Function: PPMT [Description: Returns the payment on the principal for an investment for a given period]
Financial Function: PRICE [Description: Returns the price per $100 face value of a security that pays periodic interest]
Financial Function: PRICEDISC [Description: Returns the price per $100 face value of a discounted security]
Financial Function: PRICEMAT [Description: Returns the price per $100 face value of a security that pays interest at maturity]
Financial Function: PV [Description: Returns the present value of an investment]
Financial Function: RATE [Description: Returns the interest rate per period of an annuity]
Financial Function: RECEIVED [Description: Returns the amount received at maturity for a fully invested security]
Financial Function: SLN [Description: Returns the straight-line depreciation of an asset for one period]
Financial Function: SYD [Description: Returns the sum-of-years' digits depreciation of an asset for a specified period]
Financial Function: TBILLEQ [Description: Returns the bond-equivalent yield for a Treasury bill]
Financial Function: TBILLPRICE [Description: Returns the price per $100 face value for a Treasury bill]
Financial Function: TBILLYIELD [Description: Returns the yield for a Treasury bill]
Financial Function: VDB [Description: Returns the depreciation of an asset for a specified or partial period by using a declining balance method]
Financial Function: XIRR [Description: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic]
Financial Function: XNPV [Description: Returns the net present value for a schedule of cash flows that is not necessarily periodic]
Financial Function: YIELD [Description: Returns the yield on a security that pays periodic interest]
Financial Function: YIELDDISC [Description: Returns the annual yield for a discounted security; for example, a Treasury bill]
Financial Function: YIELDMAT [Description: Returns the annual yield of a security that pays interest at maturity]
Information Function: CELL [Description: Returns information about the formatting, location, or contents of a cell]
Information Function: ERROR.TYPE [Description: Returns a number corresponding to an error type]
Information Function: INFO [Description: Returns information about the current operating environment]
Information Function: ISBLANK [Description: Returns TRUE if the value is blank]
Information Function: ISERR [Description: Returns TRUE if the value is any error value except #N/A]
Information Function: ISERROR [Description: Returns TRUE if the value is any error value]
Information Function: ISEVEN [Description: Returns TRUE if the number is even]
Information Function: ISLOGICAL [Description: Returns TRUE if the value is a logical value]
Information Function: ISNA [Description: Returns TRUE if the value is the #N/A error value]
Information Function: ISNONTEXT [Description: Returns TRUE if the value is not text]
Information Function: ISNUMBER [Description: Returns TRUE if the value is a number]
Information Function: ISODD [Description: Returns TRUE if the number is odd]
Information Function: ISREF [Description: Returns TRUE if the value is a reference]
Information Function: ISTEXT [Description: Returns TRUE if the value is text]
Information Function: N [Description: Returns a value converted to a number]
Information Function: NA [Description: Returns the error value #N/A]
Information Function: TYPE [Description: Returns a number indicating the data type of a value]
Logical Function: AND [Description: Returns TRUE if all of its arguments are TRUE]
Logical Function: IF [Description: Specifies a logical test to perform]
Logical Function: NOT [Description: Reverses the logic of its argument]
Logical Function: OR [Description: Returns TRUE if any argument is TRUE]
Logical Function: FALSE [Description: Returns the logical value FALSE]
Logical Function: TRUE [Description: Returns the logical value TRUE]
Lookup & Reference Function: ADDRESS [Description: Returns a reference as text to a single cell in a worksheet]
Lookup & Reference Function: AREAS [Description: Returns the number of areas in a reference]
Lookup & Reference Function: CHOOSE [Description: Chooses a value from a list of values]
Lookup & Reference Function: COLUMN [Description: Returns the column number of a reference]
Lookup & Reference Function: COLUMNS [Description: Returns the number of columns in a reference]
Lookup & Reference Function: GETPIVOTDATA [Description: Returns data stored in a PivotTable]
Lookup & Reference Function: HLOOKUP [Description: Looks in the top row of an array and returns the value of the indicated cell]
Lookup & Reference Function: HYPERLINK [Description: Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet]
Lookup & Reference Function: INDEX [Description: Uses an index to choose a value from a reference or array]
Lookup & Reference Function: INDIRECT [Description: Returns a reference indicated by a text value]
Lookup & Reference Function: LOOKUP [Description: Looks up values in a vector or array]
Lookup & Reference Function: MATCH [Description: Looks up values in a reference or array]
Lookup & Reference Function: OFFSET [Description: Returns a reference offset from a given reference]
Lookup & Reference Function: ROW [Description: Returns the row number of a reference]
Lookup & Reference Function: ROWS [Description: Returns the number of rows in a reference]
Lookup & Reference Function: RTD [Description: Retrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).)]
Lookup & Reference Function: TRANSPOSE [Description: Returns the transpose of an array]
Lookup & Reference Function: VLOOKUP [Description: Looks in the first column of an array and moves across the row to return the value of a cell]
Math & Trigonometry Function: ABS [Description: Returns the absolute value of a number]
Math & Trigonometry Function: ACOS [Description: Returns the arccosine of a number]
Math & Trigonometry Function: ACOSH [Description: Returns the inverse hyperbolic cosine of a number]
Math & Trigonometry Function: ASIN [Description: Returns the arcsine of a number]
Math & Trigonometry Function: ASINH [Description: Returns the inverse hyperbolic sine of a number]
Math & Trigonometry Function: ATAN [Description: Returns the arctangent of a number]
Math & Trigonometry Function: ATAN2 [Description: Returns the arctangent from x- and y-coordinates]
Math & Trigonometry Function: ATANH [Description: Returns the inverse hyperbolic tangent of a number]
Math & Trigonometry Function: CEILING [Description: Rounds a number to the nearest integer or to the nearest multiple of significance]
Math & Trigonometry Function: COMBIN [Description: Returns the number of combinations for a given number of objects]
Math & Trigonometry Function: COS [Description: Returns the cosine of a number]
Math & Trigonometry Function: COSH [Description: Returns the hyperbolic cosine of a number]
Math & Trigonometry Function: DEGREES [Description: Converts radians to degrees]
Math & Trigonometry Function: EVEN [Description: Rounds a number up to the nearest even integer]
Math & Trigonometry Function: EXP [Description: Returns e raised to the power of a given number]
Math & Trigonometry Function: FACT [Description: Returns the factorial of a number]
Math & Trigonometry Function: FACTDOUBLE [Description: Returns the double factorial of a number]
Math & Trigonometry Function: FLOOR [Description: Rounds a number down, toward zero]
Math & Trigonometry Function: GCD [Description: Returns the greatest common divisor]
Math & Trigonometry Function: INT [Description: Rounds a number down to the nearest integer]
Math & Trigonometry Function: LCM [Description: Returns the least common multiple]
Math & Trigonometry Function: LN [Description: Returns the natural logarithm of a number]
Math & Trigonometry Function: LOG [Description: Returns the logarithm of a number to a specified base]
Math & Trigonometry Function: LOG10 [Description: Returns the base-10 logarithm of a number]
Math & Trigonometry Function: MDETERM [Description: Returns the matrix determinant of an array]
Math & Trigonometry Function: MINVERSE [Description: Returns the matrix inverse of an array]
Math & Trigonometry Function: MMULT [Description: Returns the matrix product of two arrays]
Math & Trigonometry Function: MOD [Description: Returns the remainder from division]
Math & Trigonometry Function: MROUND [Description: Returns a number rounded to the desired multiple]
Math & Trigonometry Function: MULTINOMIAL [Description: Returns the multinomial of a set of numbers]
Math & Trigonometry Function: ODD [Description: Rounds a number up to the nearest odd integer]
Math & Trigonometry Function: PI [Description: Returns the value of pi]
Math & Trigonometry Function: POWER [Description: Returns the result of a number raised to a power]
Math & Trigonometry Function: PRODUCT [Description: Multiplies its arguments]
Math & Trigonometry Function: QUOTIENT [Description: Returns the integer portion of a division]
Math & Trigonometry Function: RADIANS [Description: Converts degrees to radians]
Math & Trigonometry Function: RAND [Description: Returns a random number between 0 and 1]
Math & Trigonometry Function: RANDBETWEEN [Description: Returns a random number between the numbers you specify]
Math & Trigonometry Function: ROMAN [Description: Converts an arabic numeral to roman, as text]
Math & Trigonometry Function: ROUND [Description: Rounds a number to a specified number of digits]
Math & Trigonometry Function: ROUNDDOWN [Description: Rounds a number down, toward zero]
Math & Trigonometry Function: ROUNDUP [Description: Rounds a number up, away from zero]
Math & Trigonometry Function: SERIESSUM [Description: Returns the sum of a power series based on the formula]
Math & Trigonometry Function: SIGN [Description: Returns the sign of a number]
Math & Trigonometry Function: SIN [Description: Returns the sine of the given angle]
Math & Trigonometry Function: SINH [Description: Returns the hyperbolic sine of a number]
Math & Trigonometry Function: SQRT [Description: Returns a positive square root]
Math & Trigonometry Function: SQRTPI [Description: Returns the square root of (number * pi)]
Math & Trigonometry Function: SUBTOTAL [Description: Returns a subtotal in a list or database]
Math & Trigonometry Function: SUM [Description: Adds its arguments]
Math & Trigonometry Function: SUMIF [Description: Adds the cells specified by a given criteria]
Math & Trigonometry Function: SUMPRODUCT [Description: Returns the sum of the products of corresponding array components]
Math & Trigonometry Function: SUMSQ [Description: Returns the sum of the squares of the arguments]
Math & Trigonometry Function: SUMX2MY2 [Description: Returns the sum of the difference of squares of corresponding values in two arrays]
Math & Trigonometry Function: SUMX2PY2 [Description: Returns the sum of the sum of squares of corresponding values in two arrays]
Math & Trigonometry Function: SUMXMY2 [Description: Returns the sum of squares of differences of corresponding values in two arrays]
Math & Trigonometry Function: TAN [Description: Returns the tangent of a number]
Math & Trigonometry Function: TANH [Description: Returns the hyperbolic tangent of a number]
Math & Trigonometry Function: TRUNC [Description: Truncates a number to an integer]
Statistical Function: AVEDEV [Description: Returns the average of the absolute deviations of data points from their mean]
Statistical Function: AVERAGE [Description: Returns the average of its arguments]
Statistical Function: AVERAGEA [Description: Returns the average of its arguments, including numbers, text, and logical values]
Statistical Function: BETADIST [Description: Returns the beta cumulative distribution function]
Statistical Function: BETAINV [Description: Returns the inverse of the cumulative distribution function for a specified beta distribution]
Statistical Function: BINOMDIST [Description: Returns the individual term binomial distribution probability]
Statistical Function: CHIDIST [Description: Returns the one-tailed probability of the chi-squared distribution]
Statistical Function: CHIINV [Description: Returns the inverse of the one-tailed probability of the chi-squared distribution]
Statistical Function: CHITEST [Description: Returns the test for independence]
Statistical Function: CONFIDENCE [Description: Returns the confidence interval for a population mean]
Statistical Function: CORREL [Description: Returns the correlation coefficient between two data sets]
Statistical Function: COUNT [Description: Counts how many numbers are in the list of arguments]
Statistical Function: COUNTA [Description: Counts how many values are in the list of arguments]
Statistical Function: COUNTBLANK [Description: Counts the number of blank cells within a range]
Statistical Function: COUNTIF [Description: Counts the number of nonblank cells within a range that meet the given criteria]
Statistical Function: COVAR [Description: Returns covariance, the average of the products of paired deviations]
Statistical Function: CRITBINOM [Description: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value]
Statistical Function: DEVSQ [Description: Returns the sum of squares of deviations]
Statistical Function: EXPONDIST [Description: Returns the exponential distribution]
Statistical Function: FDIST [Description: Returns the F probability distribution]
Statistical Function: FINV [Description: Returns the inverse of the F probability distribution]
Statistical Function: FISHER [Description: Returns the Fisher transformation]
Statistical Function: FISHERINV [Description: Returns the inverse of the Fisher transformation]
Statistical Function: FORECAST [Description: Returns a value along a linear trend]
Statistical Function: FREQUENCY [Description: Returns a frequency distribution as a vertical array]
Statistical Function: FTEST [Description: Returns the result of an F-test]
Statistical Function: GAMMADIST [Description: Returns the gamma distribution]
Statistical Function: GAMMAINV [Description: Returns the inverse of the gamma cumulative distribution]
Statistical Function: GAMMALN [Description: Returns the natural logarithm of the gamma function, Γ(x)]
Statistical Function: GEOMEAN [Description: Returns the geometric mean]
Statistical Function: GROWTH [Description: Returns values along an exponential trend]
Statistical Function: HARMEAN [Description: Returns the harmonic mean]
Statistical Function: HYPGEOMDIST [Description: Returns the hypergeometric distribution]
Statistical Function: INTERCEPT [Description: Returns the intercept of the linear regression line]
Statistical Function: KURT [Description: Returns the kurtosis of a data set]
Statistical Function: LARGE [Description: Returns the k-th largest value in a data set]
Statistical Function: LINEST [Description: Returns the parameters of a linear trend]
Statistical Function: LOGEST [Description: Returns the parameters of an exponential trend]
Statistical Function: LOGINV [Description: Returns the inverse of the lognormal distribution]
Statistical Function: LOGNORMDIST [Description: Returns the cumulative lognormal distribution]
Statistical Function: MAX [Description: Returns the maximum value in a list of arguments]
Statistical Function: MAXA [Description: Returns the maximum value in a list of arguments, including numbers, text, and logical values]
Statistical Function: MEDIAN [Description: Returns the median of the given numbers]
Statistical Function: MIN [Description: Returns the minimum value in a list of arguments]
Statistical Function: MINA [Description: Returns the smallest value in a list of arguments, including numbers, text, and logical values]
Statistical Function: MODE [Description: Returns the most common value in a data set]
Statistical Function: NEGBINOMDIST [Description: Returns the negative binomial distribution]
Statistical Function: NORMDIST [Description: Returns the normal cumulative distribution]
Statistical Function: NORMINV [Description: Returns the inverse of the normal cumulative distribution]
Statistical Function: NORMSDIST [Description: Returns the standard normal cumulative distribution]
Statistical Function: NORMSINV [Description: Returns the inverse of the standard normal cumulative distribution]
Statistical Function: PEARSON [Description: Returns the Pearson product moment correlation coefficient]
Statistical Function: PERCENTILE [Description: Returns the k-th percentile of values in a range]
Statistical Function: PERCENTRANK [Description: Returns the percentage rank of a value in a data set]
Statistical Function: PERMUT [Description: Returns the number of permutations for a given number of objects]
Statistical Function: POISSON [Description: Returns the Poisson distribution]
Statistical Function: PROB [Description: Returns the probability that values in a range are between two limits]
Statistical Function: QUARTILE [Description: Returns the quartile of a data set]
Statistical Function: RANK [Description: Returns the rank of a number in a list of numbers]
Statistical Function: RSQ [Description: Returns the square of the Pearson product moment correlation coefficient]
Statistical Function: SKEW [Description: Returns the skewness of a distribution]
Statistical Function: SLOPE [Description: Returns the slope of the linear regression line]
Statistical Function: SMALL [Description: Returns the k-th smallest value in a data set]
Statistical Function: STANDARDIZE [Description: Returns a normalized value]
Statistical Function: STDEV [Description: Estimates standard deviation based on a sample]
Statistical Function: STDEVA [Description: Estimates standard deviation based on a sample, including numbers, text, and logical values]
Statistical Function: STDEVP [Description: Calculates standard deviation based on the entire population]
Statistical Function: STDEVPA [Description: Calculates standard deviation based on the entire population, including numbers, text, and logical values]
Statistical Function: STEYX [Description: Returns the standard error of the predicted y-value for each x in the regression]
Statistical Function: TDIST [Description: Returns the Student's t-distribution]
Statistical Function: TINV [Description: Returns the inverse of the Student's t-distribution]
Statistical Function: TREND [Description: Returns values along a linear trend]
Statistical Function: TRIMMEAN [Description: Returns the mean of the interior of a data set]
Statistical Function: TTEST [Description: Returns the probability associated with a Student's t-test]
Statistical Function: VAR [Description: Estimates variance based on a sample]
Statistical Function: VARA [Description: Estimates variance based on a sample, including numbers, text, and logical values]
Statistical Function: VARP [Description: Calculates variance based on the entire population]
Statistical Function: VARPA [Description: Calculates variance based on the entire population, including numbers, text, and logical values]
Statistical Function: WEIBULL [Description: Returns the Weibull distribution]
Statistical Function: ZTEST [Description: Returns the one-tailed probability-value of a z-test]
Text Function: ASC [Description: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters]
Text Function: BAHTTEXT [Description: Converts a number to text, using the ß (baht) currency format]
Text Function: CHAR [Description: Returns the character specified by the code number]
Text Function: CLEAN [Description: Removes all nonprintable characters from text]
Text Function: CODE [Description: Returns a numeric code for the first character in a text string]
Text Function: CONCATENATE [Description: Joins several text items into one text item]
Text Function: DOLLAR [Description: Converts a number to text, using the $ (dollar) currency format]
Text Function: EXACT [Description: Checks to see if two text values are identical]
Text Function: FIND, FINDB [Description: Finds one text value within another (case-sensitive)]
Text Function: FIXED [Description: Formats a number as text with a fixed number of decimals]
Text Function: JIS [Description: Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters]
Text Function: LEFT, LEFTB [Description: Returns the leftmost characters from a text value]
Text Function: LEN, LENB [Description: Returns the number of characters in a text string]
Text Function: LOWER [Description: Converts text to lowercase]
Text Function: MID, MIDB [Description: Returns a specific number of characters from a text string starting at the position you specify]
Text Function: PHONETIC [Description: Extracts the phonetic (furigana) characters from a text string]
Text Function: PROPER [Description: Capitalizes the first letter in each word of a text value]
Text Function: REPLACE, REPLACEB [Description: Replaces characters within text]
Text Function: REPT [Description: Repeats text a given number of times]
Text Function: RIGHT, RIGHTB [Description: Returns the rightmost characters from a text value]
Text Function: SEARCH, SEARCHB [Description: Finds one text value within another (not case-sensitive)]
Text Function: SUBSTITUTE [Description: Substitutes new text for old text in a text string]
Text Function: T [Description: Converts its arguments to text]
Text Function: TEXT [Description: Formats a number and converts it to text]
Text Function: TRIM [Description: Removes spaces from text]
Text Function: UPPER [Description: Converts text to uppercase]
Text Function: VALUE [Description: Converts a text argument to a number]
Information technology (IT) is the study, design, development, implementation, support or management of computer-based information systems. IT deals with the use of electronic computers and computer software to convert, store, protect, process, transmit, and securely retrieve information.
No comments:
Post a Comment