Computer Science 1: Wait... A.N.O.?!

In Excel, you can use one of the three logical operations to construct formulas:

• AND works by performing multiple comparison tests that results to TRUE if all the tests are true, and FALSE if one or more of the tests are false.
• NOT is kind of confusing. But just remember that if the test is true, it means not true so it is FALSE. When the test is false, it means not false so it will be TRUE. (What?!)
• OR works in a very similar function with And. However, the Or function will return TRUE even if only one of the tests returns true.

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKupMO.dpuf

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKupMO.dpuf

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKup