# 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 |