could I ask why mine with the use of the "AND" operator doesn't work?
I don't really understand why the AND operator doesn't work in this case, since what it's doing seems to me to be logically the same as the formula I posted.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]