| Name (@) | Returns | Classification |
| Unary – | Subtraction negation | Arithmetic Operator |
| + | Addition |
Arithmetic Operator |
| – | Subtraction | Arithmetic Operator |
| * | Multiplication | Arithmetic Operator |
| / | Division | Arithmetic Operator |
| ^ | Exponentiation | Arithmetic Operator |
| Unary | Addition | Arithmetic Operator |
| = | Equal to | Comparison Operator |
| <> | Not equal to | Comparison Operator |
| <= | Less than or equal to | Comparison Operator |
| >= | Greater than or equal to | Comparison Operator |
| < | Less than | Comparison Operator |
| > | Greater than | Comparison Operator |
| & | Connects, or concatenates, two values to produce one continuous text value | Text Operator |
| DATE (yr, mon, day) | The date number of yr, mon, day | Date & Time |
| DAY(date number) | The day number of date number | Date & Time |
| HOUR(time number) | The hour number of time number | Date & Time |
| MINUTE(time number) | The minute number of time number | Date & Time |
| MONTH(date number) | The month number of date number | Date & Time |
| NOW() | The serial number for the current date and time | Date & Time |
| SECOND(time number) | The second number of time number | Date & Time |
| TIME(hr, min, sec) | The time number of hr, min, sec | Date & Time |
| TIMEVALUE(time_text) | The year number of a date | Date & Time |
| TODAY() | The serial number for the current date | Date & Time |
| WEEKDAY(date number, flags) | The weekday number of date number (flags specifies what number gets mapped to what day) | Date & Time |
| YEAR(date number) | The year number of date number | Date & Time |
| DDB(cost, salvage, life, period, factor) | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify | Financial |
| FV(pmt, int, term) | The future value of a series of equal payments, each of amount pmt, earning periodic interest rate int, over the number of payment periods in term | Financial |
| IRR(range, guess) | The internal rate of return for the series of cash flows in range, based on the approximate percentage guess of the IRR | Financial |
| NPER(rate, pmt, pv, fv,type) | The number of periods for an investment with interest rate per period, payment pmt for each period, present value pv, [and future value fv], base a constant rate, given the type (indicating payment due at the end (0) or beginning (1), default (0) | Financial |
| NPV(int, range list) | The present value of the series of future cash flows in range list, discounted at periodic interest rate int | Financial |
| PMT(prin, int, term) | The amount of the periodic payment needed to pay off principle prin, at periodic interest rate int, over the number of payment periods in term | Financial |
| PV(pmt, int, term) | The present value of a series of equal payments, each of amount pmt, discounted at periodic interest rate int, over the number of payment periods in term | Financial |
| RATE(nper, pmt, pv, fv,type, guess) | The interest rate per period for an annuity with nper total number of payment periods, pmt payment for each period, present value pv, [and future value fv], given the type (indicating payment due at the end (0) or beginning (1), default (0) | Financial |
| SLN(cost, salvage, life) | Returns the straight-line depreciation of an asset for one period. | Financial |
| SYD(cost, salvage, life, per) | Returns the sum-of-years’ digits depreciation of an asset for a specific period. | Financial |
| AND(list) | Returns TRUE if all its arguments are TRUE; returns FALSE if one or more arguments is FALSE. | Logical |
| OR(list) | Returns TRUE is any argument is TRUE; returns FALSE if all arguments are FALSE. | Logical |
| NOT(x) | Reverses the value of its argument. | Logical |
| TRUE() | Returns the logical value TRUE. | Logical |
| FALSE() | Returns the logical value FALSE. | Logical |
| IF(cond, x, y) | Returns x if condition is TRUE, and y if FALSE | Logical |
| CHOOSE(index, number, value1, value2) | Returns a value from a list of values. | Lookup & Reference |
| COLUMNS(array) | Returns the number of columns in a reference. | Lookup & Reference |
| HLOOKUP(x, range, row number, exact match) | The contents of the cell in row row number which lies directly below the cell in the top row of range that matches x. Row number is relative to the top of the table. The match to x may or may not have to be anexact match. | Lookup & Reference |
| INDEX(reference, row_num, column_num area_num) | Uses an index to choose a value from a reference. | Lookup & Reference |
| MATCH(lookup_value, lookup_reference, match_type) | Looks up values in a reference | Lookup & Reference |
| ROWS(array) | Returns the number of rows in a reference | Lookup & Reference |
| VLOOKUP(x, range, column number, exact match) | The contents of the cell in column column number which lies directly across from the cell in the first column of range that matches x.Column number is relative to the left of the table. The match to x may or may not have to be an exact match. | Lookup & Reference |
| ABS(x) | The absolute value of x | Math & Trig. |
| ACOS(x) | The arc cosine of angle x | Math & Trig. |
| ASIN(x) | The arc sine of angle x | Math & Trig. |
| ATAN(x) | The arc tangent of angle x | Math & Trig. |
| ATAN2(x, y) | The arc tangent of angle y/x | Math & Trig. |
| COS(x) | The cosine of angle x | Math & Trig. |
| COUNTIF(range, criteria) | Counts the number of non-blank cells within a range that meet the given criteria | Math & Trig. |
| DEGREES(x) | x*180/p | Math & Trig. |
| EVEN (number) | Rounds a number to nearest even integer. Negative numbers are adjusted away from zero. | Math & Trig. |
| EXP(x) | The number e raised to the xth power | Math & Trig. |
| FACT(number) | Returns the factorial of a number | Math & Trig. |
| INT(x) | Rounds a number down to the nearest integer | Math & Trig. |
| LN(x) | The natural log of x | Math & Trig. |
| LOG(number, base) | Returns the log of a number to a specified base. | Math & Trig. |
| LOG10(x) | The log (base 10) of x | Math & Trig. |
| MOD(x, y) | The remainder of x/y | Math & Trig. |
| ODD (number) | Rounds a number up to the nearest odd integer. | Math & Trig. |
| PI() | The number p | Math & Trig. |
| POWER(number, power) | Returns the result of a number raised to a power. | Math & Trig. |
| PRODUCT(number1, number2) | Multiplies its arguments | Math & Trig. |
| RADIANS(x) | x*p/180 | Math & Trig. |
| ROUND(x, n) | x rounded to n places | Math & Trig. |
| SIN(x) | The sine of angle x | Math & Trig. |
| SQRT(x) | The positive square root of x | Math & Trig. |
| SUM(list) | The sum of the values in list | Math & Trig. |
| SUMIF(range, criteria, sum_range) | Adds the cells specified by a given criteria | Math & Trig. |
| TAN(x) | The tangent of angle x | Math & Trig. |
| TRUNC(number, num_digits) | Truncates a number to an integer | Math & Trig. |
| AVERAGE(list) | The average of the values in list | Statistical |
| COUNT(list) | The number of non-blank entries in list | Statistical |
| COUNTA(list) | How many values are in the list of arguments | Statistical |
| COUNTBLANK(range) | Counts the number of blank cells in a range | Statistical |
| MAX(list) | The maximum value in list | Statistical |
| MIN(list) | The minimum value in list | Statistical |
| STDEV(list) | The sample standard deviation of the values in list | Statistical |
| STDEVP(list) | The population standard deviation of the values in list | Statistical |
| VAR(list) | The sample variance of the values in list | Statistical |
| VARP(list) | The population variance of the values in list | Statistical |
| CONCATENATE(string) | Concatenates a list of strings or values together | Text |
| EXACT(text1, text2) | Checks to see if two text values are identical | Text |
| FIND(find_text, within_text, start_num) | Finds one text value within another (case-sensitive) | Text |
| LEFT(text, num_chars) | Returns the leftmost characters from a text value | Text |
| LEN(text) | Returns the number of characters in a string | Text |
| LOWER(text) | < | Text |
| MID(text, start_num, num_chars) | Returns a specific number of characters from a text string | Text |
| PROPER(text) | Capitalizes the first letter in each word of a text value | Text |
| REPLACE(old_text, start_num, num_chars, new_text) | Replaces characters within text | Text |
| REPT(text, number_times) | Repeats text a given number of times | Text |
| RIGHT(text, num_chars) | Returns the rightmost characters from a text value | Text |
| SUBSITUTE(text, old_text, new_text, instance_num) | Substitutes new text for old text in a text string | Text |
| T(value) | Converts its arguments to text | Text |
| TRIM(text) | Removes spaces from text | Text |
| UPPER(text) | Converts text to uppercase | Text |
| VALUE(string) | String that looks like a number in its actual numeric value | Text |
| DAVERAGE(database, field, criteria) | Averages the values in a column in a list or database that match conditions you specify. | Database |
| DCOUNT(database, field, criteria) | Counts the cells that contain numbers in a column in a list or database that match conditions you specify. | Database |
| DCOUNTA(database, field, criteria) | Counts the nonblank cells in a column in a list or database that match conditions you specify. | Database |
| DGET(database, field, criteria) | Extracts a single value from a column in a list or database that matches conditions you specify. | Database |
| DMAX(database, field, criteria) | Returns the largest number in a column in a list or database that matches conditions you specify. | Database |
| DMIN(database, field, criteria) | Returns the smallest number in a column in a list or database that matches conditions you specify. | Database |
| DPRODUCT(database, field, criteria) | Multiplies the values in a column in a list or database that matches conditions you specify. | Database |
| DSTDEV(database, field, criteria) | Estimates the standard deviation based on a sample, using the numbers in a column in a list or database that matches conditions you specify. | Database |
| DSTDEVP(database, field, criteria) | Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify. | Database |
| DSUM(database, field, criteria) | Adds the numbers in a column in a list or database that matches conditions you specify. | Database |
| DVAR(database, field, criteria) | Estimates variance based on a sample, using the numbers in a column in a list or database that matches conditions you specify. | Database |
| DVARP(database, field, criteria) | Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify. | Database |
| ERROR.TYPE(error_val) | Returns a number corresponding to an error type | Informational |
| ISBLANK(value) | TRUE if the value is blank | Informational |
| ISERR(value) | TRUE if the value is any error except #N/A | Informational |
| ISERROR(value) | TRUE if the value is any error value | Informational |
| ISLOGICAL(value) | TRUE if the value is a logical value | Informational |
| ISNA(value) | TRUE if the value is the #N/A | Informational |
| ISNONTEXT(value) | TRUE if the value is not text | Informational |
| ISNUMBER(value) | TRUE if the value is a number | Informational |
| ISTEXT(value) | TRUE if the value is text | Informational |
| N(value) | Returns a value converted to a number | Informational |
| NA() | Returns the error value #N/A | Informational |
