If Statement Overwhelm

[RalphSE]

Hi All,

I said to myself "I can figure this out, don't bother those nice people
on the Exceltip board". That was 3 hours ago, I give up, mercy!!

Here's what I need:

there is a value in cell L2 and a value in cell M2. I am trying to
write an IF statement that will do the following:

*if L2 <.615 and M2 >.615 then say "YES" making that cell be
highlighted green would be an added beautiful thing but not necessary

*if L2 > .49 and M2 < .49 then say "NO" making that cell be highlighted
red would be an added beautiful thing but not necessary

*any other possible combinations other than the 2 mentioned above don't
do or say anything, LOL

would greatly appreciate some help with this!!

 

[Pete_UK]

Hi Ralph, try this:

=IF(AND(L2>0.615,M2>0.615),"YES",IF(AND(L2>0.49,M2<0.49),"NO",""))

(Are you sure it shouldn't be L2<0.49 ?)

To get the red and green use Data | Conditional format - Cell Contents,
is Equal to, "YES", then change format to Green background etc.

Hope this helps

Pete

 

[duane]

=if(and(L2 <.615, M2 >.615),"YES",if(and(L2 >.49, M2 <.49),"NO",""))

you can use the same formulas under conditional formatting (tw
separate and formulas for two colors

 

[Pete_UK]

Sorry, I misread your posting - the first comparison should be L2<0.615

Pete

 

[RalphSE]

Thanks Duane And Pete, 2nd Born Gonna Be Named Pete Now Too, Lol!!!!

 

[Pete_UK]

Well, you'll have so much spare time now, you've got to do something
with it!

Pete