XOR Function in Excel

Hello all. In this short tutorial let’s look at the XOR (exclusive OR) function. XOR is a logical function that check two or more logic and return TRUE or FALSE value. If either of the condition is true, the function returns TRUE. The function returns FALSE if both the condition is true or neither of … Read more

IF condition in Excel

Hello All. Let’s look at one of mostly used function – IF function. IF function performs logical test returns the specified value for TRUE or FALSE results. Syntax: =if(logical_test,[value_if_true],[value_if_false]) Here, logical_test can use “=”, “>”, “<“, “>=”, “<=”, “<>” arguments. Let’s look at examples for the IF function, then look at nested IF and IF … Read more

Logical Functions in Excel

Hello All. In this section let’s look into all the logical functions available. Here is the table with the usage and syntax for all the functions.  Function  Usage  Syntax  AND  Test multiple conditions and returns true if all conditions are true  =AND(Logic 1, Logic 2,…)  FALSE  Returns the logical value FALSE  =FALSE()  TRUE  Returns the … Read more