if/then statement that results in Yes/No
 

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.


--
Message posted via http://www.officekb.com

Hi

=AND(A1x,B1y,A1+B1z)

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Patty via OfficeKB.com" wrote in message
...
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.


--
Message posted via http://www.officekb.com

=if(and(A1x,B1y,A1+B1z),"Yes","NO")

"Patty via OfficeKB.com" wrote:

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.


--
Message posted via http://www.officekb.com

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

Arvi Laanemets wrote:
Hi

=AND(A1x,B1y,A1+B1z)

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

[quoted text clipped - 3 lines]

Thanks.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1