** excel functions** Applies To: Excel 2016 , Excel 2013 , Excel 2010 , Excel 2007 , Excel 2016 for Mac , Excel for Mac 2011 , More…

Click a letter to go to functions that start with it. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

NOTE: Version markers indicate the version of Excel a function was introduced. These functions aren’t available in earlier versions.

IMPORTANT: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

**Web : excel**

Function | Purpose | Param,Optional |
---|---|---|

DATE | Create a valid date from year, month, and day | yearmonthday |

DATEDIF | Get days, months, or years between two dates | start_dateend_dateunit |

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

DAYS360 | Get days between 2 dates in a 360-day year | start_dateend_datemethod |

EDATE | Get the same date in future or past months | start_datemonths |

EOMONTH | Get the last day of the month in future or past months | start_datemonths |

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

NETWORKDAYS.INTL | Get work days between two dates | start_dateend_dateweekendholidays |

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

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

WORKDAY.INTL | Get date and working days in future or past | start_datedaysweekendholidays |

YEAR | Get the year from a date | date |

YEARFRAC | Get the fraction of a year between two dates | start_dateend_datebasis |

### Engineering

Function | Purpose | Param,Optional |
---|---|---|

CONVERT | Convert measurement units | numberfrom_unitto_unit |

### Financial

Function | Purpose | Param,Optional |
---|---|---|

FV | Get the future value of an investment | ratenperpmtpvtype |

NPER | Get the number of periods for an investment | ratepmtpvfvtype |

PMT | Get the periodic payment for a loan | ratepmtpvfvtype |

PV | Get the present value of an investment | ratenperpmtfvtype |

RATE | Get the interest rate per period of an annuity | nperpmtpvfvtypeguess |

### Information

Filter:

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

Filter:

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

IFERROR | Trap and handle errors | valuevalue_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

Filter:

Function | Purpose | Param,Optional |
---|---|---|

ADDRESS | Create a cell address from a given row and column | row_numcol_numabs_numa1sheet |

AREAS | Get the number of areas in a reference. | reference |

CHOOSE | Get a value from a list based on position | index_numvalue1value2… |

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

HYPERLINK | Create a clickable link. | link_locationfriendly_name |

INDEX | Get a value in a list or table based on location | arrayrow_numcol_numarea_num |

INDIRECT | Create a reference from text | ref_texta1 |

LOOKUP | Look up a value in a one-column range | lookup_valuelookup_vectorresult_vector |

MATCH | Get the position of an item in an array | lookup_valuelookup_arraymatch_type |

OFFSET | Create a reference offset from given starting point | referencerowscolsheightwidth |

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

### Math

Filter:

Function | Purpose | Param,Optional |
---|---|---|

ABS | Find the absolute value of a number | number |

CEILING | Round a number up to the nearest specified multiple | numbermultiple |

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

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

MROUND | Round a number to the nearest specified multiple | numbermultiple |

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

ROUND | Round a number to a given number of digits | numbernum_digits |

ROUNDDOWN | Round a number down to a given number of digits | numbernum_digits |

ROUNDUP | Round a number up to a given number of digits | numbernumber_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_numref1ref2… |

SUM | Add numbers together | number1number2number3… |

SUMIF | Sum numbers in a range that meet supplied criteria | rangecriteriasum_range |

SUMPRODUCT | Multiply, then sum arrays | array1array2… |

TAN | Get the tangent of an angle. | number |

### Statistical

Filter:

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 | rangecriteriaaverage_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 | rangecriteria |

COUNTIFS | Count cells that match multiple criteria | range1criteria1range2criteria2… |

FREQUENCY | Get the frequency of values in a data set | data_arraybins_array |

LARGE | Get the nth largest value | arrayn |

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

SMALL | Get the nth smallest value | arrayn |

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

Filter:

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 | text1text2text3… |

DOLLAR | Convert a number to text in currency format | numberdecimals |

EXACT | Compare two text strings | text1text2 |

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 |

Advertisements