ExcelBanter - View Single Post

Tushar Mehta wrote:
In article <dNoQd.47781$gA4.17299@edtnps89, says...

Just a quick question here. Why isn't the logical test required here
an AND rather than OR?

Consider any month between Jan (1) and Dec (12). What will be the
result of the test Mth <=3 *and* Mth =11?

Of course, if one reversed the test, the appropriate connector would be
AND. Hence, by the definition I used, non-Winter months would be
Mth 3 *and* Mth <11

Sorry! Yes, I was using different inequalities, which required the AND,
and didn't look carefully enough at the original interval desired.

My apologies,
John