SheetMaster - Free Excel Formula Generators

Master Excel & Google Sheets Formulas. Search or select a tool below to generate code instantly.

Showing all 50 formulas

VLOOKUP

Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

IF

Checks whether a condition is met, and returns one value if true and another value if false.

SUMIF

Adds the cells specified by a given condition or criteria.

COUNTIF

Counts the number of cells within a range that meet the given condition.

CONCATENATE

Joins several text strings into one text string.

INDEX/MATCH

A more flexible alternative to VLOOKUP. Returns the value of an element in a table or an array, selected by the row and column number indexes.

XLOOKUP

Searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.

TRIM

Removes all spaces from text except for single spaces between words.

UPPER

Converts text to uppercase.

LOWER

Converts all uppercase letters in a text string to lowercase.

PROPER

Capitalizes the first letter in each word of a text value.

LEFT

Returns the first character or characters in a text string, based on the number of characters you specify.

RIGHT

Returns the last character or characters in a text string, based on the number of characters you specify.

DATEDIF

Calculates the number of days, months, or years between two dates.

NOW

Returns the serial number of the current date and time.

TODAY

Returns the serial number of the current date.

NETWORKDAYS

Returns the number of whole working days between start_date and end_date.

PMT

Calculates the payment for a loan based on constant payments and a constant interest rate.

AND

Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.

OR

Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

REGEXEXTRACT

Extracts an email address from a text string.

REGEXEXTRACT

Extracts the domain part from a URL.

LEFT & FIND

Returns the first word in a text string.

RIGHT & LEN

Removes the specified number of characters from the beginning of a text string.

SUMIFS

Adds all cells that meet multiple criteria. More powerful than SUMIF for complex conditions.

COUNTIFS

Counts cells that meet multiple criteria. Essential for data analysis with complex conditions.

AVERAGEIF

Returns the average of all cells in a range that meet a given criteria.

IFERROR

Returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula.

IFS

Checks multiple conditions and returns a value corresponding to the first TRUE condition. Cleaner than nested IFs.

SUBSTITUTE

Substitutes new text for old text in a text string. Great for data cleaning.

MID

Returns a specific number of characters from a text string, starting at the position you specify.

LEN

Returns the number of characters in a text string.

FIND

Returns the starting position of one text string within another (case-sensitive).

SEARCH

Returns the position of a text string within another (case-insensitive). Supports wildcards.

TEXT

Converts a value to text in a specific number format.

ROUND

Rounds a number to a specified number of digits.

ROUNDUP

Rounds a number up, away from zero.

ROUNDDOWN

Rounds a number down, toward zero.

ABS

Returns the absolute value of a number (removes the negative sign).

MAX

Returns the largest value in a set of values.

MIN

Returns the smallest value in a set of values.

AVERAGE

Returns the average (arithmetic mean) of the arguments.

SUM

Adds all the numbers in a range of cells.

YEAR

Returns the year of a date, an integer in the range 1900-9999.

MONTH

Returns the month of a date, a number from 1 (January) to 12 (December).

DAY

Returns the day of a date, a number from 1 to 31.

EDATE

Returns a date that is a specified number of months before or after a given date.

EOMONTH

Returns the last day of the month a specified number of months before or after a date.

COUNTA

Counts number of cells that are not empty in a range.

COUNTBLANK

Counts the number of empty cells in a specified range.

Advertisement

AdSense Placeholder