Home
/
Excel Functions
/
FALSE Function

FALSE Function

The FALSE function returns the Boolean value False. This function is knowns as a “compatibility function”, used only for compatibility with other functions. For example, the three variations of the below-mentioned IF function will give the same result and are functionally equivalent.

=IF(A1>100,"Good")
=IF(A1>100,"Good",FALSE)
=IF(A1>100,"Good",FALSE())

These formulas will return FALSE if the value in A1 is not greater than 100.

This is to be noted that logical expressions automatically generate True and False results. For example:

=A1>100

The formula above will return False if the value in A1 is not greater than 100 and True if it is greater than 100.

Help others find us!

Md. Saiful Islam

Mr. Saiful Islam is a professional trainer of Excel and other office applications. In addition to conducting training, he has over 15 years of experience in Project Finance, Investment Management, Treasury Management, Budgetary Control, and other key areas of Finance & Accounts. He often writes about Careers, Productivity Tips, Businesses, Technologies, Banking, Investments, and more. He is available to conduct in-house training for any organization and can be reached at +8801673844325 or via his LinkedIn Profile.