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 ofContinue reading “XOR Function in Excel”

# Tag Archives: logical functions in excel

## 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 IFContinue reading “IF condition in Excel”

## 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 theContinue reading “Logical Functions in Excel”