Complete List of Excel Formulas (Without NOW)
SUM
Adds all the numbers in a range of cells.
=SUM(A1:A10)IF
Returns one value if a condition is TRUE and another if FALSE.
=IF(A1>10, "High", "Low")VLOOKUP
Looks for a value in the first column of a range and returns a value in the same row from another column.
=VLOOKUP(1001, A2:D10, 3, FALSE)CONCATENATE
Joins several text strings into one string.
=CONCATENATE(A1, " ", B1)COUNTIF
Counts the number of cells that meet a condition.
=COUNTIF(A1:A10, ">5")LEFT
Returns the first character(s) in a text string, based on the number of characters you specify.
=LEFT(A1, 4)RIGHT
Returns the last character(s) in a text string, based on the number of characters you specify.
=RIGHT(A1, 3)MATCH
Returns the relative position of an item in a range that matches a specified value.
=MATCH(50, A1:A10, 0)INDEX
Returns the value of a cell in a table based on the row and column number.
=INDEX(A1:C10, 2, 3)AVERAGE
Returns the average (arithmetic mean) of the numbers provided.
=AVERAGE(A1:A10)LEN
Returns the number of characters in a text string.
=LEN(A1)TRIM
Removes all spaces from text except for single spaces between words.
=TRIM(A1)TODAY
Returns the current date.
=TODAY()PMT
Calculates the payment for a loan based on constant payments and interest rate.
=PMT(5%/12, 60, -10000)ROUND
Rounds a number to a specified number of digits.
=ROUND(A1, 2)PROPER
Capitalizes the first letter of each word in a text string.
=PROPER(A1)IFERROR
Returns a value you specify if a formula results in an error; otherwise, returns the result of the formula.
=IFERROR(A1/B1, "Error")
