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 simply returns the Boolean TRUE value.It is a compatibility function. Examples In this example, some numbers are entered in column A and in Column B…

Continue Reading

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 simply returns the Boolean FALSE value.It is a compatibility function. Examples In this example, some numbers are entered in column A and in Column B…

Continue Reading

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 nested IF function. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IFS function is also used in combination with…

Continue Reading

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 alternative to complicated nested IF function. Syntax =IFNA(value,value_if_na) Arguments Value- Value whose error has to be checked.Value_if_na- Custom value to be retrieved if error is…

Continue Reading

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 and does not use operators such as less than and greater than .SWITCH is also used in combination with other functions like AND , OR…

Continue Reading

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 the calculated value of the formula. It is a good alternative to complicated nested IF function. Syntax =IFERROR(value,value_if_error) Arguments Value- Value whose error has to…

Continue Reading

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 also used in combination with other functions like AND , OR , COUNT etc. More than one function can be tested with the help of…

Continue Reading

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, ...) Arguments value1 – It is the 1st value (logical) that will be processed. value2 -  It is the 2nd value (logical) that will be processed.…

Continue Reading

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 NOT function is a logical function, it checks a logical value and returns the opposite logical value. If input logical value is TRUE it will return the…

Continue Reading

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 know the programming knowledge. XOR checks the logical values or conditions and returns TRUE if when number of TRUE inputs are odd and returns when…

Continue Reading
Close Menu
×

Cart