SpreadSheet Function List

Category Function Syntax Description
Compatibility COVAR COVAR(array1, array2)

Calculates the covariance between two sets of numbers. Learn more

Date and time DATE DATE(year, month, day)

Converts a specified year, month, and day into date format. Learn more

Date and time DAY DAY(date)

Returns the day of a given date. Learn more

Date and time DAYS DAYS(end_date, start_date)

Calculates the number of days between two given dates. Learn more

Date and time DAYS360 DAYS360(start_date, end_date, [method])

Calculates the number of days between two given dates, based on a 360-day year (30 days per month, 12 months per year). Learn more

Date and time EDATE EDATE(start_date, months)

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

Date and time EOMONTH EOMONTH(start_date, months)

Returns the last day of the month, that is a specified number of months before or after a given date. Learn more

Date and time ISOWEEKNUM ISOWEEKNUM(date)

Returns the ISO week number of a given date. Learn more

Date and time MONTH MONTH(date)

Returns the month of a given date, in the form of an integer. Learn more

Date and time TODAY TODAY()

Returns the current date. Learn more

Engineering BIN2DEC BIN2DEC(number)

Converts a binary number into a decimal number. Learn more

Engineering BIN2HEX BIN2HEX(number, [places])

Converts a binary number into a hexadecimal number. Learn more

Engineering IMABS IMABS(inumber)

Returns the absolute value of a complex number. Learn more

Engineering IMAGINARY IMAGINARY(inumber)

Returns the imaginary coefficient of a complex number. Learn more

Engineering IMCONJUGATE IMCONJUGATE(inumber)

Returns the complex conjugate of a complex number. Learn more

Engineering IMCSC IMCSC(inumber)

Returns the cosecant of a complex number. Learn more

Engineering IMDIV IMDIV(inumber)

Divides one complex number by another and returns the quotient. Learn more

Engineering IMPRODUCT IMPRODUCT(inumber1, [inumber2], ...)

Multiplies all given complex numbers and returns the product. Learn more

Engineering IMREAL IMREAL(inumber)

Returns the real coefficient of a complex number. Learn more

Information ERROR.TYPE ERROR.TYPE(error_val)

Receives an error value and returns a corresponding number to this error value. Learn more

Logical IF IF(logical_test, value_if_true, [value_if_false])

Returns one value if a condition is true and another if it is false. Learn more

Lookup and reference CHOOSE CHOOSE(index_num, value1, [value2], ...)

Chooses a value from a list of values according to index. Learn more

Lookup and reference MATCH MATCH(lookup_value, lookup_array, [match_type])

Returns the relative position of a specified value in a range of cells. Learn more

Math and trigonometry ATANH ATANH(number)

Calculates the inverse hyperbolic tangent of a given number. Learn more

Math and trigonometry DEGREES DEGREES(angle)

Converts radians into degrees. Learn more

Math and trigonometry FACT FACT(number)

Calculates the factorial of a number. Learn more

Math and trigonometry INT INT(number)

Rounds a real number down to the nearest integer. Learn more

Math and trigonometry LOG LOG(number, [base])

Calculates the logarithm of a number to a specified base. Learn more

Math and trigonometry LOG10 LOG10(number)

Calculates the base 10 logarithm of a number. Learn more

Math and trigonometry PI PI()

Returns the value of the mathematical constant π (pi), accurate to 10 digits. Learn more

Math and trigonometry PRODUCT PRODUCT(number1, [number2], ...)

Multiplies all given numbers and returns the product. Learn more

Math and trigonometry RADIANS RADIANS(angle)

Converts degrees into radians. Learn more

Math and trigonometry RAND RAND()

Returns a random number between 0 (inclusive) and 1 (exclusive). Learn more

Math and trigonometry RANDBETWEEN RANDBETWEEN(bottom, top)

Returns a random integer number between specified numbers every time the spreadsheet is opened. Learn more

Math and trigonometry ROUND ROUND(number, num_digits)

Rounds a number to a specific number of decimal places. Learn more

Math and trigonometry SIGN SIGN(number)

Returns the sign of a given number. Learn more

Math and trigonometry SUM SUM(number1, [number2],...)

Adds all given numbers and returns the sum. Learn more

Math and trigonometry SUMIF SUMIF(range, criteria, [sum_range])

Adds the values in a range according to a specified criteria. Learn more

Statistical AVERAGE AVERAGE(number1, [number2], ...)

Returns the average value (arithmetic mean) of its arguments, ignoring text and blank cells. Learn more

Statistical AVERAGEIF AVERAGEIF(criteria_range, criterion, [average_range])

Returns the average value (arithmetic mean) of a range according to a specified criteria. Learn more

Statistical COUNT COUNT(value1, [value2], ...)

Counts the number of numeric values in a range. Learn more

Statistical COUNTA COUNTA(value1, [value2], ...)

Counts the number of non-blank values in a range. Learn more

Statistical COUNTIF COUNTIF(range, criteria)

Counts the number of cells within a range according to a specified criteria. Learn more

Statistical MAX MAX(number1, [number2], ...)

Returns the maximum value in a set of numeric data. Learn more

Statistical MIN MIN(number1, [number2], ...)

Returns the minimum value in a set of numeric data. Learn more

Text FIND FIND(find_text, within_text, [start_num])

Returns the first position of a text string within another text string, case sensitive. Learn more

Text LEN LEN(text)

Returns the number of characters in a text string, spaces included. Learn more

Text SUBSTITUTE SUBSTITUTE(text, old_text, new_text, [instance_num])

Substitutes new text for old text in a text string. Learn more

results matching ""

    No results matching ""