SheetMaster - Free Excel Formula Generators
Master Excel & Google Sheets Formulas. Select a tool below to generate code instantly.
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.
Advertisement
AdSense Placeholder