< Go Back

Excel FALSE Function

The Excel FALSE function is a logic function that returns a value of FALSE if certain logic conditions are not met in that cell.

The purpose is to return a FALSE value if the criteria specified is not matched and the returned value is logical value.

Figure 1: Excel False Value

Syntax

The syntax of this function in Excel is:

=FALSE (value)

Where value represents the value specified to be shown FALSE otherwise.

Example of the function

As seen in the figure, the criteria specified in the cells has been set up to:

=IF(B7>60, “OK”, FALSE())

The interpretation of this is that if the value in cell B7 is greater than 60 then return with OK otherwise display the result as FALSE. We can see an example of this logic by inspecting cell B8, which contains a value 59 and is less than 60, hence the formula returns FALSE instead of OK. There are two ways this function can be used and both are able to return with logical FALSE.

=IF (C1<10, “OK” FALSE())

=IF (C1<10, False)

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar