Complete List of Excel Functions with Formulas and Examples
ABS
Description: Returns the absolute value of a number.
Example: ABS(-10)
CEILING
Description: Rounds a number up to the nearest multiple of significance.
Example: CEILING(4.3, 1)
FLOOR
Description: Rounds a number down to the nearest multiple of significance.
Example: FLOOR(4.3, 1)
ROUND
Description: Rounds a number to a specified number of digits.
Example: ROUND(3.14159, 2)
INT
Description: Rounds a number down to the nearest integer.
Example: INT(8.9)
MOD
Description: Returns the remainder after a number is divided by a divisor.
Example: MOD(10, 3)
IF
Description: Performs a logical test and returns one value for a TRUE result, and another for FALSE.
Example: IF(A1>10, 'Yes', 'No')
AND
Description: Returns TRUE if all its arguments are TRUE.
Complete List of Excel Functions with Formulas and Examples
Example: AND(TRUE, FALSE)
OR
Description: Returns TRUE if any argument is TRUE.
Example: OR(TRUE, FALSE)
NOT
Description: Reverses the logic of its argument.
Example: NOT(TRUE)
LEFT
Description: Returns the first character(s) in a text string.
Example: LEFT('Excel', 2)
RIGHT
Description: Returns the last character(s) in a text string.
Example: RIGHT('Excel', 2)
MID
Description: Returns characters from the middle of a text string.
Example: MID('Excel', 2, 3)
LEN
Description: Returns the length of a text string.
Example: LEN('Excel')
TRIM
Description: Removes extra spaces from text.
Example: TRIM(' Excel ')
Complete List of Excel Functions with Formulas and Examples
UPPER
Description: Converts text to uppercase.
Example: UPPER('excel')
LOWER
Description: Converts text to lowercase.
Example: LOWER('EXCEL')
PROPER
Description: Capitalizes the first letter of each word.
Example: PROPER('excel formula')
CONCAT
Description: Joins two or more text strings.
Example: CONCAT('Hello', ' ', 'World')
TEXT
Description: Formats a number and converts it to text.
Example: TEXT(1234.5, '$#,##0.00')
VLOOKUP
Description: Searches for a value in the first column and returns a value in the same row.
Example: VLOOKUP(1001, A2:C10, 2, FALSE)
HLOOKUP
Description: Searches for a value in the first row and returns a value in the same column.
Example: HLOOKUP('Q1', A1:D4, 2, FALSE)
INDEX
Description: Returns the value of a cell at the intersection of a row and column.
Complete List of Excel Functions with Formulas and Examples
Example: INDEX(A1:C3, 2, 3)
MATCH
Description: Returns the relative position of a value in a range.
Example: MATCH(25, A1:A10, 0)
CHOOSE
Description: Chooses a value from a list based on an index number.
Example: CHOOSE(2, 'Red', 'Blue', 'Green')
LOOKUP
Description: Looks up a value from a one-row or one-column range.
Example: LOOKUP(4, A1:A5, B1:B5)
XLOOKUP
Description: Returns a value based on a lookup value from a range.
Example: XLOOKUP(105, A2:A6, B2:B6)
TODAY
Description: Returns the current date.
Example: TODAY()
NOW
Description: Returns the current date and time.
Example: NOW()
DATE
Description: Returns the number that represents the date.
Example: DATE(2025, 7, 11)
Complete List of Excel Functions with Formulas and Examples
DAY
Description: Returns the day of a date.
Example: DAY(TODAY())
MONTH
Description: Returns the month of a date.
Example: MONTH(TODAY())
YEAR
Description: Returns the year of a date.
Example: YEAR(TODAY())
EDATE
Description: Returns the date that is the specified number of months before or after a date.
Example: EDATE(TODAY(), 1)
DATEDIF
Description: Calculates the difference between two dates.
Example: DATEDIF(A1, A2, 'D')
EOMONTH
Description: Returns the last day of the month.
Example: EOMONTH(TODAY(), 1)
PMT
Description: Calculates the payment for a loan.
Example: PMT(0.05/12, 60, -10000)
FV
Description: Returns the future value of an investment.
Complete List of Excel Functions with Formulas and Examples
Example: FV(0.05/12, 60, -200, -5000)
PV
Description: Returns the present value of an investment.
Example: PV(0.05/12, 60, -200)
NPV
Description: Calculates the net present value of an investment.
Example: NPV(0.1, A2:A6)
RATE
Description: Returns the interest rate per period of a loan or investment.
Example: RATE(60, -200, 10000)
AVERAGE
Description: Returns the average of arguments.
Example: AVERAGE(A1:A10)
MEDIAN
Description: Returns the median of the numbers.
Example: MEDIAN(A1:A10)
MODE
Description: Returns the most frequently occurring value.
Example: MODE(A1:A10)
COUNT
Description: Counts numeric values in a range.
Example: COUNT(A1:A10)
Complete List of Excel Functions with Formulas and Examples
COUNTA
Description: Counts non-blank cells.
Example: COUNTA(A1:A10)
COUNTIF
Description: Counts cells that meet a criterion.
Example: COUNTIF(A1:A10, '>10')
COUNTIFS
Description: Counts cells that meet multiple criteria.
Example: COUNTIFS(A1:A10, '>10', B1:B10, '<5')
MAX
Description: Returns the largest value.
Example: MAX(A1:A10)
MIN
Description: Returns the smallest value.
Example: MIN(A1:A10)
ISBLANK
Description: Checks whether a cell is empty.
Example: ISBLANK(A1)
ISNUMBER
Description: Checks whether a value is a number.
Example: ISNUMBER(A1)
ISTEXT
Description: Checks whether a value is text.
Complete List of Excel Functions with Formulas and Examples
Example: ISTEXT(A1)
ISERROR
Description: Checks for any error.
Example: ISERROR(A1)
IFERROR
Description: Returns a value if theres an error.
Example: IFERROR(A1/B1, 'Error')
FILTER
Description: Filters a range based on criteria.
Example: FILTER(A2:A10, B2:B10=1)
SORT
Description: Sorts the contents of a range.
Example: SORT(A2:A10)
UNIQUE
Description: Returns unique values from a range.
Example: UNIQUE(A2:A10)
SEQUENCE
Description: Generates a list of sequential numbers.
Example: SEQUENCE(5)
RANDARRAY
Description: Returns an array of random numbers.
Example: RANDARRAY(5, 1)
