On Course for Success

Excel

Evening Classes

Milton Keynes

InIT Learning are pleased to announce the introduction of evening classes in Milton Keynes for nine weeks covering all three levels of Excel. Delegates receive nine comprehensive manuals and three certificates of attendance. All equipment is provided. A great friendly environment with no more than six delegates on each course. First course starts in October 2018 so get your place or places for your staff booked now.

Excel – Find out more>>

Scheduled Excel Courses

Excel Courses are scheduled in Milton Keynes

Excel Courses Milton Keynes

Best value Excel Courses in Milton Keynes
Harben House Hotel
Newport Pagnell

Excel Courses >>>

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