=IF(AND($E2=H$1,$E2<I$1),"YES","NO")
Please try this.

"bmac" wrote:

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