Display values other than TRUE and FALSE
 

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

Display values other than TRUE and FALSE
 

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

Display values other than TRUE and FALSE
 

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

"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

Display values other than TRUE and FALSE
 

=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

Display values other than TRUE and FALSE
 

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


.

Display values other than TRUE and FALSE
 

Thanks very much!

"Alex" wrote:

=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

Display values other than TRUE and FALSE
 

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


.