When a result is FALSE, the date is replaced by the boolean FALSE.
Handling errors
The formula on this page will work even when events aren’t sorted by date.
However, if there areno upcoming dates, the MIN function will return zero instead of an error.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
you’ve got the option to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
