Display values other than TRUE and FALSE

[bmac]

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

 

[T. Valko]

Try this...

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

 

[Alex]

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

 

[Alex]

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

 

[bmac]

Thanks very much!

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

 

[bmac]

Perfect, thanks much

Try this...

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

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!