|
|
||
|
|
|
Excel Index and Search Tool (Click
on the buttons below) |
Excel Lesson 30 of 30: All Excel FunctionsThere are ten categories of functions in Excel. Here they are. All the 329 functions and what they do. 84 of these spreadsheet functions are available only when you activate the "Analysis ToolPak" add-in. To do so go to "Tools/Add-ins" and check the Analysis ToolPak. From then on, you have 40 Engineering functions, 6 more functions in the Date & Time category, 36 more in the Financial category and 2 more functions in the Information category. Unless you are an Engineer or a Financial Analyst these functions are not very useful. There is another problem with these functions: If you use them and send your worboook to somebody who hasn't activated the "Analysis Toolpack" they wont work on his computer. There are 9 essential functions (AVERAGE, CONCATENATE, COUNT, IF, INDEX, ISERROR, MATCH, SUM, SUMPRODUCT) and 44 interesting others. The other functions are either specialized, rarely used or obsolete. For example, COUNTIF, SUMIF, LOOKUP, HLOOKUP and VLOOKUP become obsolete when you discover the more powerful yet easy to work with SUMPRODUCT and INDEX/MATCH. |
|
The most powerful and useful function in Excel is SUMPRODUCT |
| Excel Text Functions (24) |
| Importance | Functions | What it Does |
| Interesting | DATE | Returns the serial number of a particular date (See lesson 22) |
| Interesting |
DATEDIF |
Calculates the interval between two dates (See lesson 22) |
| Interesting | DAY | Converts a serial number to a day of the month (See lesson 22) |
| Interesting | HOUR | Converts a serial number to an hour (See lesson 22) |
| Interesting | MINUTE | Converts a serial number to a minute (See lesson 22) |
| Interesting | MONTH | Converts a serial number to a month (See lesson 22) |
| Interesting | NOW | Returns the serial number of the current date and time (See lesson 22) |
| Interesting | SECOND | Converts a serial number to a second (See lesson 22) |
| Interesting | TIME | Returns the serial number of a particular time (See lesson 22) |
| Interesting | TODAY | Returns the serial number of today's date (See lesson 22) |
| Interesting | WEEKDAY | Converts a serial number to a day of the week (See lesson 22) |
| Interesting | YEAR | Converts a serial number to a year (See lesson 22) |
| Rarely Used | DATEVALUE | Converts a date in the form of text to a serial number |
| Rarely Used | DAYS360 | Calculates the number of days between two dates based on a 360-day year |
| Rarely Used | EDATE | Returns the serial number of the date that is the indicated number of months before or after the start date |
| Rarely Used | EOMONTH | Returns the serial number of the last day of the month before or after a specified number of months |
| Rarely Used | NETWORKDAYS | Returns the number of whole workdays between two dates |
| Rarely Used | TIMEVALUE | Converts a time in the form of text to a serial number |
| Rarely Used | WEEKNUM | Converts a serial number to a number representing where the week falls numerically with a year |
| Rarely Used | WORKDAY | Returns the serial number of the date before or after a specified number of workdays |
| Rarely Used | YEARFRAC | Returns the year fraction representing the number of whole days between start_date and end_date |
| Importance | Functions | What it Does |
| Specialized | BESSELI | Returns the modified Bessel function In(x) |
| Specialized | BESSELJ | Returns the Bessel function Jn(x) |
| Specialized | BESSELK | Returns the modified Bessel function Kn(x) |
| Specialized | BESSELY | Returns the Bessel function Yn(x) |
| Specialized | BIN2DEC | Converts a binary number to decimal |
| Specialized | BIN2HEX | Converts a binary number to hexadecimal |
| Specialized | BIN2OCT | Converts a binary number to octal |
| Specialized | COMPLEX | Converts real and imaginary coefficients into a complex number |
| Specialized | CONVERT | Converts a number from one measurement system to another |
| Specialized | DEC2BIN | Converts a decimal number to binary |
| Specialized | DEC2HEX | Converts a decimal number to hexadecimal |
| Specialized | DEC2OCT | Converts a decimal number to octal |
| Specialized | DELTA | Tests whether two values are equal |
| Specialized | ERF | Returns the error function |
| Specialized | ERFC | Returns the complementary error function |
| Specialized | FACTDOUBLE | Returns the double factorial of a number |
| Specialized | GESTEP | Tests whether a number is greater than a threshold value |
| Specialized | HEX2BIN | Converts a hexadecimal number to binary |
| Specialized | HEX2DEC | Converts a hexadecimal number to decimal |
| Specialized | HEX2OCT | Converts a hexadecimal number to octal |
| Specialized | IMABS | Returns the absolute value (modulus) of a complex number |
| Specialized | IMAGINARY | Returns the imaginary coefficient of a complex number |
| Specialized | IMARGUMENT | Returns the argument theta, an angle expressed in radians |
| Specialized | IMCONJUGAT | Returns the complex conjugate of a complex number |
| Specialized | IMCOS | Returns the cosine of a complex number |
| Specialized | IMDIV | Returns the quotient of two complex numbers |
| Specialized | IMEXP | Returns the exponential of a complex number |
| Specialized | IMLN | Returns the natural logarithm of a complex number |
| Specialized | IMLOG10 | Returns the base-10 logarithm of a complex number |
| Specialized | IMLOG2 | Returns the base-2 logarithm of a complex number |
| Specialized | IMPOWER | Returns a complex number raised to an integer power |
| Specialized | IMPRODUCT | Returns the product of two complex numbers |
| Specialized | IMREAL | Returns the real coefficient of a complex number |
| Specialized | IMSIN | Returns the sine of a complex number |
| Specialized | IMSQRT | Returns the square root of a complex number |
| Specialized | IMSUB | Returns the difference between two complex numbers |
| Specialized | IMSUM | Returns the sum of complex numbers |
| Specialized | OCT2BIN | Converts an octal number to binary |
| Specialized | OCT2DEC | Converts an octal number to decimal |
| Specialized | OCT2HEX | Converts an octal number to hexadecimal |
| Importance | Functions | What it Does |
| Specialized | ACCRINT | Returns the accrued interest for a security that pays periodic interest |
| Specialized | ACCRINTM | Returns the accrued interest for a security that pays interest at maturity |
| Specialized | AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient |
| Specialized | AMORLINC | Returns the depreciation for each accounting period |
| Specialized | COUPDAYBS | Returns the number of days from the beginning of the coupon period to the settlement date |
| Specialized | COUPDAYS | Returns the number of days in the coupon period that contains the settlement date |
| Specialized | COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date |
| Specialized | COUPNCD | Returns the next coupon date after the settlement date |
| Specialized | COUPNUM | Returns the number of coupons payable between the settlement date and maturity date |
| Specialized | COUPPCD | Returns the previous coupon date before the settlement date |
| Specialized | CUMIPMT | Returns the cumulative interest paid between two periods |
| Specialized | CUMPRINC | Returns the cumulative principal paid on a loan between two periods |
| Specialized | DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
| Specialized | DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify |
| Specialized | DISC | Returns the discount rate for a security |
| Specialized | DOLLARDE | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
| Specialized | DOLLARFR | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
| Specialized | DURATION | Returns the annual duration of a security with periodic interest payments |
| Specialized | EFFECT | Returns the effective annual interest rate |
| Specialized | FV | Returns the future value of an investment (See lesson 23) |
| Specialized | FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates |
| Specialized | INTRATE | Returns the interest rate for a fully invested security |
| Specialized | IPMT | Returns the interest payment for an investment for a given period |
| Specialized | IRR | Returns the internal rate of return for a series of cash flows |
| Specialized | ISPMT | Returns the interest paid during a specific period of an investment |
| Specialized | MDURATION | Returns the Macauley modified duration for a security with an assumed par value of $100 |
| Specialized | MIRR | Returns the internal rate of return where positive and negative cash flows are financed at different rates |
| Specialized | NOMINAL | Returns the annual nominal interest rate |
| Specialized | NPER | Returns the number of periods for an investmen (See lesson 23)t |
| Specialized | NPV | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
| Specialized | ODDFPRICE | Returns the price per $100 face value of a security with an odd first period |
| Specialized | ODDFYIELD | Returns the yield of a security with an odd first period |
| Specialized | ODDLPRICE | Returns the price per $100 face value of a security with an odd last period |
| Specialized | ODDLYIELD | Returns the yield of a security with an odd last period |
| Specialized | PMT | Returns the periodic payment for an annuity (See lesson 23) |
| Specialized | PPMT | Returns the payment on the principal for an investment for a given period |
| Specialized | PRICE | Returns the price per $100 face value of a security that pays periodic interest |
| Specialized | PRICEDISC | Returns the price per $100 face value of a discounted security |
| Specialized | PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity |
| Specialized | PV | Returns the present value of an investment |
| Specialized | RATE | Returns the interest rate per period of an annuity |
| Specialized | RECEIVED | Returns the amount received at maturity for a fully invested security |
| Specialized | SLN | Returns the straight-line depreciation of an asset for one period |
| Specialized | SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period |
| Specialized | TBILLEQ | Returns the bond-equivalent yield for a Treasury bill |
| Specialized | TBILLPRICE | Returns the price per $100 face value for a Treasury bill |
| Specialized | TBILLYIELD | Returns the yield for a Treasury bill |
| Specialized | VDB | Returns the depreciation of an asset for a specified or partial period using a declining balance method |
| Specialized | XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
| Specialized | XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic |
| Specialized | YIELD | Returns the yield on a security that pays periodic interest |
| Specialized | YIELDDISC | Returns the annual yield for a discounted security; for example, a Treasury bill |
| Specialized | YIELDMAT | Returns the annual yield of a security that pays interest at maturity |
| Importance | Functions | What it Does |
| Essential | ISERROR | Returns TRUE if the value is any error value (See lesson 17) |
| Interesting | CELL | Returns information about the formatting, location, or contents of a cell (See lesson 24) |
| Rarely Used |
ERROR.TYPE | Returns a number corresponding to an error type |
| Rarely Used |
INFO | Returns information about the current operating environment |
| Rarely Used |
ISBLANK | Returns TRUE if the value is BLANK |
| Rarely Used |
ISERR | Returns TRUE if the value is any error value except #N/A |
| Rarely Used |
ISEVEN | Returns TRUE if the number is even |
| Rarely Used |
ISLOGICAL | Returns TRUE if the value is a logical value |
|
Rarely Used |
ISNONTEXT | Returns TRUE if the value is not text |
|
Rarely Used |
ISNUMBER | Returns TRUE if the value is a number |
|
Rarely Used |
ISNA | Returns TRUE if the value is the #N/A error value |
|
Rarely Used |
ISODD | Returns TRUE if the value is odd |
|
Rarely Used |
ISREF | Returns TRUE if the value is a reference |
|
Rarely Used |
ISTEXT | Returns TRUE if the value is text |
|
Rarely Used |
N | Returns a value converted to a number |
| Rarely Used |
NA | Returns the error value #N/A |
| Rarely Used |
TYPE | Returns a number indicating the data type of a value |
| Importance | Functions | What it Does |
| Essential | IF | Specifies a logical test to perform (See lesson 25) |
| Interesting | AND | Returns TRUE if all its arguments are TRUE (See lesson 25) |
| Interesting | NOT | Reverses the logic of its argument (See lesson 25) |
| Interesting | OR | Returns TRUE if any argument is TRUE (See lesson 25) |
| Rarely Used | FALSE | Returns the logical value FALSE |
| Rarely Used | TRUE | Returns the logical value TRUE |
|
Microsoft Excel Spreadsheet Lookup and Reference Functions (18) * The Lookup functions (VLOOKUP, HLOOKUP and LOOKUP) are rarely used by people who have discovered the much more powerful SUMPRODUCT and INDEX/MATCH. |
||
| Importance | Functions | What it Does |
| Essential | INDEX | Uses an index to choose a value from a reference or array (See lesson 19) |
| Essential | MATCH | Looks up values in a reference or array (See lesson 19) |
| Interesting | INDIRECT | Returns a reference indicated by a text value (See lesson 26) |
| Interesting | OFFSET | Returns a reference offset from a given reference (See lesson 26) |
| Interesting | ADDRESS | Returns a reference as text to a single cell in a worksheet |
| Rarely Used | AREAS | Returns the number of areas in a reference |
| Rarely Used | COLUMN | Returns the column number of a reference |
| Rarely Used | COLUMNS | Returns the number of columns in a reference |
| Rarely Used | CHOOSE | Chooses a value from a list of values |
| Rarely Used | GETPIVOTDATA | Returns data stored in a PivotTable |
| Obsolete | HLOOKUP | Looks in the top row of an array and returns the value of the indicated cell (See why it is obsolete) |
| Rarely Used | HYPERLINK | Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
| Obsolete | LOOKUP | Looks up values in a vector or array (See why it is obsolete) |
| Rarely Used | ROW | Returns the row number of a reference |
| Rarely Used | ROWS | Returns the number of rows in a reference |
| Rarely Used | RTD | Retrieves real-time data from a program that supports COM automation (Automation : Fa�on de travailler avec les objets d'une application � partir d'une autre application ou d'un autre outil de d�veloppement. Autrefois appel�e OLE Automation, Automation es |
| Rarely Used | TRANSPOSE | Returns the transpose of an array |
| Obsolete | VLOOKUP | Looks in the first column of an array and moves across the row to return the value of a cell (See why it is obsolete) |
| Importance | Functions | What it Does |
| Essential | SUM | Adds its arguments (See lesson 27) |
| Essential | SUMPRODUCT | The most powerful and useful function in Excel (See lesson 18) |
| Interesting | ABS | Returns the absolute value of a number (See lesson 27) |
| Interesting | ROUND | Rounds a number to a specified number of digits (See lesson 27) |
| Interesting | ROUNDUP | Rounds a number up, away from zero (See lesson 27) |
| Interesting | SUBTOTAL | Returns a subtotal of a filtered list or database (See lesson 20) |
| Interesting | TRUNC | Truncates a number to an integer (See lesson 27) |
| Interesting | MOD | Returns the remainder from division (See lesson 27) |
| Interesting | INT | Rounds a number down to the nearest integer (See lesson 27) |
| Interesting | POWER | Returns the result of a number raised to a power (See lesson 27) |
| Interesting | SQRT | Returns a positive square root (See lesson 27) |
| Rarely Used | EVEN | Rounds a number up to the nearest even integer |
| Rarely Used | EXP | Returns e raised to the power of a given number |
| Rarely Used | FLOOR | Rounds a number down, toward zero |
| Rarely Used | ROUNDDOWN | Rounds a number down, toward zero |
| Rarely Used | GCD | Returns the greatest common divisor |
| Rarely Used | LCM | Returns the least common multiple |
| Rarely Used | ODD | Rounds a number up to the nearest odd integer |
| Rarely Used | MROUND | Returns a number rounded to the desired multiple |
| Rarely Used | PRODUCT | Multiplies its arguments |
| Rarely Used | QUOTIENT | Returns the integer portion of a division |
| Rarely Used | RAND | Returns a random number between 0 and 1 |
| Rarely Used | RANDBETWEEN | Returns a random number between the numbers you specify |
| Rarely Used | ROMAN | Converts an arabic numeral to roman, as text |
| Rarely Used | SIGN | Returns the sign of a number |
| Rarely Used | CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance |
| Rarely Used | COMBIN | Returns the number of combinations for a given number of objects |
| Specialized | ACOS | Returns the arccosine of a number |
| Specialized | ACOSH | Returns the inverse hyperbolic cosine of a number |
| Specialized | ASIN | Returns the arcsine of a number |
| Specialized | ASINH | Returns the inverse hyperbolic sine of a number |
| Specialized | ATAN | Returns the arctangent of a number |
| Specialized | ATAN2 | Returns the arctangent from x- and y-coordinates |
| Specialized | ATANH | Returns the inverse hyperbolic tangent of a number |
| Specialized | COS | Returns the cosine of a number |
| Specialized | COSH | Returns the hyperbolic cosine of a number |
| Specialized | DEGREES | Converts radians to degrees |
| Specialized | FACT | Returns the factorial of a number |
| Specialized | LN | Returns the natural logarithm of a number |
| Specialized | LOG | Returns the logarithm of a number to a specified base |
| Specialized | LOG10 | Returns the base-10 logarithm of a number |
| Specialized | MDETERM | Returns the matrix determinant of an array |
| Specialized | MINVERSE | Returns the matrix inverse of an array |
| Specialized | MMULT | Returns the matrix product of two arrays |
| Specialized | MULTINOMIA | Returns the multinomial of a set of numbers |
| Specialized | PI | Returns the value of pi |
| Specialized | RADIANS | Converts degrees to radians |
| Specialized | SERIESSUM | Returns the sum of a power series based on the formula |
| Specialized | SIN | Returns the sine of the given angle |
| Specialized | SINH | Returns the hyperbolic sine of a number |
| Specialized | SQRTPI | Returns the square root of (number * pi) |
| Obsolete | SUMIF | Adds the cells specified by a given criteria (See why it is rarely used) |
| Specialized | SUMSQ | Returns the sum of the squares of the arguments |
| Specialized | SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays |
| Specialized | SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays |
| Specialized | SUMXMY2 | Returns the sum of squares of differences of corresponding values in two arrays |
| Specialized | TAN | Returns the tangent of a number |
| Specialized | TANH | Returns the hyperbolic tangent of a number |
|
Microsoft Excel Spreadsheet Statistical Functions (80) * COUNTIF and SUMIF are rarely used by people who have discovered the much more powerful SUMPRODUCT |
||
| Importance | Functions | What it Does |
| Essential | COUNT | Counts how many numbers are in the list of arguments (See lesson 28) |
| Essential | AVERAGE | Returns the average of its arguments (See lesson 28) |
| Interesting | COUNTA | Counts how many values are in the list of arguments (See lesson 28) |
| Interesting | AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values (See lesson 28) |
| Interesting | MAX | Returns the maximum value in a list of arguments (See lesson 28) |
| Interesting | MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values (See lesson 28) |
| Interesting | MIN | Returns the minimum value in a list of arguments (See lesson 28) |
| Interesting | MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values (See lesson 28) |
| Interesting | RANK | Returns the rank of a number in a list of numbers (See lesson 28) |
| Rarely Used | COUNTBLANK | Counts the number of blank cells within a range |
| Obsolete | COUNTIF | Counts the number of nonblank cells within a range that meet the given criteria (See why it is rarely used) |
| Specialized | AVEDEV | Returns the average of the absolute deviations of data points from their mean |
| Specialized | BETADIST | Returns the cumulative beta probability density function |
| Specialized | BETAINV | Returns the inverse of the cumulative beta probability density function |
| Specialized | BINOMDIST | Returns the individual term binomial distribution probability |
| Specialized | CHIDIST | Returns the one-tailed probability of the chi-squared distribution |
| Specialized | CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution |
| Specialized | CHITEST | Returns the test for independence |
| Specialized | CONFIDENCE | Returns the confidence interval for a population mean |
| Specialized | CORREL | Returns the correlation coefficient between two data sets |
| Specialized | COVAR | Returns covariance, the average of the products of paired deviations |
| Specialized | CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
| Specialized | DEVSQ | Returns the sum of squares of deviations |
| Specialized | EXPONDIST | Returns the exponential distribution |
| Specialized | FDIST | Returns the F probability distribution |
| Specialized | FINV | Returns the inverse of the F probability distribution |
| Specialized | FISHER | Returns the Fisher transformation |
| Specialized | FISHERINV | Returns the inverse of the Fisher transformation |
| Specialized | FORECAST | Returns a value along a linear trend |
| Specialized | FREQUENCY | Returns a frequency distribution as a vertical array |
| Specialized | FTEST | Returns the result of an F-test |
| Specialized | GAMMADIST | Returns the gamma distribution |
| Specialized | GAMMAINV | Returns the inverse of the gamma cumulative distribution |
| Specialized | GAMMALN | Returns the natural logarithm of the gamma function, Γ(x) |
| Specialized | GEOMEAN | Returns the geometric mean |
| Specialized | GROWTH | Returns values along an exponential trend |
| Specialized | HARMEAN | Returns the harmonic mean |
| Specialized | HYPGEOMDIST | Returns the hypergeometric distribution |
| Specialized | INTERCEPT | Returns the intercept of the linear regression line |
| Specialized | KURT | Returns the kurtosis of a data set |
| Specialized | LARGE | Returns the k-th largest value in a data set |
| Specialized | LINEST | Returns the parameters of a linear trend |
| Specialized | LOGEST | Returns the parameters of an exponential trend |
| Specialized | LOGINV | Returns the inverse of the lognormal distribution |
| Specialized | LOGNORMDIST | Returns the cumulative lognormal distribution |
| Specialized | MEDIAN | Returns the median of the given numbers |
| Specialized | MODE | Returns the most common value in a data set |
| Specialized | NEGBINOMDIST | Returns the negative binomial distribution |
| Specialized | NORMDIST | Returns the normal cumulative distribution |
| Specialized | NORMINV | Returns the inverse of the normal cumulative distribution |
| Specialized | NORMSDIST | Returns the standard normal cumulative distribution |
| Specialized | NORMSINV | Returns the inverse of the standard normal cumulative distribution |
| Specialized | PEARSON | Returns the Pearson product moment correlation coefficient |
| Specialized | PERCENTILE | Returns the k-th percentile of values in a range |
| Specialized | PERCENTRANK | Returns the percentage rank of a value in a data set |
| Specialized | PERMUT | Returns the number of permutations for a given number of objects |
| Specialized | POISSON | Returns the Poisson distribution |
| Specialized | PROB | Returns the probability that values in a range are between two limits |
| Specialized | QUARTILE | Returns the quartile of a data set |
| Specialized | RSQ | Returns the square of the Pearson product moment correlation coefficient |
| Specialized | SKEW | Returns the skewness of a distribution |
| Specialized | SLOPE | Returns the slope of the linear regression line |
| Specialized | SMALL | Returns the k-th smallest value in a data set |
| Specialized | STANDARDIZE | Returns a normalized value |
| Specialized | STDEV | Estimates standard deviation based on a sample |
| Specialized | STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values |
| Specialized | STDEVP | Calculates standard deviation based on the entire population |
| Specialized | STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values |
| Specialized | STEYX | Returns the standard error of the predicted y-value for each x in the regression |
| Specialized | TDIST | Returns the Student's t-distribution |
| Specialized | TINV | Returns the inverse of the Student's t-distribution |
| Specialized | TREND | Returns values along a linear trend |
| Specialized | TRIMMEAN | Returns the mean of the interior of a data set |
| Specialized | TTEST | Returns the probability associated with a Student's t-test |
| Specialized | VAR | Estimates variance based on a sample |
| Specialized | VARA | Estimates variance based on a sample, including numbers, text, and logical values |
| Specialized | VARP | Calculates variance based on the entire population |
| Specialized | VARPA | Calculates variance based on the entire population, including numbers, text, and logical values |
| Specialized | WEIBULL | Returns the Weibull distribution |
| Specialized | ZTEST | Returns the two-tailed P-value of a z-test |
| Importance | Functions | What it Does |
| Essential | CONCATENATE | Joins several text items into one text item (See lesson 29) |
| Interesting | FIND | Finds one text value within another (case-sensitive) (See lesson 29) |
| Interesting | LEFT | Returns the leftmost characters from a text value (See lesson 29) |
| Interesting | LEN | Returns the number of characters in a text string (See lesson 29) |
| Interesting | MID | Returns a specific number of characters from a text string starting at the position you specify (See lesson 29) |
| Interesting | REPT | Repeats text a given number of times (See lesson 29) |
| Interesting | RIGHT | Returns the rightmost characters from a text value (See lesson 29) |
| Interesting | TEXT | Formats a number and converts it to text (See lesson 29) |
| Interesting | TRIM | Removes spaces from text (See lesson 29) |
| Interesting | VALUE | Converts a text argument to a number (See lesson 29) |
|
Rarely Used |
BAHTTEXT | Converts a number to text, using the � (baht) currency format |
|
Rarely Used |
CHAR | Returns the character specified by the code number |
|
Rarely Used |
CLEAN | Removes all nonprintable characters from text |
|
Rarely Used |
CODE | Returns a numeric code for the first character in a text string |
|
Rarely Used |
DOLLAR | Converts a number to text, using the $ (dollar) currency format |
|
Rarely Used |
EXACT | Checks to see if two text values are identical |
|
Rarely Used |
FIXED | Formats a number as text with a fixed number of decimals |
|
Rarely Used |
LOWER | Converts text to lowercase |
|
Rarely Used |
PROPER | Capitalizes the first letter in each word of a text value |
|
Rarely Used |
REPLACE | Replaces characters within text |
|
Rarely Used |
SEARCH | Finds one text value within another (not case-sensitive) |
|
Rarely Used |
SUBSTITUTE | Substitutes new text for old text in a text string |
|
Rarely Used |
T | Converts its arguments to text |
|
Rarely Used |
UPPER | Converts text to uppercase |
|
Excel Index and Search Tool (Click
on the buttons below) |
|
|
||
|
|