How to use Excel TRUE Function

Introduction TRUE in excel is a built in logical type function. This function is used to return logical TRUE value. It acts as a worksheet function and can be entered in cell of a worksheet. Syntax =TRUE( ) Arguments There are no arguments for the TRUE. Keynotes TRUE function does not have any arguments and … Read more

How to use Excel FALSE Function

Introduction FALSE in excel is a built in logical type function. This function is used to return logical FALSE value. It acts as a worksheet function and can be entered in cell of a worksheet. Syntax =FALSE( ) Arguments There are no arguments for the FALSE. Keynotes FALSE function does not have any arguments and … Read more

HOW TO USE EXCEL IFS FUNCTION

Introduction IFS comes in the category of logical functions. IFS function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. IFS function can do multiple tests in a single run and is a very good alternative of … Read more

How to use Excel IFNA function

Introduction IFNA function in excel is a logical function. This function is used in case a formula produces an error. With this one can use a customized value if an error is displayed. It checks for #N/A errors. If no error is found IFNA returns the calculated value of the formula. It is a good … Read more

HOW TO USE EXCEL SWITCH FUNCTION

Introduction SWITCH comes in the category of logical functions. SWITCH function can be used for logical comparison of an expression to a list of values and to get the corresponding result. This can do multiple tests in a single run.  Difference between SWITCH and IFS function is that SWITCH function evaluates only an exact match … Read more

How to use Excel IFERROR function

Introduction IFERROR function in excel is a logical function. This function is used in case a formula produces an error. With this one can use a customized value if an error is displayed. It checks for errors like #VALUE! , #NUM! , #N/A! , #REF! , #NAME! etc. If no error is found IFERROR returns … Read more

HOW TO USE EXCEL IF FUNCTION

Introduction IF comes in the category of logical functions. IF function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IF function is … Read more

How to use excel OR Function

Introduction The OR Function is used as a logical function to check multiple conditions at the same instant. OR provides value in the form of TRUE or FALSE. OR function can be used with IF function to remove complexity of multiple nested IF’s and is also used with function AND. Syntax =OR (value1, value2, …) … Read more

Excel NOT function

Excel version in which NOT function can work: Excel NOT function will work in 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 Starter Excel Mobile Excel for Android phones. About excel NOT function: Excel … Read more

Excel XOR function

Excel Version in which XOR function can work: Excel XOR function will work in Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About Excel XOR function: XOR function is familiar for those who … Read more