# 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 |