You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"bmac" wrote in message
...
Perfect, thanks much

"T. Valko" wrote:

Try this...

=IF(AND($E2=H$1,$E2<I$1),"Yes","No")

--
Biff
Microsoft Excel MVP


"bmac" wrote in message
...
Hello, I have the following formula that returns TRUE and FALSE values.
=AND($E2=H$1,$E2<I$1)

How do I modify the formula to display "YES" and "NO" instead of true
and
false.

Thanks very much in advance


.