Excel FALSE function

In Excel, the FALSE function is a build-in function, it is categorized as logical function. It returns the value FALSE. It is as the same as to entering the Boolean value FALSE directly in a formula.

---

 Syntax:

The syntax for the FALSE function in Excel is:

---

 Return:

Returns the logical value FASLE.

---

 Usage:

The FALSE function in Excel is a compatibility function, it always be used with other logical functions such as IF, IFERROR, etc.

Supposing, you want to check if the numbers in column A is greater than 100, if the number greater than 100, Yes returns, if not, FALSE returns.

Please apply the below formula, you will get the result as screenshot shown:

Tip: In the above formula, you can enter FALSE directly to instead the FALSE(), like this:

---

Excel Productivity Tools