View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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