Excel Functions

Excel Functions List

Below you will find a searchable list of ~200 Excel Functions. Next to each function, you’ll see a description of the function along with the function’s syntax.

If you’d like to learn more about a function, simply click it’s row and go to the function page. Each function page contains detailed instructions on how to use the function, including multiple examples.

We also recommend checking out our Formula Examples Page. This page contains 100 (and growing rapidly) formula examples for specific use-cases (ex. count all cells with positive numbers)

FunctionDescriptionSyntax
New Functions
UNIQUEReturns a list of unique values in a list or rangeUNIQUE(array, [by_col], [exactly_once])
XLOOKUPReplaces VLOOKUP, HLOOKUP, and INDEX / MATCHXLOOKUP(lookup_value,lookup_array,return_array,[match_mode],[search_mode])
Logicalyes
ANDChecks whether all conditions are met. TRUE/FALSEAND(logical1,logical2)and function example download
IFIf condition is met, do something, if not, do something else.IF(logical_test,value_if_true,value_if_false)if function example download
IFERRORIf result is an error then do something else.IFERROR(VALUE,value_if_error)
NOTChanges TRUE to FALSE and FALSE to TRUE.NOT(logical)not function example download
ORChecks whether any conditions are met. TRUE/FALSEOR(logical1,logical2)or function example download
XORChecks whether one and only one condition is met. TRUE/FALSEXOR(logical1,logical2)xor function example download
Lookup & Referenceyes
FALSEThe logical value: FALSE.FALSE
TRUEThe logical value: TRUE.TRUE
ADDRESSReturns a cell address as text.ADDRESS(row_num,column_num,abs_num,C1,sheet_text)address function example download
AREASReturns the number of areas in a reference.AREAS(reference)
CHOOSEChooses a value from a list based on it's position number.CHOOSE(index_num,value1,value2)
COLUMNReturns the column number of a cell reference.COLUMN(reference)column function example download
COLUMNSReturns the number of columns in an array.COLUMNS(array)columns function example download
HLOOKUPLookup a value in the first row and return a value.HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)hlookup function example download
HYPERLINKCreates a clickable link.HYPERLINK(link_location,friendly_name)hyperlink function example download
INDEXReturns a value based on it's column and row numbers.INDEX(array,row_num,column_num)index function example download
INDIRECTCreates a cell reference from text.INDIRECT(ref_text,C1)indirect function example download
LOOKUPLooks up values either horizontally or vertically.LOOKUP(lookup_value,lookup_vector,result_vector)
MATCHSearches for a value in a list and returns its position.MATCH(lookup_value,lookup_array,match_type)match function example download
OFFSETCreates a reference offset from a starting point.OFFSET(reference,rows,cols,height,width)offset function example download
ROWReturns the row number of a cell reference.ROW(reference)row function example download
ROWSReturns the number of rows in an array.ROWS(array)rows function example download
TRANSPOSEFlips the oriention of a range of cells.TRANSPOSE(array)
VLOOKUPLookup a value in the first column and return a value.VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)vlookup function example download
Date & Timeyes
DATEReturns a date from year, month, and day.DATE(year,month,day)date function example download
DATEDIFNumber of days, months or years between two dates.DATEDIF
DATEVALUEConverts a date stored as text into a valid dateDATEVALUE(date_text)datevalue function example download
DAYReturns the day as a number (1-31).DAY(serial_number)day function example download
DAYSReturns the number of days between two dates.DAYS(end_date,start_date)days function example download
DAYS360Returns days between 2 dates in a 360 day year.DAYS360(start_date,end_date,method)days360 function example download
EDATEReturns a date, n months away from a start date.EDATE(start_date,months)edate function example download
EOMONTHReturns the last day of the month, n months away date.EOMONTH(start_date,months)eomonth function example download
HOURReturns the hour as a number (0-23).HOUR(serial_number)hour function example download
MINUTEReturns the minute as a number (0-59).MINUTE(serial_number)minute function example download
MONTHReturns the month as a number (1-12).MONTH(serial_number)month function example download
NETWORKDAYSNumber of working days between 2 dates.NETWORKDAYS(start_date,end_date,holidays)networkdays function example download
NETWORKDAYS.INTLWorking days between 2 dates, custom weekends. NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)
NOWReturns the current date and time.NOW()
SECONDReturns the second as a number (0-59)SECOND(serial_number)second function example download
TIMEReturns the time from a hour, minute, and second.TIME(hour,minute,second)time function example download
TIMEVALUEConverts a time stored as text into a valid time.TIMEVALUE(time_text)timevalue function example download
TODAYReturns the current date.TODAY()today function example download
WEEKDAYReturns the day of the week as a number (1-7).WEEKDAY(serial_number,return_type)weekday function example download
WEEKNUMReturns the week number in a year (1-52).WEEKNUM(serial_number,return_type)weeknum function example download
WORKDAYThe date n working days from a date.WORKDAY(start_date,days,holidays)workday function example download
WORKDAY.INTLThe date n working days from a date, custom weekends.WORKDAY.INTL(start_date,days,weekend,holidays)
YEARReturns the year.YEAR(serial_number)year function example download
YEARFRACReturns the fraction of a year between 2 dates.YEARFRAC(start_date,end_date,basis)yearfrac function example download
Engineeringyes
CONVERTConvert number from one unit to another.CONVERT(number,from_unit,to_unit)convert function example download
Financialyes
FVCalculates the future value.FV(rate,nper,pmt,pv,type)fv function example download
PVCalculates the present value.PV(rate,nper,pmt,fv,type)pv function example download
NPERCalculates the total number of payment periods.NPER(rate,pmt,pv,fv,type)nper function example download
PMTCalculates the payment amount.PMT(rate,nper,pv,fv,type)pmt function example download
RATECalculates the interest Rate.RATE(nper,pmt,pv,fv,type,guess)rate function example download
NPVCalculates the net present value.NPV(rate,value1,value2)npv function example download
IRRThe internal rate of return for a set of periodic CFs.IRR(values,guess)irr function example download
XIRRThe internal rate of return for a set of non-periodic CFs.XIRR(values,dates,guess)xirr function example download
PRICECalculates the price of a bond.PRICE(settlement,maturity,rate,yld,redemption,FREQUENCY,basis)price function example download
YIELDCalculates the bond yield.YIELD(settlement,maturity,rate,pr,redemption,FREQUENCY,basis)yield function example download
INTRATEThe interest rate of a fully invested security.INTRATE(settlement,maturity,investment,redemption,basis)
Informationyes
CELLReturns information about a cell.CELL(info_type,reference)cell function example download
ERROR.TYPEReturns a value representing the cell error.ERROR.TYPE(error_val)
ISBLANKTest if cell is blank. TRUE/FALSEISBLANK(VALUE)isblank function example download
ISERRTest if cell value is an error, ignores #N/A. TRUE/FALSEISERR(VALUE)iserr function example download
ISERRORTest if cell value is an error. TRUE/FALSEISERROR(VALUE)iserror function example download
ISEVENTest if cell value is even. TRUE/FALSEISEVEN(number)iseven function example download
ISFORMULATest if cell is a formula. TRUE/FALSEISFORMULA(reference)isformula function example download
ISLOGICALTest if cell is logical (TRUE or FALSE). TRUE/FALSEISLOGICAL(VALUE)islogical function example download
ISNATest if cell value is #N/A. TRUE/FALSEISNA(VALUE)isna function example download
ISNONTEXTTest if cell is not text (blank cells are not text). TRUE/FALSEISNONTEXT(VALUE)isnontext function example download
ISNUMBERTest if cell is a number. TRUE/FALSEISNUMBER(VALUE)isnumber function example download
ISODDTest if cell value is odd. TRUE/FALSEISODD(number)
ISREFTest if cell value is a reference. TRUE/FALSEISREF(VALUE)isref function example download
ISTEXTTest if cell is text. TRUE/FALSEISTEXT(VALUE)istext function example download
NConverts a value to a number.N(VALUE)
NAReturns the error: #N/A.NA()
TYPEReturns the type of value in a cell.TYPE(VALUE)
Mathyes
ABSCalculates the absolute value of a number.ABS(number)abs function example download
AGGREGATEDefine and perform calculations for a database or a list.AGGREGATE(function_num,options,array,k)
CEILINGRounds a number up, to the nearest specified multiple.CEILING(number,significance)ceiling function example download
COSReturns the cosine of an angle.COS(number)cos function example download
DEGREESConverts radians to degrees.DEGREES(angle)degrees function example download
DSUMSums database records that meet certain criteria.DSUM(database,field,criteria)dsum function example download
EVENRounds to the nearest even integer.EVEN(number)
EXPCalculates the exponential value for a given number.EXP(number)exp function example download
FACTReturns the factorial.FACT(number)
FLOORRounds a number down, to the nearest specified multiple.FLOOR(number,significance)floor function example download
GCDReturns the greatest common divisor.GCD(number1,number2)
INTRounds a number down to the nearest integer.INT(number)
LCMReturns the least common multiple.LCM(number1,number2)
LNReturns the natural logarithm of a number.LN(number)ln function example download
LOGReturns the logarithm of a number to a specified base.LOG(number,base)log function example download
LOG10Returns the base-10 logarithm of a number.LOG10(number)log10 function example download
MODReturns the remainder after dividing.MOD(number,divisor)mod function example download
MROUNDRounds a number to a specified multiple.MROUND(number,multiple)mround function example download
ODDRounds to the nearest odd integer.ODD(number)
PIThe value of PI.PI()pi function example download
POWERCalculates a number raised to a power.POWER(number,power)power function example download
PRODUCTMultiplies an array of numbers.PRODUCT(number1,number2)product function example download
QUOTIENTReturns the integer result of division.QUOTIENT(numerator,denominator)quotient function example download
RADIANSConverts an angle into radians.RADIANS(angle)radians function example download
RANDCalculates a random number between 0 and 1.RAND()rand function example download
RANDBETWEENCalculates a random number between two numbers.RANDBETWEEN(bottom,top)randbetween function example download
ROUNDRounds a number to a specified number of digits.ROUND(number,num_digits)round function example download
ROUNDDOWNRounds a number down (towards zero).ROUNDDOWN(number,num_digits)rounddown function example download
ROUNDUPRounds a number up (away from zero).ROUNDUP(number,num_digits)roundup function example download
SIGNReturns the sign of a number.SIGN(number)
SINReturns the sine of an angle.SIN(number)sin function example download
SQRTCalculates the square root of a number.SQRT(number)sqrt function example download
SUBTOTALReturns a summary statistic for a series of data.SUBTOTAL(function_num,REH1)subtotal function example download
SUMAdds numbers together.SUM(number1,number2)sum function example download
SUMIFSums numbers that meet a criteria.SUMIF(range,criteria,sum_range)sumif function example download
SUMIFSSums numbers that meet multiple criteria.SUMIFS(sum_range,criteria_range,criteria)
SUMPRODUCTMultiplies arrays of numbers and sums the resultant array.SUMPRODUCT(array1,array2,array3)sumproduct function example download
TANReturns the tangent of an angle.TAN(number)tan function example download
TRUNCTruncates a number to a specific number of digits.TRUNC(number,num_digits)
Statsyes
AVERAGEAverages numbers.AVERAGE(number1,number2)average function example download
AVERAGEAAverages numbers. Includes text & FALSE =0, TRUE =1.AVERAGEA(value1,value2)averagea function example download
AVERAGEIFAverages numbers that meet a criteria.AVERAGEIF(range,criteria,average_range)averageif function example download
AVERAGEIFSAverages numbers that meet multiple criteria.AVERAGEIFS(average_range,criteria_range,criteria)
CORRELCalculates the correlation of two series.CORREL(array1,array2)correl function example download
COUNTCounts cells that contain a number.COUNT(value1,value2)count function example download
COUNTACount cells that are non-blank.COUNTA(value1,value2)counta function example download
COUNTBLANKCounts cells that are blank.COUNTBLANK(range)countblank function example download
COUNTIFCounts cells that meet a criteria.COUNTIF(range,criteria)countif function example download
COUNTIFSCounts cells that meet multiple criteria.COUNTIFS(criteria_range,criteria)
FORECASTPredict future y-values from linear trend line.FORECAST(x,known_y's,known_x's)forecast function example download
FREQUENCYCounts values that fall within specified ranges.FREQUENCY(data_array,bins_array)frequency function example download
GROWTHCalculates Y values based on exponential growth.GROWTH(known_ys,known_x,new_x,const)growth function example download
INTERCEPTCalculates the Y intercept for a best-fit line.INTERCEPT(known_ys,known_xs)intercept function example download
LARGEReturns the kth largest value.LARGE(array,k)large function example download
LINESTReturns statistics about a trendline.LINEST(known_ys,known_xs,const,stats)linest function example download
MAXReturns the largest number.MAX(number1,number2)max function example download
MEDIANReturns the median number.MEDIAN(number1,number2)median function example download
MINReturns the smallest number.MIN(number1,number2)min function example download
MODEReturns the most common number.MODE(number1,number2)mode function example download
PERCENTILEReturns the kth percentile.PERCENTILE(array,k)percentile function example download
PERCENTILE.INCReturns the kth percentile. Where k is inclusive.PERCENTILE.INC(array,k)
PERCENTILE.EXCReturns the kth percentile. Where k is exclusive.PERCENTILE.EXC(array,k)
QUARTILEReturns the specified quartile value.QUARTILE(array,quart)quartile function example download
QUARTILE.INCReturns the specified quartile value. Inclusive.QUARTILE.INC(array,quart)
QUARTILE.EXCReturns the specified quartile value. Exclusive.QUARTILE.EXC(array,quart)
RANKRank of a number within a series.RANK(number,ref,order)rank function example download
RANK.AVGRank of a number within a series. Averages.RANK.AVG(number,ref,order)
RANK.EQRank of a number within a series. Top Rank.RANK.EQ(number,ref,order)
SLOPECalculates the slope from linear regression.SLOPE(known_ys,known_xs)slope function example download
SMALLReturns the kth smallest value.SMALL(array,k)small function example download
STDEVCalculates the standard deviation.STDEV(number1,number2)
STDEV.PCalculates the SD of an entire population.STDEV.P(number1,number2)
STDEV.SCalculates the SD of a sample.STDEV.S(number1,number2)
STDEVPCalculates the SD of an entire populationSTDEVP(number1,number2)
TRENDCalculates Y values based on a trendline.TREND(known_ys,known_xs,new_xs,const)trend function example download
Textyes
CHARReturns a character specified by a code.CHAR(number)char function example download
CLEANRemoves all non-printable characters.CLEAN(text)clean function example download
CODEReturns the numeric code for a character.CODE(text)code function example download
CONCATENATECombines text together.CONCATENATE(text1,text2)concatenate function example download
DOLLARConverts a number to text in currency format.DOLLAR(number,decimals)
EXACTTest if cells are exactly equal. Case-sensitive. TRUE/FALSEEXACT(text1,text2)exact function example download
FINDLocates position of text within a cell.Case-sensitive.FIND(find_text,within_text,start_num)find function example download
LEFTTruncates text a number of characters from the left.LEFT(text,num_chars)left function example download
LENCounts number of characters in text.LEN(text)len function example download
LOWERConverts text to lower case.LOWER(text)lower function example download
MIDExtracts text from the middle of a cell.MID(text,start_num,num_chars)mid function example download
PROPERConverts text to proper case.PROPER(text)proper function example download
REPLACEReplaces text based on it's location.REPLACE(old_text,start_num,num_chars,new_text)
REPTRepeats text a number of times.REPT(text,number_times)rept function example download
RIGHTTruncates text a number of characters from the right.RIGHT(text,num_chars)right function example download
SEARCHLocates position of text within a cell.Not Case-sensitive.SEARCH(find_text,within_text,start_num)search function example download
SUBSTITUTEFinds and replaces text. Case-sensitive.SUBSTITUTE(text,old_text,new_text,instance_num)substitute function example download
TEXTConverts a value into text with a specific number format.TEXT(VALUE,format_text)text function example download
TRIMRemoves all extra spaces from text.TRIM(text)trim function example download
UPPERConverts text to upper case.UPPER(text)upper function example download
VALUEConverts a number stored as text into a number.VALUE(text)value function example download

Excel Function FAQs

What are functions in Excel?

In Excel, functions can be called to easily perform complex operations. For example the AVERAGE Function will average an array of numbers: =AVERAGE(A1:A10).

How do you use Functions in Excel?

To use functions in Excel, select a cell, and type "=" followed by the function name and "(". For example, type "=IF(" and you'll see the syntax appear for the IF Function.

You can also press the small fx button next to the formula bar. This will open up the Formula Wizard.

How many Excel functions are there?

There are approximately 500 Excel Functions. However, even Excel experts only use a fraction of the total number of Excel functions.

What is syntax in Excel?

Syntax in Excel refers to the required inputs for Excel Functions. For example, the VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).