Excel Information Functions

Excel NA Function

This post will guide you how to use Excel NA function with syntax and examples in Microsoft excel. Description The Excel NA function returns the #N/A error value. And the #N/A is the error value that means “no values is available”. And the #N/A error value will be produced when a formula is not able… read more »

Excel TYPE Function

This post will guide you how to use Excel TYPE function with syntax and examples in Microsoft excel. Description The Excel TYPE function returns the type of a value. So you can use the TYPE function to return an integer that represents the value’s type in Excel. For example, if the value is a number,… read more »

Excel N Function

This post will guide you how to use Excel N function with syntax and examples in Microsoft excel. Description The Excel N function converts a value to a numeric value. And the N function can be used to convert the logical value TRUE as 1 and false value as 0. If you try to convert… read more »

Excel ISREF Function

This post will guide you how to use Excel ISREF function with syntax and examples in Microsoft excel. Description The Excel ISREF function used to check if a value is a valid reference. If so, returns TRUE; if the value is not a reference, the function will return FALSE. So you can use the ISREF… read more »

Excel ISNONTEXT Function

This post will guide you how to use Excel ISNONTEXT function with syntax and examples in Microsoft excel. Description The Excel ISNONTEXT function used to check if a value is text. If so, returns FALSE; if the text is not text, the function will return TRUE. So you can use the ISNONTEXT function to check… read more »

Excel ISTEXT Function

This post will guide you how to use Excel ISTEXT function with syntax and examples in Microsoft excel. Description The Excel ISTEXT function used to check if a value is text. If so, returns TRUE; if the text is not text, the function will return FALSE. So you can use the ISTEXT function to check… read more »

Excel ISNA Function

This post will guide you how to use Excel ISNA function with syntax and examples in Microsoft excel. Description The Excel ISNA function used to check if a cell contains the #N/A error, if so, returns TRUE; otherwise, the ISNA function returns FALSE. The #N/A error will be returned when a value is not available… read more »

Excel ISERR Function

This post will guide you how to use Excel ISERR function with syntax and examples in Microsoft excel. Description The Excel ISERR function returns TRUE if the value is any error value except #N/A. The ISERR function is a build-in function in Microsoft Excel and it is categorized as an Information Function. The ISERR function… read more »

ISNUMBER Function in Excel

This post will guide you how to use¬†ISNUMBER function¬†with syntax and examples in Microsoft excel. Description The Excel ISNUMBER function returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE. so you can use ISNUMBER function to check if a cell contains a numeric value or check the… read more »

Excel ISError Function

This post will guide you how to use Excel ISERROR function with syntax and examples in Microsoft excel. Description The Excel ISERROR function used to check for any error type that excel generates and it returns TRUE for any error type, such as: #N/A, #VALUE!,#REF!,#DIV0!, #NAME?, etc. and the ISERR function also can be checked… read more »

Sidebar