What about if A1 is less than 1.15 and B1 is less than 0.4, or if A1 is
greater than 1.15 and B1 is greater than 0.4?

A literal interpretation of your criteria is

=IF(A1<1.15,IF(B10.4,"NO","Undefined"),IF(B1<0.4, "Yes","Undefined"))



In article ,
"Rocky Perkins" wrote:

i have two cells of data. I need to do a logical
comparison of both cells. More graphically.

A1 B1
1.25 .36

I need to look at both of these cells simultaneously and
return either a 'yes' or 'no' depending on a defined set
of criteria.

If A1 is less than 1.15 and B1 is greater than .40, I need
a 'NO'
If A1 is greater than or equal to 1.15 and B1 is less than
or equal to .40, then 'Yes'

I have been unable to get any of the IF conditional
statemnts to work. I appreciate ANY advice given.