Basic Excel Formulas

Basic Excel Formulas

Formula	Description
SUM(A1:A10)	Adds up all the numbers in a range of cells.
AVERAGE(A1:A10)	Calculates the average of a range of cells.
COUNT(A1:A10)	Counts the number of cells with numbers in a range.
IF(A1>10, "Yes", "No")	Returns one value if a condition is TRUE, and another if FALSE.
VLOOKUP(B2, A1:B10, 2, FALSE)	Searches for a value in the leftmost column of a range and returns a value in the same row.
HLOOKUP(B2, A1:E5, 3, FALSE)	Looks for a value in the top row of a range and returns a value in the same column.
INDEX(A1:C10, 3, 2)	Returns the value of a cell in a specific row and column within a range.
MATCH(B1, A1:A10, 0)	Returns the relative position of an item in a range.
CONCATENATE(A1, " ", B1)	Joins two or more text strings into one string.
TRIM(A1)	Removes extra spaces from text, except single spaces between words.
LEFT(A1, 5)	Returns the first N characters from a text string.
RIGHT(A1, 5)	Returns the last N characters from a text string.
MID(A1, 3, 5)	Returns a specific number of characters from a text string, starting at a given position.
NOW()	Returns the current date and time.
TODAY()	Returns the current date.