Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logical function with multiple cells | Excel Worksheet Functions | |||
Logical Test with multiple cells | Excel Worksheet Functions | |||
Multiple Logical Conditions With Date and String Comparison Not wo | Excel Worksheet Functions | |||
Text comparison in adjacent cells | Excel Discussion (Misc queries) | |||
Logical Test comparison using cell color | Excel Discussion (Misc queries) |