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

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 whichContinue reading “SWITCH function in Excel”

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 theContinue reading “NOT function 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”

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, weContinue reading “TRUE function in Excel”

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:Continue reading “How to extract last name from a name that has middle name”

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”

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, weContinue reading “AND function in Excel”

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 valueContinue reading “OR Function in Excel”

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 exampleContinue reading “FALSE function in Excel”