Does the AND function always evaluate all arguments or only until it comes
across the first one that evaluates as FALSE? If the former is the case, is
there any way to make it work the second way without using a n ested IF
statement?