AND function
TheAND functionreturns TRUE if all arguments are TRUE.
The first comparison is against the start date.
For cell B6 however, the result is FALSE.
We now have the logical test we can use in the IF function.
The values returned by the IF function can be customized as desired.
More than one condition can be tested by nesting IF functions.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
The AND function is commonly used with other…
Related videos
The IF function
