Logical Comparison of Two cells
 

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.

Logical Comparison of Two cells
 

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.

Logical Comparison of Two cells
 

Rocky,

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

=IF(AND(A1<1.15,B10.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
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"Rocky Perkins" wrote in message
...
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.