Excel Functions
Date and time
| Function | Purpose | Param,Optional |
|---|---|---|
| DATE | Create a valid date from year, month, and day | year month day |
| DATEDIF | Get days, months, or years between two dates | start_date end_date unit |
| DATEVALUE | Convert a date in text format to a valid date | date_text |
| DAY | Get the day as a number (1-31) from a date | date |
| DAYS | Get days between dates | end_date start_date |
| DAYS360 | Get days between 2 dates in a 360-day year | start_date end_datemethod |
| EDATE | Get the same date in future or past months | start_date months |
| EOMONTH | Get the last day of the month in future or past months | start_date months |
| HOUR | Get the hour as a number (0-23) from a Time | serial_number |
| ISOWEEKNUM | Get ISO week number for a given date | date |
| MINUTE | Get the minute as a number (0-59) from a time | serial_number |
| MONTH | Get the month as a number (1-12) from a date | date |
| NETWORKDAYS | Get the number of working days between two dates | start_date end_dateholidays |
| NETWORKDAYS.INTL | Get work days between two dates | start_date end_dateweekend holidays |
| NOW | Get the current date and time | |
| SECOND | Get the Second as a number (0-59) from a Time | serial_number |
| TIME | Create a time with hours, minutes, and seconds | hour minute second |
| TIMEVALUE | Get a valid time from a text string | time_text |
| TODAY | Get the current date | |
| WEEKDAY | Get the day of the week as a number | serial_numberreturn_type |
| WEEKNUM | Get the week number for a given date | serial_numreturn_type |
| WORKDAY | Get a date n working days in the future or past | start_date daysholidays |
| WORKDAY.INTL | Get date and working days in future or past | start_date daysweekend holidays |
| YEAR | Get the year from a date | date |
| YEARFRAC | Get the fraction of a year between two dates | start_date end_datebasis |
Engineering
| Function | Purpose | Param,Optional |
|---|---|---|
| CONVERT | Convert measurement units | number from_unit to_unit |
Financial
| Function | Purpose | Param,Optional |
|---|---|---|
| FV | Get the future value of an investment | rate nper pmtpv type |
| NPER | Get the number of periods for an investment | rate pmt pvfv type |
| PMT | Get the periodic payment for a loan | rate pmt pvfv type |
| PV | Get the present value of an investment | rate nper pmtfv type |
| RATE | Get the interest rate per period of an annuity | nper pmt pvfv type guess |
Information
| Function | Purpose | Param,Optional |
|---|---|---|
| CELL | Get information about a cell | info_typereference |
| ERROR.TYPE | Test for a specific error value | error_val |
| INFO | Get information about current environment | type_text |
| ISBLANK | Test if a cell is empty | value |
| ISERR | Test for any error but #N/A | value |
| ISERROR | Test for any error | value |
| ISEVEN | Test if a value is even | value |
| ISFORMULA | Test if cell contains a formula | reference |
| ISLOGICAL | Test if a value is logical | value |
| ISNA | Test for the #N/A error | value |
| ISNUMBER | Test for numeric value | value |
| ISODD | Test if a value is odd | value |
| ISREF | Test for a reference | value |
| ISTEXT | Test for a text value | value |
| N | Convert a value to a number | value |
| NA | Create an #N/A error | |
| TYPE | Get the type of value in a cell | value |
Logical
| Function | Purpose | Param,Optional |
|---|---|---|
| AND | Test multiple conditions with AND | logical1logical2 … |
| FALSE | Generate the logical value FALSE | |
| IF | Test for a specific condition | logical_testvalue_if_true value_if_false |
| IFERROR | Trap and handle errors | value value_if_error |
| NOT | Reverse arguments or results | logical |
| OR | Test multiple conditions with OR | logical1logical2 … |
| TRUE | Generate the logical value TRUE | |
| LOG | Get the logarithm of a number | numberbase |
Lookup and reference
| Function | Purpose | Param,Optional |
|---|---|---|
| ADDRESS | Create a cell address from a given row and column | row_num col_numabs_num a1 sheet |
| AREAS | Get the number of areas in a reference. | reference |
| CHOOSE | Get a value from a list based on position | index_num value1value2 … |
| COLUMN | Get the column number of a reference. | reference |
| COLUMNS | Get the number of columns in an array or reference. | array |
| FORMULATEXT | Get the formula in a cell | reference |
| HLOOKUP | Look up a value in a table by matching on the first row | value table row_indexrange_lookup |
| HYPERLINK | Create a clickable link. | link_locationfriendly_name |
| INDEX | Get a value in a list or table based on location | array row_numcol_num area_num |
| INDIRECT | Create a reference from text | ref_texta1 |
| LOOKUP | Look up a value in a one-column range | lookup_value lookup_vectorresult_vector |
| MATCH | Get the position of an item in an array | lookup_value lookup_arraymatch_type |
| OFFSET | Create a reference offset from given starting point | reference rows colsheight width |
| ROW | Get the row number of a reference | reference |
| ROWS | How to use the Excel ROWS function to Get the number of rows in an array or reference. | array |
| TRANSPOSE | Flip the orientation of a range of cells | array |
| VLOOKUP | Lookup a value in a table by matching on the first column | value table col_indexrange_lookup |
Math
| Function | Purpose | Param,Optional |
|---|---|---|
| ABS | Find the absolute value of a number | number |
| CEILING | Round a number up to the nearest specified multiple | number multiple |
| COS | Get the cosine of an angle | number |
| DEGREES | Converts an angle into degrees | angle |
| EVEN | Round a number up to the next even integer | number |
| EXP | Find the value of e raised to the power of a number | number |
| FACT | Find the factorial of a number | number |
| FLOOR | Round a number down to the nearest specified multiple | number multiple |
| GCD | Get the greatest common divisor of two or more numbers | number1number2 … |
| INT | Get the integer part of a decimal by rounding down | number |
| LCM | Get the least common multiple or two or more numbers | number1number2 … |
| LOG10 | Get the base-10 logarithm of a number | number |
| MOD | Get the remainder from division | number divisor |
| MROUND | Round a number to the nearest specified multiple | number multiple |
| ODD | Round a number up to the next odd integer | number |
| PI | Get the value of π | |
| RADIANS | Converts an angle into radians | angle |
| RAND | Get a random number between 0 and 1 | |
| RANDBETWEEN | Get a random integer between two values | bottom top |
| ROUND | Round a number to a given number of digits | number num_digits |
| ROUNDDOWN | Round a number down to a given number of digits | number num_digits |
| ROUNDUP | Round a number up to a given number of digits | number number_digits |
| SIGN | Get the sign of a number. | number |
| SIN | Get the sine of an angle | number |
| SQRT | Find the positive square root of a number | number |
| SUBTOTAL | Get a subtotal in a list or database | function_num ref1ref2 … |
| SUM | Add numbers together | number1number2 number3 … |
| SUMIF | Sum numbers in a range that meet supplied criteria | range criteriasum_range |
| SUMPRODUCT | Multiply, then sum arrays | array1array2 … |
| TAN | Get the tangent of an angle. | number |
Statistical
| Function | Purpose | Param,Optional |
|---|---|---|
| AVERAGE | Get the average of a group of numbers | number1number2 … |
| AVERAGEA | Get the average of a group of numbers and text | value1value2 … |
| AVERAGEIF | Get the average of numbers that meet criteria | range criteriaaverage_range |
| COUNT | Count numbers | value1value2 … |
| COUNTA | Count the number of non-blank cells | value1value2 … |
| COUNTBLANK | excel-countblank-function | range |
| COUNTIF | Count cells that match criteria | range criteria |
| COUNTIFS | Count cells that match multiple criteria | range1 criteria1range2 criteria2 … |
| FREQUENCY | Get the frequency of values in a data set | data_array bins_array |
| LARGE | Get the nth largest value | array n |
| MEDIAN | Get the median of a group of numbers | number1numer2 … |
| MIN | Get the smallest value. | array |
| MODE | Get the mode of a group of numbers | number1number2 … |
| RANK | Rank a number against a range of numbers | number arrayorder |
| SMALL | Get the nth smallest value | array n |
| STDEV | Get the standard deviation in a sample | number1number2 … |
| STDEV.P | Get standard deviation of population | number1number2 … |
| STDEV.S | Get the standard deviation in a sample | number1number2 … |
| STDEVP | Get standard deviation of population | number1number2 … |
Text
| Function | Purpose | Param,Optional |
|---|---|---|
| CHAR | Get a character from a number | number |
| CLEAN | Strip non-printable characters from text | text |
| CODE | Get the code for a character | text |
| CONCATENATE | Join text together | text1 text2text3 … |
| DOLLAR | Convert a number to text in currency format | number decimals |
| EXACT | Compare two text strings | text1 text2 |
| FIND | Get the location of text in a string | |
| LEFT | Extract text from the left of a string | |
| LEN | Get the length of text. | |
| LOWER | Convert text to lower case | |
| MID | Extract text from inside a string | |
| PROPER | Capitalize the first letter in each word | |
| REPLACE | Replace text based on location | |
| REPT | Repeat text as specified | |
| RIGHT | Extract text from the right of a string | |
| SEARCH | Get the location of text in a string | |
| SUBSTITUTE | Replace text based on content | |
| TEXT | Convert a number to text in a number format | |
| TRIM | Remove extra spaces from text | |
| UPPER | Convert text to upper case | textnum_chars |
| VALUE | Convert text to a number | text |