You are currently viewing How to use true and false functions in Excel

How to use true and false functions in Excel

Microsoft Excel is an excellent tool often used to keep track of data and other useful records. Among the various capabilities entailed in excel is the use of function and not only so but those that are conditional by nature. This conditional function operates under the same principle of Boolean logic. In our case, instead of 1's and O's, we have True and False. This type of formulae is very powerful in its simplicity.

For example, you might be a class teacher. You may need to calculate and see the student performance in relation to the mean score.

Having noticed the importance of the true and false, it time dive into its use!!!


How to use the true and false function in Microsoft Excel

1. Have a list of data in place to compare.. as in my case, the data is below

In our case, with the data provided, we will be checking those that have attained the mean mark, which is 50.

With those who have attained 50 and above, the remark would display true, and those that are 49 and below False will be what we expect.

2. In cell C3, write the conditional function If (B3>= 50, True(), False())

In our table, since the first column B3, Kengere is above average, the outcome will be true

3. Repeat the same process in the remaining cells


Method 2

Alternative, you may decide to fill Handle Technique where you

1. Select both cells C2 and A3 where had the formula.

2. You will notice a small square just at the bottom-right of what you selected.

3. Move your cursor near the square; the cursor will change to a plus (+) icon.

4. Double-click the fill handle square without removing the cursor on the plus icon.

5. All the remaining cells will automatically fill until the end of your dataset.

We can use this to make calculations in formulas and when integrated into larger formulas.

We can perform the following calculations as illustrated below.

There is a formula that FALSE and TRUE results are multiplied by 25.

FALSE results are multiplied to 25 by 0, and TRUE results are multiplied to 25 by 1. Integration into larger formulas is highly considered.

However, it can be used as a tool for validating data to ensure consistency and accuracy in Excel.

Excel formulas enhance texts that contain specific substring to be entered. The steps below illustrate how to validate the entry of texts containing specific criteria.

* Find the substring in text.

* It returns to either TRUE or FALSE after the results are checked.



That was simple, is it so? Hoping the guide has been simple and useful as you notice how powerful a tool the true and false function is, and advancing your knowledge in its application will only make Excel desirable and easy to use