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.
Try itInformation (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.