Excel and Google Sheets formula guide
Adds all numbers in a range of cells.
Returns the average (arithmetic mean) of its arguments.
Looks for a value in the leftmost column and returns a value in the same row from a column you specify.
Looks for a value in the top row and returns a value in the same column from a row you specify.
Returns a value at the intersection of a particular row and column.
Returns the relative position of an item in a range.
Performs a logical test and returns one value for TRUE and another for FALSE.
Checks multiple conditions and returns a value corresponding to the first TRUE condition.
Counts the number of cells that meet a criterion.
Adds cells that meet a criterion.
Joins several text strings into one.
Returns the leftmost characters from a text string.
Returns the rightmost characters from a text string.
Returns characters from the middle of a text string.
Returns the number of characters in a text string.
Removes extra spaces from text.
Returns the current date.
Returns the current date and time.
Creates a date from year, month, and day.
Calculates the difference between two dates.
Calculates the payment for a loan based on constant payments and interest rate.
Returns the future value of an investment.
Rounds a number to a specified number of digits.
Returns the largest value in a set of values.
Returns the smallest value in a set of values.
Excel and Google Sheets formula guide
Use this free online document tools tool to work faster without installing extra software. The interface is built for quick input, clear output, and straightforward results on desktop and mobile devices.
This tool runs in your browser whenever possible, which keeps your inputs private and reduces unnecessary round-trips to the server.