スプレッドシート関数リファレンス

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.