This is a total aside, but I thought all languages [at execution] would
assign FALSE to an AND statement at the first false clause encountered in the
statement. Since it wouldn't matter if that false were followed by 200 true
clauses, why bother continuing to evaluate? But you're saying that Excel
plows right on? Does VBA? I'm quite sure VB doesn't.

aj


"T. Valko" wrote:

You're welcome. Thanks for the feedback!

=AND(B9<116,MOD(ROW()-9,5)=0)
PS I put the MOD clause before the B9 tests for efficiency's sake.

If you mean you did this:

=AND(MOD(ROW()-9,5)=0,B9<116)

It makes no difference. All the arguments are evaluated before the final
result is produced.


--
Biff
Microsoft Excel MVP