Ron

Don't know why I added the both IF and AND functions.

There was no logic involved, just a typo.

Should have been simply =AND(A1153,A1<381)

But I see =IF(A1153,A1<381) also works.

The closer got lost in the copying to the post.


Gord

On Sat, 21 Jul 2007 16:09:48 -0400, Ron Rosenfeld
wrote:

On Sat, 21 Jul 2007 10:47:25 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

=IF(AND(A1153),(A1<381)

Interesting formula (although needs another close parentheses).

After I understood the logic, I could simplify it to:

=IF(A1153,A1<381)

Which is one keystroke shorter than mine:

=AND(A1153,A1<381)




--ron