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.