Excel Functions

Discover how functions in Excel help you save time.

Date and time

FunctionPurposeParam,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

FunctionPurposeParam,Optional
CONVERT Convert measurement units number from_unit to_unit

Financial

FunctionPurposeParam,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

FunctionPurposeParam,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

FunctionPurposeParam,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

FunctionPurposeParam,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

FunctionPurposeParam,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

FunctionPurposeParam,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

FunctionPurposeParam,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