Excel Functions List
Search for function or browse list below...
AND
- returns TRUE if all arguments are TRUE
AVERAGE
- returns the average of its arguments
AVERAGEIF
- returns the average of all the cells in a range that meet a given criteria
AVERAGEIFS
- returns the average of all cells that meet multiple criteria
COUNT
- counts how many numbers are in the list of arguments
COUNTA
- counts how many values are in the list of arguments
COUNTBLANK
- counts the number of blank cells within a range
COUNTIF
- counts the number of cells within a range that meet the given criteria
COUNTIFS
- counts the number of cells within a range that meet multiple criteria
DATE
- returns the serial number of a particular date
DATEDIF
- calculates the number of days, months, or years between two dates
DATEVALUE
- converts a date in the form of text to a serial number
DAY
- converts a serial number to a day of the month
DAYS
- returns the number of days between two dates
FALSE
- returns the logical value FALSE
FV
- returns the future value of an investment
IF
- specifies a logical test to perform
IFERROR
- returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula
IFNA
- returns the value you specify if the expression resolves to #N/A; otherwise returns the result of the expression
IFS
- checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
ISBLANK
- returns TRUE if the value is blank
ISERR
- returns TRUE if the value is any error value except #N/A
ISERROR
- returns TRUE if the value is any error value
LEFT, LEFTB
- returns the leftmost characters from a text value
LOOKUP
- looks up values in a vector or array
LOWER
- converts text to lowercase
MAX
- returns the maximum values in a list of arguments
MAXIFS
- returns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN
- returns the median of the given numbers
MIN
- returns the minimum value in a list of arguments
MINIFS
- returns the minimum value among cells specified by a given set of conditions or criteria
MONTH
- converts a serial number to a month
NETWORKDAYS
- returns the number of whole workdays between two dates
NOW
- returns the serial number of the current date and time
RAND
- returns a random number between 0 and 1
RIGHT, RIGHTB
- returns the rightmost characters from a text value
ROUND
- rounds a number to a specified number of digits
ROUNDDOWN
- rounds a number down, toward zero
ROUNDUP
- rounds a number up, away from zero
SECOND
- converts a serial number to a second
SUM
- adds its arguments together
SUMIF
- adds the cells specified by a given range
SUMIFS
- adds the cells in a range that meet multiple criteria
TEXT
- formats a number and converts it to text
TIME
- returns the serial number of a particular time
TODAY
- returns the serial number of today's date
TRIM
- removes spaces from text
TRUE
- returns the logical value TRUE
UPPER
- converts text to uppercase
VALUE
- converts a text argument to a number
VLOOKUP
- looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAY
- converts a serial number to a day of the week
WEEKNUM
- converts a serial number representing where the week falls numerically with a year
YEAR
- converts a serial number to a year
- returns TRUE if all arguments are TRUE
AVERAGE
- returns the average of its arguments
AVERAGEIF
- returns the average of all the cells in a range that meet a given criteria
AVERAGEIFS
- returns the average of all cells that meet multiple criteria
COUNT
- counts how many numbers are in the list of arguments
COUNTA
- counts how many values are in the list of arguments
COUNTBLANK
- counts the number of blank cells within a range
COUNTIF
- counts the number of cells within a range that meet the given criteria
COUNTIFS
- counts the number of cells within a range that meet multiple criteria
DATE
- returns the serial number of a particular date
DATEDIF
- calculates the number of days, months, or years between two dates
DATEVALUE
- converts a date in the form of text to a serial number
DAY
- converts a serial number to a day of the month
DAYS
- returns the number of days between two dates
FALSE
- returns the logical value FALSE
FV
- returns the future value of an investment
IF
- specifies a logical test to perform
IFERROR
- returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula
IFNA
- returns the value you specify if the expression resolves to #N/A; otherwise returns the result of the expression
IFS
- checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
ISBLANK
- returns TRUE if the value is blank
ISERR
- returns TRUE if the value is any error value except #N/A
ISERROR
- returns TRUE if the value is any error value
LEFT, LEFTB
- returns the leftmost characters from a text value
LOOKUP
- looks up values in a vector or array
LOWER
- converts text to lowercase
MAX
- returns the maximum values in a list of arguments
MAXIFS
- returns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN
- returns the median of the given numbers
MIN
- returns the minimum value in a list of arguments
MINIFS
- returns the minimum value among cells specified by a given set of conditions or criteria
MONTH
- converts a serial number to a month
NETWORKDAYS
- returns the number of whole workdays between two dates
NOW
- returns the serial number of the current date and time
RAND
- returns a random number between 0 and 1
RIGHT, RIGHTB
- returns the rightmost characters from a text value
ROUND
- rounds a number to a specified number of digits
ROUNDDOWN
- rounds a number down, toward zero
ROUNDUP
- rounds a number up, away from zero
SECOND
- converts a serial number to a second
SUM
- adds its arguments together
SUMIF
- adds the cells specified by a given range
SUMIFS
- adds the cells in a range that meet multiple criteria
TEXT
- formats a number and converts it to text
TIME
- returns the serial number of a particular time
TODAY
- returns the serial number of today's date
TRIM
- removes spaces from text
TRUE
- returns the logical value TRUE
UPPER
- converts text to uppercase
VALUE
- converts a text argument to a number
VLOOKUP
- looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAY
- converts a serial number to a day of the week
WEEKNUM
- converts a serial number representing where the week falls numerically with a year
YEAR
- converts a serial number to a year