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