100 Useful Excel Formulas

SUM(): Adds up numbers in a range of cells.

AVERAGE(): Calculates the average of numbers in a range.

COUNT(): Counts the number of cells that contain numbers.

COUNTA(): Counts the number of non-empty cells (including text).

IF(): Performs a logical test and returns different values based on the result.

VLOOKUP(): Looks for a value in the first column of a table and returns a value in the same row

from another column.

HLOOKUP(): Looks for a value in the first row of a table and returns a value in the same column

from another row.

CONCATENATE(): Combines (joins) multiple text strings into one.

LEFT(): Extracts a specified number of characters from the start of a text string.

RIGHT(): Extracts a specified number of characters from the end of a text string.

NOW(): Returns the current date and time.

TODAY(): Returns the current date.

ROUND(): Rounds a number to a specified number of digits.

LEN(): Counts the number of characters in a text string.

MAX(): Returns the largest value in a range of cells.

MIN(): Returns the smallest value in a range of cells.

SUMIF(): Adds up the values in a range that meet a specific condition.

COUNTIF(): Counts the number of cells that meet a specific condition.

PMT(): Calculates the payment for a loan based on constant payments and a constant interest rate.
INDIRECT(): Returns the reference specified by a text string.

XLOOKUP(): Searches for a value in a row or column and returns the value from another row or

column.

MATCH(): Returns the relative position of an item in a range that matches a specified value.

INDEX(): Returns the value of a cell in a range based on the row and column number.

TRIM(): Removes extra spaces from text, except single spaces between words.

SUBSTITUTE(): Substitutes one text string with another in a given text.

REPLACE(): Replaces part of a text string with another string.

FIND(): Finds the position of a substring within a string, case-sensitive.

SEARCH(): Finds the position of a substring within a string, case-insensitive.

DATE(): Returns a date based on year, month, and day.

YEAR(): Extracts the year from a date.

MONTH(): Extracts the month from a date.

DAY(): Extracts the day from a date.

TEXT(): Formats a number or date as text in a specified format.

ISNUMBER(): Checks if a value is a number.

ISTEXT(): Checks if a value is text.

ISBLANK(): Checks if a cell is empty.

ISERROR(): Checks if a cell contains an error.

ISNA(): Checks if a cell contains the #N/A error.

AND(): Checks if all conditions in a logical test are TRUE.

OR(): Checks if any condition in a logical test is TRUE.

MOD(): Returns the remainder when one number is divided by another.

POWER(): Returns the result of a number raised to a given power.

SQRT(): Returns the square root of a number.

EXP(): Returns the result of e raised to the power of a number.

LN(): Returns the natural logarithm of a number.

LOG(): Returns the logarithm of a number to a specified base.

RAND(): Generates a random number between 0 and 1.

RANDBETWEEN(): Generates a random integer between two specified numbers.

PI(): Returns the value of pi.

CELL(): Returns information about the formatting, location, or contents of a cell.

INFO(): Returns information about the current operating environment.

COLUMN(): Returns the column number of a reference.

ROW(): Returns the row number of a reference.

ROWS(): Returns the number of rows in a given array or reference.

COLUMNS(): Returns the number of columns in a given array or reference.

CONVERT(): Converts a number from one measurement unit to another.

DAYS(): Calculates the number of days between two dates.

NETWORKDAYS(): Returns the number of working days between two dates.

WORKDAY(): Returns the date before or after a specified number of working days.

N(): Converts a value to a number.

EOMONTH(): Returns the last day of the month, a specified number of months before or after a
given date.

EDATE(): Returns the date that is a specified number of months before or after a given date.

CLEAN(): Removes non-printable characters from text.

MROUND(): Rounds a number to the nearest specified multiple.

CEILING(): Rounds a number up, away from zero, to the nearest multiple.

FLOOR(): Rounds a number down, toward zero, to the nearest multiple.

ABS(): Returns the absolute value of a number.

SIGN(): Returns the sign of a number (1, 0, or -1).

EVEN(): Rounds a number up to the nearest even integer.

ODD(): Rounds a number up to the nearest odd integer.

RANDARRAY(): Generates an array of random numbers.

TEXTJOIN(): Combines multiple text strings into one, with a delimiter.

UNIQUE(): Returns unique values from a range.

SORT(): Sorts the contents of a range or array.

FILTER(): Filters an array based on a condition.

SEQUENCE(): Generates a sequence of numbers.

SPILL(): Returns the spilled array of a formula.

LET(): Defines a name for calculation results inside a formula.

LAMBDA(): Creates custom functions within Excel.