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.