View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rocky Perkins Rocky Perkins is offline
external usenet poster
 
Posts: 1
Default 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.