LOGICAL Articles: Excel and Google Sheets

Excel allows a user to use a logical expression in order to check if a condition is true. This is possible by using the IF function which returns Boolean TRUE or FALSE as a result. This step by step tutorial will assist all levels of Excel users in using the...

The XOR function defines exclusive OR. The XOR function in Excel provides a different result for different states. When there are two statements and one of them is TRUE, XOR gives a TRUE. Again if both are TRUE, the outcome will be FALSE. If none of the statements is TRUE,...

The FALSE function in Excel is a logical functions used in mathematical calculations. It provides a logical value while working on a worksheet. We can combine this function with the true function. Combining with other functions such as - IF function, it can be very useful. In this tutorial, we...

We can use Excel OR function to simultaneously test multiple logical conditions. For each argument, the OR function will give TRUE or FALSE. This article will step through the use of the OR function. Figure 1: Final result Syntax of the formula =OR(logical1, [logical2]….) The parameters Logical1- refers to first...

In excel, we can use the IFS function to evaluate multiple conditions without having to use nested if conditions. This function can run multiple tests and return a value which corresponds to the first TRUE result. This article looks at how we can use the excel IFS function to run...

When a given formula in excel generates an error, we can use the IFERROR function to get a custom result, as well as a standard result when there is no error detected. This function is fundamental to those who want to avoid the complicated nested IF function to trap and...

While working with Excel, we are able to find exact matches that satisfy certain criteria by using the IF, INDEX and MATCH functions.  This step by step tutorial will assist all levels of Excel users in extracting data with the aid of a helper column.   Figure 1. Final result:...

We can use the excel IFNA function to generate a custom result when a formula ought to display the #N/A error. This function doesn’t detect other errors apart from the #N/A error. The steps below will walk through the process. Figure 1: How to Use the Excel IFNA Function Formula...

We can use the TRUE function to return a result if the criteria is satisfied. The steps below will walk through the process. Figure 1: How to Use the TRUE Function Syntax =TRUE() Formula =IF(B4>60,TRUE()) Setting up the Data We will set up the data by inputting the SUBJECTS into...