# How to Use TRUE and FALSE Functions/ Formula in Excel with 4 Examples

Surprisingly, many of Excel’s built-in functions are naturally conditional. They only return either **TRUE** or **FALSE**. Most Excel users like to see **TRUE** or **FALSE** as an outcome of other boolean-dependent functions. Besides, they should know Excel provides the **TRUE** and **FALSE** functions as well.

In this article, we will learn about the application of the **TRUE** and **FALSE** functions with some examples.

**Syntax of TRUE and FALSE Functions**

`=TRUE()`

`=FALSE()`

**Argument of TRUE and FALSE Functions**

*This function doesn’t hold any arguments inside the bracket. *

**Return of TRUE Function**

When written in Excel, the function will either return **TRUE** or** FALSE**. The more interesting fact is that it works without any argument.

The numerical value of **TRUE** is **1,** and similarly, **FALSE** is **0**. So, the following operations can be done by the **TRUE** and **FALSE** functions:

**4 Examples of How to Use TRUE and FALSE Formula/ Functions in Excel**

**Example #1: Numeral Application of TRUE and FALSE Function**

As we already know, the TRUE function implies 1, and the FALSE function implies 0. So, the TRUE and FALSE functions can be used to construct any mathematical formula in an Excel sheet.

**Example #2: Application of the TRUE and FALSE Functions with the IF Function**

To understand properly, you should know the following about the **IF** function:

**Syntax of the IF Function**

`=IF(logic1,return1,return2)`

**The argument of the IF Function:**

*logic1:** conditional expression, you want to evaluate*

*return1: **the text or logical expression you want to see in return if **logic1** is satisfied.*

*return1**: the text or logical expression will be returned if **logic1** is not satisfied.*

Now, letâ€™s try this example,

Assume that several **salesmen** in your firm sell the same product. Then, you’ll decide whether or not to give a bonus based on the **quantity **sold in a month.

If you want to give a bonus to the salesperson who sold more than** 800** units of product,

Just write the following formula in the output cell **D4** and press Enter.

`=IF(C4>800,TRUE(),FALSE())`

Then **AutoFill** the remaining cell in column** D**

**Explanation**

If the sale quantity of any salesman exceeds **800**, the **IF** function will call the **TRUE** function; otherwise, the **IF** function will call the **FLASE** function.

**Example #3: Counting TRUE and FALSE using the COUNTIF Function**

Before starting this example, you should have the following idea about the **COUNTIF** function:

**Syntax of COUNTIF Function**

`=COUNTIF(cell_range, criteria)`

**Argument of COUNTIF Function **

*data_range:** The range in the Excel sheet to be counted.*

*criteria: **denotes the range criteria to be counted.*

*Let’s jump to the example,*

We can also use the **COUNTIF** function to determine how many salesmen will receive bonuses.

`=COUNTIF(D4:D8,TRUE())`

The **COUNTIF** function will record the frequency with which the value **“TRUE**” appears in column **D.**

**Example #4: Creating a Grade sheet Ignoring Absent Students**

Now we will calculate the average grade for the students based on the numbers obtained in five subjects: English, math, science, finance, and mental ability.

We must completely ignore any student who is **absent **or obtains less than a **50** in any subject.

Insert the following formula in the output cell **G3** and then press **Enter.**

`=IF(AND(B3>50, C3>50, D3>50, E3>50, F3>50), SUM(B3:F3)/5, FALSE())`

To see the grade for other students**, AutoFill **the rest cells in column** G**

**Explanation**

- For
**Richard**, marks in all subjects are greater than**50**. That’s why the**IF**function enables the**SUM**function to calculate the grade. - But for
**James**, one cell was kept empty, which means James was absent from that exam. So, the**IF**function triggers the**FASLE**function to return in**FALSE** **Don and John**failed several subjects. So, the IF function triggers the**FASLE**function to return in**FALSE**

**Conclusion**

In conclusion, Excel’s **TRUE** and** FALSE **functions are useful for assessing logical situations, developing sophisticated logical expressions, and creating potent formulae that can aid in making judgments based on your facts.

We hope, after reading the article, you are perfect at using the **TRUE** and **FALSE** functions in Excel. Please leave a comment if this article- **How to Use TRUE and FALSE Functions/ Formula in Excel with 4 Examples**– was helpful.

6172c0D1723Bd.site123.meSomebody necessarily assist to make sinificantly posts I’d state.

That is the very first time I frequented your website page and to this point?

I amazed with the analysis you made to create this actual post extraordinary.

Excellent job!

Here is my webpage 6172c0D1723Bd.site123.me