On Course for Success

Monthly Archives: July 2017

True or False

TRUE and FALSE Logical Tests

Learning Excel Logical tests - True False with INIT LearningExcel logical tests are an ideal way to test if something is true or false. Using the operators below will return a TRUE or FALSE:

=         Equal
>         Greater than
<         Less than
>=       Greater than or Equal to
<=       Less than or Equal to
<>       Does not Equal

The content of cells can be tested and returns the word TRUE or FALSE. TRUE and FALSE are “Boolean Functions”, and therefore TRUE = 1 and FALSE = 0

Sometimes it’s more beneficial to display a 1 or 0. This can be achieved in several ways:

  • =–(logical_test)
  • =(logical_test)/1
  • =(logical_test)*1
  • =(logical_test)+0