IF Statement - AND, OR

J

James Hamilton

Hi,

I have a formula as follows:

=IF((AND(D5>$100,000,E5>10%)),"yes","no")

I want to add another condition as follows:

=IF((AND(D5<-$100,000,E5<-10%)),"yes","no")

....and I can't get it to work.

Any assistance would be appreciated.

James
 
D

Don Guillett

try something like (untested)
=IF(or(AND(D5>$100,000,E5>10%),AND(D5<-$100,000,E5<-10%)),"yes","no")
 
M

Max

Try a: OR(AND(cond1),AND(Cond2)) construct .., viz.:
=IF(OR(AND(D5>100000,0,E5>10%),AND(D5<-100000,0,E5<-10%)),"yes","no")
 
Top