All three formulas return FALSE if the value in A1 is not greater than 65. The FALSE function is classified as a “compatibility function”, needed only for compatibility with other spreadsheet applications. There is no need to use the FALSE function if you are creating a spreadsheet in Excel. Note that logical expressions will automatically generate TRUE and FALSE results. For example, the formula below will automatically return TRUE if the value in A1 is greater than 90 and FALSE if not: To test a condition and return different results based on whether the results are TRUE or FALSE, see the examples on this page.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
