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

SWITCH function in Excel

Hello All. Let’s explore SWITCH function in this tutorial. SWITCH is a logical function that would compare given value against pre-defined list of values and returns the first match. One can specify an optional default value to be returned if there is no match. Syntax: =SWITCH(expression, value1, result1, [default_or_value2, result2],..) One can recognize IFS which … Read more

NOT function in Excel

Hello all. In this short section, let’s look at NOT function. NOT is a logical function that returns the opposite of logical / boolean value. Syntax: =NOT(logical) Let’s look at a simple example. In the given data set, we are returning TRUE for color Black in the if logic. However, when used NOT with the … 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

TRUE function in Excel

Hello All. Let’s explore the TRUE function in excel. Excel is a logical function that returns the boolean value “TRUE”. Most of the times, IF function is used as the TRUE function just returns the boolean value. Syntax: =TRUE() Let’s look a simple example where the true function is used. In the below dataset, we … Read more

How to extract last name from a name that has middle name

Hello All. In this tutorial, let’s look at how to extract the last name from a name with middle name. The formula can be complex and I will break the formula in to smaller steps so that you can follow every element of the formula used. Let’s look at the dataset and the formula Formula: … 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

AND function in Excel

Hello All. In this tutorial let’s explore the AND function in excel. AND is a logical function used to check one or more conditions and return a “True” value if the conditions are met and “False” if otherwise. Syntax: =AND(logic1, [logic2],[logic3]…) Let’s look at a simple example to start with. In the below example, we … Read more

OR Function in Excel

Hello All. In this tutorial let’s explore the OR function in Excel. OR is a logical function used to check multiple conditions and returns TRUE if one of the conditions meet. Syntax: =OR(logic1, logic2,[logic3],..) Let’s start with a simple example. In the below example, let’s write the OR function to return “True” when the value … Read more

FALSE function in Excel

Hello all. Let’s look at FALSE function in excel. This is a very short tutorial as the FALSE function is classified as compatibility function and not needed in most of the cases. FALSE function would return the logical value / Boolean value “False” directly in the formula. Syntax: =False() Let’s look at a simple example … Read more