How to use Excel ERROR.TYPE Function

Introduction:- ERROR.TYPE function in excel is an information function. It is used to retrieve a number corresponding to an error value. If there is no error than #N/A is displayed. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ERROR.TYPE(error_value) Arguments:- Error_Value: The error value whose … Read more

How to use Excel ISBLANK Function

Introduction:-                 ISBLANK function in excel is an information function. It is used to find out whether cells are empty. It returns TRUE if cell is empty otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISBLANK(VALUE) Arguments:- Value:  It is the value which … Read more

How to use Excel ISERR Function

Introduction:- ISERR function in excel is an information function. It is used to find out whether cells contain an error value except for #N/A error. It returns TRUE if cell contains an error value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- … Read more

How to use Excel ISERROR Function

Introduction:- ISERROR function in excel is an information function. It is used to find out whether cells contain an error value including the #N/A error. It returns TRUE if cell contains an error value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- … Read more

How to use Excel ISEVEN Function

Introduction:- ISEVEN function in excel is an information function. It is used to find out whether cells contain a numeric value which is even. It returns TRUE if cell contains an even value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISEVEN(VALUE) … Read more

How to use Excel ISFORMULA Function

Introduction:- ISFORMULA function in excel is an information function. It is used to find out whether cells contain a formula or not. It returns TRUE if cell contains a formula otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISFORMULA(VALUE) Arguments:- Value:  It … Read more

How to use Excel ISLOGICAL Function

Introduction:-     ISLOGICAL function in excel is an information function. It is used to find out whether cells contain a logical value or not. It returns TRUE if cell contains a logical value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISLOGICAL(VALUE) Arguments:- … Read more

How to use excel cell function

Version in which excel CELL function can work: Excel CELL function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android … Read more

How to use INFO function in excel

Excel version in which INFO function can work: INFO function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel … Read more