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
The syntax of this function in Excel is:
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)