Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Information (22)

=CELL(info_type, [reference])

Returns information about the formatting, location, or contents of a cell.

=ERROR.TYPE(error_val)

Returns a number corresponding to an error type.

=INFO(type_text)

Returns information about the current operating environment.

=ISBLANK(value)

Returns TRUE if the value is blank.

=ISERR(value)

Returns TRUE if the value is any error value except #N/A.

=ISERROR(value)

Returns TRUE if the value is any error value.

=ISEVEN(number)

Returns TRUE if the number is even.

=ISFORMULA(reference)

Returns TRUE if there is a reference to a cell that contains a formula.

=ISLOGICAL(value)

Returns TRUE if the value is a logical value.

=ISNA(value)

Returns TRUE if the value is the #N/A error value.

=ISNONTEXT(value)

Returns TRUE if the value is not text.

=ISNUMBER(value)

Returns TRUE if the value is a number.

=ISODD(value)

Returns TRUE if the number is odd.

=ISOMITTED(argument)

Checks whether the value in a LAMBDA is missing and returns TRUE or FALSE.

=ISREF(value)

Returns TRUE if the value is a reference.

=ISTEXT(value)

Returns TRUE if the value is text.

=N(value)

Returns a value converted to a number.

=NA()

Returns the error value #N/A.

=SHEET(value)

Returns the sheet number of the referenced sheet.

=SHEETS(reference)

Returns the number of sheets in a reference.

=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5])

Retrieves historical data about a financial instrument.

=TYPE(value)

Returns a number indicating the data type of a value.