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”

# Category Archives: Functions in Detail

## 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”

## XLookup Function in Excel

Hello All. In this tutorial let’s look into Xlook up function. Xlookup is a new function introduced in Excel 365 only which would potentially replace the Vlookup / Hlookup functions. Xlookup searches the range or an array for a match and return the appropriate value from the 2nd array or the return array. Xlookup,Continue reading “XLookup Function 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”

## IFNA Function in Excel

Hello all. Here is a very quick run through of the IFNA function in excel. Please note that this function is available only from Excel 2013 versions. IFNA was introduced specifically to trap the “#NA” error and return a specific value for the error condition. Syntax: =IFNA(value, Value_ifna) Let’s look at the example below. AContinue reading “IFNA Function in Excel”