A calculated field (see Calculated) can be formatted to return Boolean values i.e. TRUE or FALSE. An example of the usefulness of such a field is the following.
Imagine you have two sets of data, for which you want to make a direct comparison item by item e.g. yearly income and expenditure over a five-year period. The Success column is a calculated field and contains this formula:
=IF(Income>Expenditure, True, False)
Income |
Expenditure |
Success |
30,000 |
39,000 |
FALSE |
28,000 |
27,000 |
TRUE |
33,000 |
33,000 |
FALSE |
100,000 |
40,000 |
TRUE |