View Single Post
  #1   Report Post  
Patty via OfficeKB.com
 
Posts: n/a
Default 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