Logical Comparison of Two cells

R

Rocky Perkins

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.
 
J

JE McGimpsey

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(B1>0.4,"NO","Undefined"),IF(B1<0.4,"Yes","Undefined"))
 
S

steveB

Rocky,

This should work either as a formula, or in code:

=IF(AND(A1<1.15,B1>0.4),"No",IF(AND(A1>=1.15,B1<=0.4),"Yes","Neither"))

- Or -

If Range("A1") < 1.15 And Range("B1") > 0.4 then
MsgBox ("No")
elseif Range("A1") >= 1.15 And Range("B1") <= 0.4 then
MsgBox ("Yes")
else MsgBox ("Neither")
End If

hth
 
Top