if/then statement that results in Yes/No

[Patty via OfficeKB.com]

I want either a Yes or No given this if/then statement:

If cell A1 is greater than x AND cell B1 is greater than Y, then YES
otherwise NO. AND, the sum of A1+B1 must be greater than z. All conditions
must be met. How do I do this?

Thanks.

 

[Arvi Laanemets]

Hi

=AND(A1>x,B1>y,A1+B1>z)

 

[bj]

=if(and(A1>x,B1>y,A1+B1>z),"Yes","NO")

 

[Patty via OfficeKB.com]

Thanks. How do I get a YES/NO to appear instead of a true/false?

Hi

=AND(A1>x,B1>y,A1+B1>z)

I want either a Yes or No given this if/then statement:

[quoted text clipped - 3 lines]

Thanks.