The MODE function calculates the most frequent number in a cell range. Number 4 exists 3 times on picture above […]

Compatibility

MODE functionCalculates the most frequent number in a cell range.

Database

DGET functionFetches a value from a column in a database whose records meet a condition or criteria.

Date and Time

Engineering

Financial

Information

ISFORMULA functionReturns TRUE if a cell contains a formula, FALSE if text, number or boolean value.

Logical

Lookup and reference

ADDRESS functionReturns the address of a specific cell, you need to provide a row and column number.

Math and trigonometry

Statistical

FORECAST.LINEAR functionCalculates a value based on existing x and y values using linear regression.

Text

Web