Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel
Bài viết này sẽ cung cấp cho các bạn Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel qua từng phiên bản mà Microsoft đã cung cấp cho người dùng. Các hàm trong Microsoft Excel thường là một trong 2 loại là worksheet function (WS) và VBA function (VBA), có một số hàm là cả hai loại.
+ Worksheet function (WS): Là một được sử dụng trong các trang tính (Worksheet ), cho phép người dùng nhập như một phần của công thức trong một ô của trang tính.
+ VBA function (VBA): Người dùng có thể sử dụng hàm này trong mã macro được nhập thông qua Microsoft Visual Basic Editor.
Ngoài các hàm được Microsoft Excel, người dùng có thể tự tạo ra các hàm mới bằng cách code và tận dụng các hàm đã có sẵn bằng ngôn ngữ lập trình Microsoft Visual Basic thông qua Microsoft Visual Basic Editor. Bạn có thể bật chế độ Developer và vào Microsoft Visual Basic Editor ở bài viết tại đây.
Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel theo thứ từ Anphabet.
| Tên | Ý nghĩa hàm | Loại hàm | Phiên bản Excel hỗ trợ |
|---|---|---|---|
| ABS (WS, VBA) | Returns the absolute value of a number | WS, VBA | |
| ACCRINT (WS) | Returns the accrued interest for a security that pays interest on a periodic basis | WS | |
| ACCRINTM (WS) | Returns the accrued interest for a security that pays interest at maturity | WS | |
| ACOS (WS) | Returns the arccosine (in radians) of a number | WS | |
| ACOSH (WS) | Returns the inverse hyperbolic cosine of a number | WS | |
| ADDRESS (WS) | Returns a text representation of a cell address | WS | |
| AGGREGATE (WS) | Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows | WS | |
| AMORDEGRC (WS) | Returns the linear depreciation of an asset for each accounting period, on a prorated basis | WS | |
| AMORLINC (WS) | Returns the depreciation of an asset for each accounting period, on a prorated basis | WS | |
| AND (WS) | Returns TRUE if all conditions are TRUE | WS | |
| AND (VBA) | Returns TRUE if all conditions are TRUE | VBA | |
| AREAS (WS) | Returns the number of ranges in a reference | WS | |
| ASC (VBA) | Returns ASCII value of a character | VBA | |
| ASIN (WS) | Returns the arcsine (in radians) of a number | WS | |
| ASINH (WS) | Returns the inverse hyperbolic sine of a number | WS | |
| ATAN (WS) | Returns the arctangent (in radians) of a number | WS | |
| ATAN2 (WS) | Returns the arctangent (in radians) of (x,y) coordinates | WS | |
| ATANH (WS) | Returns the inverse hyperbolic tangent of a number | WS | |
| ATN (VBA) | Returns the arctangent of a number | VBA | |
| AVEDEV (WS) | Returns the average of the absolute deviations of the numbers provided | WS | |
| AVERAGE (WS) | Returns the average of the numbers provided | WS | |
| AVERAGEA (WS) | Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0 | WS | |
| AVERAGEIF (WS) | Returns the average of all numbers in a range of cells, based on a given criteria | WS | |
| AVERAGEIFS (WS) | Returns the average of all numbers in a range of cells, based on multiple criteria | WS | |
| BAHTTEXT (WS) | Returns the number in Thai text | WS | |
| BETA.DIST (WS) | Returns the beta distribution | WS | |
| BETA.INV (WS) | Returns the inverse of the cumulative beta probability density function | WS | |
| BETADIST (WS) | Returns the cumulative beta probability density function | WS | |
| BETAINV (WS) | Returns the inverse of the cumulative beta probability density function | WS | |
| BIN2DEC (WS) | Converts a binary number to a decimal number | WS | |
| BIN2HEX (WS) | Converts a binary number to a hexadecimal number | WS | |
| BIN2OCT (WS) | Converts a binary number to an octal number | WS | |
| BINOM.DIST (WS) | Returns the individual term binomial distribution probability | WS | |
| BINOM.INV (WS) | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion | WS | |
| BINOMDIST (WS) | Returns the individual term binomial distribution probability | WS | |
| CASE (VBA) | Has the functionality of an IF-THEN-ELSE statement | VBA | |
| CBOOL (VBA) | Converts a value to a boolean | VBA | |
| CBYTE (VBA) | Converts a value to a byte (ie: number between 0 and 255) | VBA | |
| CCUR (VBA) | Converts a value to currency | VBA | |
| CDATE (VBA) | Converts a value to a date | VBA | |
| CDBL (VBA) | Converts a value to a double | VBA | |
| CDEC (VBA) | Converts a value to a decimal number | VBA | |
| CEILING (WS) | Returns a number rounded up based on a multiple of significance | WS | |
| CEILING.PRECISE (WS) | Returns a number rounded up to the nearest integer or to the nearest multiple of significance | WS | |
| CELL (WS) | Used to retrieve information about a cell such as contents, formatting, size, etc. | WS | |
| CHAR (WS) | Returns the character based on the ASCII value | WS | |
| CHDIR (VBA) | Used to change the current directory or folder | VBA | |
| CHDRIVE (VBA) | Used to change the current drive | VBA | |
| CHIDIST (WS) | Returns the one-tailed probability of the chi-squared distribution | WS | |
| CHIINV (WS) | Returns the inverse of the one-tailed probability of the chi-squared distribution | WS | |
| CHITEST (WS) | Returns the value from the chi-squared distribution | WS | |
| CHOOSE (WS, VBA) | Returns a value from a list of values based on a given position | WS, VBA | |
| CHR (VBA) | Returns the character based on the ASCII value | VBA | |
| CINT (VBA) | Converts a value to an integer | VBA | |
| CLEAN (WS) | Removes all nonprintable characters from a string | WS | |
| CLNG (VBA) | Converts a value to a long integer | VBA | |
| CODE (WS) | Returns the ASCII value of a character or the first character in a cell | WS | |
| COLUMN (WS) | Returns the column number of a cell reference | WS | |
| COLUMNS (WS) | Returns the number of columns in a cell reference | WS | |
| COMBIN (WS) | Returns the number of combinations for a specified number of items | WS | |
| COMBINA (WS) | Returns the number of combinations for a specified number of items and includes repetitions | WS | |
| COMPLEX (WS) | Converts coefficients (real and imaginary) into a complex number | WS | |
| CONCAT (WS) | Used to join 2 or more strings together | WS | |
| CONCATENATE (WS) | Used to join 2 or more strings together (replaced by CONCAT Function) | WS | |
| CONCATENATE with & (WS, VBA) | Used to join 2 or more strings together using the & operator | WS, VBA | |
| CONVERT (WS) | Convert a number from one measurement unit to another measurement unit | WS | |
| COS (WS, VBA) | Returns the cosine of an angle | WS, VBA | |
| COSH (WS) | Returns the hyperbolic cosine of a number | WS | |
| COUNT (WS) | Counts the number of cells that contain numbers as well as the number of arguments that contain numbers | WS | |
| COUNTA (WS) | Counts the number of cells that are not empty as well as the number of value arguments provided | WS | |
| COUNTBLANK (WS) | Counts the number of empty cells in a range | WS | |
| COUNTIF (WS) | Counts the number of cells in a range, that meets a given criteria | WS | |
| COUNTIFS (WS) | Counts the number of cells in a range, that meets a single or multiple criteria | WS | |
| COVAR (WS) | Returns the covariance, the average of the products of deviations for two data sets | WS | |
| CSNG (VBA) | Converts a value to a single-precision number | VBA | |
| CSTR (VBA) | Converts a value to a string | VBA | |
| CURDIR (VBA) | Returns the current path | VBA | |
| CVAR (VBA) | Converts a value to a variant | VBA | |
| DATE (WS) | Returns the serial date value for a date | WS | |
| DATE (VBA) | Returns the current system date | VBA | |
| DATEADD (VBA) | Returns a date after which a certain time/date interval has been added | VBA | |
| DATEDIF (WS) | Returns the difference between two date values, based on the interval specified | WS | |
| DATEDIFF (VBA) | Returns the difference between two date values, based on the interval specified | VBA | |
| DATEPART (VBA) | Returns a specified part of a given date | VBA | |
| DATESERIAL (VBA) | Returns a date given a year, month, and day value | VBA | |
| DATEVALUE (WS, VBA) | Returns the serial number of a date | WS, VBA | |
| DAVERAGE (WS) | Averages all numbers in a column in a list or database, based on a given criteria | WS | |
| DAY (WS, VBA) | Returns the day of the month (a number from 1 to 31) given a date value | WS, VBA | |
| DAYS (WS) | Returns the number of days between 2 dates | WS | |
| DAYS360 (WS) | Returns the number of days between two dates based on a 360-day year | WS | |
| DB (WS) | Returns the depreciation of an asset based on the fixed-declining balance method | WS | |
| DCOUNT (WS) | Returns the number of cells in a column or database that contains numeric values and meets a given criteria | WS | |
| DCOUNTA (WS) | Returns the number of cells in a column or database that contains nonblank values and meets a given criteria | WS | |
| DDB (WS, VBA) | Returns the depreciation of an asset based on the double-declining balance method | WS, VBA | |
| DEGREES (WS) | Converts radians into degrees | WS | |
| DGET (WS) | Retrieves from a database a single record that matches a given criteria | WS | |
| DIR (VBA) | Returns the first filename that matches the pathname and attributes specified | VBA | |
| DMAX (WS) | Returns the largest number in a column in a list or database, based on a given criteria | WS | |
| DMIN (WS) | Returns the smallest number in a column in a list or database, based on a given criteria | WS | |
| DOLLAR (WS) | Converts a number to text, using a currency format | WS | |
| DPRODUCT (WS) | Returns the product of the numbers in a column in a list or database, based on a given criteria | WS | |
| DSTDEV (WS) | Returns the standard deviation of a population based on a sample of numbers | WS | |
| DSTDEVP (WS) | Returns the standard deviation of a population based on the entire population of numbers | WS | |
| DSUM (WS) | Sums the numbers in a column or database that meets a given criteria | WS | |
| DVAR (WS) | Returns the variance of a population based on a sample of numbers | WS | |
| DVARP (WS) | Returns the variance of a population based on the entire population of numbers | WS | |
| EDATE (WS) | Adds a specified number of months to a date and returns the result as a serial date | WS | |
| ENVIRON (VBA) | Returns the value of an operating system environment variable | VBA | |
| EOMONTH (WS) | Calculates the last day of the month after adding a specified number of months to a date | WS | |
| ERROR.TYPE (WS) | Returns the numeric representation of an Excel error | WS | |
| EVEN (WS) | Rounds a number up to the nearest even integer | WS | |
| EXACT (WS) | Compares two strings and returns TRUE if both values are the same | WS | |
| EXP (WS, VBA) | Returns e raised to the nth power | WS, VBA | |
| FACT (WS) | Returns the factorial of a number | WS | |
| FALSE (WS) | Returns a logical value of FALSE | WS | |
| FILEDATETIME (VBA) | Returns the date and time of when a file was created or last modified | VBA | |
| FILELEN (VBA) | Returns the size of a file in bytes | VBA | |
| FIND (WS) | Returns the location of a substring in a string (case-sensitive) | WS | |
| FIX (VBA) | Returns the integer portion of a number | VBA | |
| FIXED (WS) | Returns a text representation of a number rounded to a specified number of decimal places | WS | |
| FLOOR (WS) | Returns a number rounded down based on a multiple of significance | WS | |
| FOR…NEXT (VBA) | Used to create a FOR LOOP | VBA | |
| FORECAST (WS) | Returns a prediction of a future value based on existing values provided | WS | |
| FORMAT DATES (VBA) | Takes a date expression and returns it as a formatted string | VBA | |
| FORMAT NUMBERS (VBA) | Takes a numeric expression and returns it as a formatted string | VBA | |
| FORMAT STRINGS (VBA) | Takes a string expression and returns it as a formatted string | VBA | |
| FREQUENCY (WS) | Returns how often values occur within a set of data. It returns a vertical array of numbers | WS | |
| FV (WS, VBA) | Returns the future value of an investment | WS, VBA | |
| GETATTR (VBA) | Returns an integer that represents the attributes of a file, folder, or directory | VBA | |
| GROWTH (WS) | Returns the predicted exponential growth based on existing values provided | WS | |
| HLOOKUP (WS) | Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number | WS | |
| HOUR (WS, VBA) | Returns the hours (a number from 0 to 23) from a time value | WS, VBA | |
| HYPERLINK (WS) | Creates a shortcut to a file or Internet address | WS | |
| IF (WS) | Returns one value if the condition is TRUE or another value if the condition is FALSE | WS | |
| IF (more than 7) (WS) | Nest more than 7 IF functions | more than | |
| IF (up to 7) (WS) | Nest up to 7 IF functions | up to 7 | |
| IF-THEN-ELSE (VBA) | Returns a value if a specified condition evaluates to TRUE or another value if it evaluates to FALSE | VBA | |
| IFERROR (WS) | Used to return an alternate value if a formula results in an error | WS | |
| IFNA (WS) | Used to return an alternate value if a formula results in #N/A error | WS | |
| IFS (WS) | Specify multiple IF conditions within 1 function | WS | |
| INDEX (WS) | Returns either the value or the reference to a value from a table or range | WS | |
| INDIRECT (WS) | Returns the reference to a cell based on its string representation | WS | |
| INFO (WS) | Returns information about the operating environment | WS | |
| INSTR (VBA) | Returns the position of the first occurrence of a substring in a string | VBA | |
| INSTRREV (VBA) | Returns the position of the first occurrence of a string in another string, starting from the end of the string | VBA | |
| INT (WS, VBA) | Returns the integer portion of a number | WS, VBA | |
| INTERCEPT (WS) | Returns the y-axis intersection point of a line using x-axis values and y-axis values | WS | |
| IPMT (WS, VBA) | Returns the interest payment for an investment | WS, VBA | |
| IRR (WS, VBA) | Returns the internal rate of return for a series of cash flows | WS, VBA | |
| ISBLANK (WS) | Used to check for blank or null values | WS | |
| ISDATE (VBA) | Returns TRUE if the expression is a valid date | VBA | |
| ISEMPTY (VBA) | Used to check for blank cells or uninitialized variables | VBA | |
| ISERR (WS) | Used to check for error values except #N/A | WS | |
| ISERROR (WS, VBA) | Used to check for error values | WS, VBA | |
| ISLOGICAL (WS) | Used to check for a logical value (TRUE or FALSE) | WS | |
| ISNA (WS) | Used to check for #N/A error | WS | |
| ISNONTEXT (WS) | Used to check for a value that is not text | WS | |
| ISNULL (VBA) | Used to check for a NULL value | VBA | |
| ISNUMBER (WS) | Used to check for a numeric value | WS | |
| ISNUMERIC (VBA) | Used to check for a numeric value | VBA | |
| ISOWEEKNUM (WS) | Returns the ISO week number for a date | WS | |
| ISPMT (WS) | Returns the interest payment for an investment | WS | |
| ISREF (WS) | Used to check for a reference | WS | |
| ISTEXT (WS) | Used to check for a text value | WS | |
| LARGE (WS) | Returns the nth largest value from a set of values | WS | |
| LCASE (VBA) | Converts a string to lowercase | VBA | |
| LEFT (WS, VBA) | Extract a substring from a string, starting from the left-most character | WS, VBA | |
| LEN (WS, VBA) | Returns the length of the specified string | WS, VBA | |
| LINEST (WS) | Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line | WS | |
| LN (WS) | Returns the natural logarithm of a number | WS | |
| LOG (WS) | Returns the logarithm of a number to a specified base | WS | |
| LOG (VBA) | Returns the natural logarithm of a number | VBA | |
| LOG10 (WS) | Returns the base-10 logarithm of a number | WS | |
| LOOKUP (WS) | Returns a value from a range (one row or one column) or from an array | WS | |
| LOWER (WS) | Converts all letters in the specified string to lowercase | WS | |
| LTRIM (VBA) | Removes leading spaces from a string | VBA | |
| MATCH (WS) | Searches for a value in an array and returns the relative position of that item | WS | |
| MAX (WS) | Returns the largest value from the numbers provided | WS | |
| MAXA (WS) | Returns the largest value from the values provided (numbers, text and logical values) | WS | |
| MAXIFS (WS) | Returns the largest value in a range, that meets a single or multiple criteria | WS | |
| MDETERM (WS) | Returns the matrix determinant of an array | WS | |
| MEDIAN (WS) | Returns the median of the numbers provided | WS | |
| MID (WS, VBA) | Extracts a substring from a string (starting at any position) | WS, VBA | |
| MIN (WS) | Returns the smallest value from the numbers provided | WS | |
| MINA (WS) | Returns the smallest value from the values provided (numbers, text and logical values) | WS | |
| MINIFS (WS) | Returns the smallest value in a range, that meets a single or multiple criteria | WS | |
| MINUTE (WS, VBA) | Returns the minutes (a number from 0 to 59) from a time value | WS, VBA | |
| MINVERSE (WS) | Returns the inverse matrix for a given matrix | WS | |
| MIRR (WS, VBA) | Returns the modified internal rate of return for a series of cash flows | WS, VBA | |
| MKDIR (VBA) | Used to create a new folder or directory | VBA | |
| MMULT (WS) | Returns the matrix product of two arrays | WS | |
| MOD (WS) | Returns the remainder after a number is divided by a divisor | WS | |
| MODE (WS) | Returns most frequently occurring number | WS | |
| MODE.MULT (WS) | Returns a vertical array of the most frequently occurring numbers | WS | |
| MODE.SNGL (WS) | Returns most frequently occurring number | WS | |
| MONTH (WS, VBA) | Returns the month (a number from 1 to 12) given a date value | WS, VBA | |
| MONTHNAME (VBA) | Returns a string representing the month given a number from 1 to 12 | VBA | |
| N (WS) | Converts a value to a number | WS | |
| NA (WS) | Returns the #N/A error value | WS | |
| NETWORKDAYS (WS) | Returns the number of work days between 2 dates, excluding weekends and holidays | WS | |
| NETWORKDAYS.INTL (WS) | Returns the number of work days between 2 dates, excluding weekends and holidays | WS | |
| NOT (WS) | Returns the reversed logical value | WS | |
| NOW (WS, VBA) | Returns the current system date and time | WS, VBA | |
| NPER (WS, VBA) | Returns the number of periods for an investment | WS, VBA | |
| NPV (WS, VBA) | Returns the net present value of an investment | WS, VBA | |
| NUMBERVALUE (WS) | Returns a text to a number specifying the decimal and group separators | WS | |
| ODD (WS) | Rounds a number up to the nearest odd integer | WS | |
| OFFSET (WS) | Returns a reference to a range that is offset a number of rows and columns | WS | |
| OR (WS) | Returns TRUE if any of the conditions are TRUE | WS | |
| OR (VBA) | Returns TRUE if any of the conditions are TRUE | VBA | |
| PERCENTILE (WS) | Returns the nth percentile from a set of values | WS | |
| PERCENTRANK (WS) | Returns the nth percentile from a set of values | WS | |
| PERMUT (WS) | Returns the number of permutations for a specified number of items | WS | |
| PI (WS) | Returns the mathematical constant called pi | WS | |
| PMT (WS, VBA) | Returns the payment amount for a loan | WS, VBA | |
| POWER (WS) | Returns the result of a number raised to a given power | WS | |
| PPMT (WS, VBA) | Returns the payment on the principal for a particular payment | WS, VBA | |
| PRODUCT (WS) | Multiplies the numbers and returns the product | WS | |
| PROPER (WS) | Sets the first character in each word to uppercase and the rest to lowercase | WS | |
| PV (WS, VBA) | Returns the present value of an investment | WS, VBA | |
| QUARTILE (WS) | Returns the quartile from a set of values | WS | |
| RADIANS (WS) | Converts degrees into radians | WS | |
| RAND (WS) | Returns a random number that is greater than or equal to 0 and less than 1 | WS | |
| RANDBETWEEN (WS) | Returns a random number that is between a bottom and top range | WS | |
| RANDOMIZE (VBA) | Used to change the seed value used by the random number generator for the RND function | VBA | |
| RANK (WS) | Returns the rank of a number within a set of numbers | WS | |
| RATE (WS, VBA) | Returns the interest rate for an annuity | WS, VBA | |
| REPLACE (WS) | Replaces a sequence of characters in a string with another set of characters | WS | |
| REPLACE (VBA) | Replaces a sequence of characters in a string with another set of characters | VBA | |
| REPT (WS) | Returns a repeated text value a specified number of times | WS | |
| RIGHT (WS, VBA) | Extracts a substring from a string starting from the right-most character | WS, VBA | |
| RND (VBA) | Used to generate a random number (integer value) | VBA | |
| ROMAN (WS) | Converts a number to roman numeral | WS | |
| ROUND (WS) | Returns a number rounded to a specified number of digits | WS | |
| ROUND (VBA) | Returns a number rounded to a specified number of digits | VBA | |
| ROUNDDOWN (WS) | Returns a number rounded down to a specified number of digits | WS | |
| ROUNDUP (WS) | Returns a number rounded up to a specified number of digits | WS | |
| ROW (WS) | Returns the row number of a cell reference | WS | |
| ROWS (WS) | Returns the number of rows in a cell reference | WS | |
| RTRIM (VBA) | Removes trailing spaces from a string | VBA | |
| SEARCH (WS) | Returns the location of a substring in a string | WS | |
| SECOND (WS) | Returns the seconds (a number from 0 to 59) from a time value | WS | |
| SETATTR (VBA) | Used to set the attributes of a file | VBA | |
| SGN (VBA) | Returns the sign of a number | VBA | |
| SIGN (WS) | Returns the sign of a number | WS | |
| SIN (WS, VBA) | Returns the sine of an angle | WS, VBA | |
| SINH (WS) | Returns the hyperbolic sine of a number | WS | |
| SLN (WS, VBA) | Returns the depreciation of an asset based on the straight-line depreciation method | WS, VBA | |
| SLOPE (WS) | Returns the slope of a regression line based on the data points identified by known_y_values and known_x_values | WS | |
| SMALL (WS) | Returns the nth smallest value from a set of values | WS | |
| SPACE (VBA) | Returns a string with a specified number of spaces | VBA | |
| SPLIT (VBA) | Used to split a string into substrings based on a delimiter | VBA | |
| SQR (VBA) | Returns the square root of a number | VBA | |
| SQRT (WS) | Returns the square root of a number | WS | |
| STDEV (WS) | Returns the standard deviation of a population based on a sample of numbers | WS | |
| STDEVA (WS) | Returns the standard deviation of a population based on a sample of numbers, text, and logical values | WS | |
| STDEVP (WS) | Returns the standard deviation of a population based on an entire population of numbers | WS | |
| STDEVPA (WS) | Returns the standard deviation of a population based on an entire population of numbers, text, and logical values | WS | |
| STR (VBA) | Returns a string representation of a number | VBA | |
| STRCOMP (VBA) | Returns an integer value representing the result of a string comparison | VBA | |
| STRCONV (VBA) | Returns a string converted to uppercase, lowercase, proper case or Unicode | VBA | |
| STRREVERSE (VBA) | Returns a string whose characters are in reverse order | VBA | |
| SUBSTITUTE (WS) | Replaces a set of characters with another | WS | |
| SUBTOTAL (WS) | Returns the subtotal of the numbers in a column in a list or database | WS | |
| SUM (WS) | Adds all numbers in a range of cells | WS | |
| SUMIF (WS) | Adds all numbers in a range of cells based on one criteria | WS | |
| SUMIFS (WS) | Adds all numbers in a range of cells, based on a single or multiple criteria | WS | |
| SUMPRODUCT (WS) | Multiplies the corresponding items in the arrays and returns the sum of the results | WS | |
| SUMSQ (WS) | Returns the sum of the squares of a series of values | WS | |
| SUMX2MY2 (WS) | Returns the sum of the difference of squares between two arrays | WS | |
| SUMX2PY2 (WS) | Returns the sum of the squares of corresponding items in the arrays | WS | |
| SUMXMY2 (WS) | Returns the sum of the squares of the differences between corresponding items in the arrays | WS | |
| SWITCH (WS) | Compares an expression to a list of values and returns the corresponding result | WS | |
| SWITCH (VBA) | Evaluates a list of expressions and returns the corresponding value for the first expression in the list that is TRUE | VBA | |
| SYD (WS, VBA) | Returns the depreciation of an asset based on the sum-of-years’ digits depreciation method | WS, VBA | |
| T (WS) | Returns the text referred to by a value | WS | |
| TAN (WS, VBA) | Returns the tangent of an angle | WS, VBA | |
| TANH (WS) | Returns the hyperbolic tangent of a number | WS | |
| TEXT (WS) | Returns a value converted to text with a specified format | WS | |
| TEXTJOIN (WS) | Used to join 2 or more strings together separated by a delimiter | WS | |
| TIME (WS) | Returns a decimal number given an hour, minute and second value | WS | |
| TIMESERIAL (VBA) | Returns a time given an hour, minute, and second value | VBA | |
| TIMEVALUE (WS, VBA) | Returns the serial number of a time | WS, VBA | |
| TODAY (WS) | Returns the current system date | WS | |
| TRANSPOSE (WS) | Returns a transposed range of cells | WS | |
| TRIM (WS, VBA) | Returns a text value with the leading and trailing spaces removed | WS, VBA | |
| TRUE (WS) | Returns a logical value of TRUE | WS | |
| TRUNC (WS) | Returns a number truncated to a specified number of digits | WS | |
| TYPE (WS) | Returns the type of a value | WS | |
| UCASE (VBA) | Converts a string to all uppercase | VBA | |
| UNICHAR (WS) | Returns the Unicode character based on the Unicode number provided | WS | |
| UNICODE (WS) | Returns the Unicode number of a character or the first character in a string | WS | |
| UPPER (WS) | Convert text to all uppercase | WS | |
| VAL (VBA) | Returns the numbers found in a string | VBA | |
| VALUE (WS) | Converts a text value that represents a number to a number | WS | |
| VAR (WS) | Returns the variance of a population based on a sample of numbers | WS | |
| VARA (WS) | Returns the variance of a population based on a sample of numbers, text, and logical values | WS | |
| VARP (WS) | Returns the variance of a population based on an entire population of numbers | WS | |
| VARPA (WS) | Returns the variance of a population based on an entire population of numbers, text, and logical values | WS | |
| VDB (WS) | Returns the depreciation of an asset based on a variable declining balance depreciation method | WS | |
| VLOOKUP (WS) | Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position | WS | |
| WEEKDAY (WS, VBA) | Returns a number representing the day of the week, given a date value | WS, VBA | |
| WEEKDAYNAME (VBA) | Returns a string representing the day of the week given a number from 1 to 7 | VBA | |
| WEEKNUM (WS) | Returns the week number for a date | WS | |
| WHILE…WEND (VBA) | Used to create a WHILE LOOP | VBA | |
| WORKDAY (WS) | Adds a specified number of work days to a date and returns the result as a serial date | WS | |
| WORKDAY.INTL (WS) | Adds a specified number of work days to a date and returns the result as a serial date (customizable weekends) | WS | |
| XIRR (WS) | Returns the internal rate of return for a series of cash flows that may not be periodic | WS | |
| YEAR (WS, VBA) | Returns a four-digit year (a number from 1900 to 9999) given a date value | WS, VBA | |
| YEARFRAC (WS) | Returns the number of days between 2 dates as a year fraction | WS |
