That's pretty useful, particularly if you have a long list of items. Some functions require information that generally doesn't come from spreadsheet cells. The last of these functions does let you use information from spreadsheet cells. If you have information in different cells that correspond to a year, month and day, you can synthesize these into a date with the DATE function. Logical Functions Logical functions let you test whether something is true or false.
Logical functions have a lot of uses.
The first part of a logical function is the logical test. This is the test that will be evaluated to see whether it is true or false. The logical operators are shown here along with their meaning. Below, you see three examples of how you compare the values in different spreadsheet cells, or actual values. Remember, the result of each test results in a true or false.