IF(AND()) with date as numbers...

[Dieneces]

Hello again guys...

I'm having a problem with the IF /AND statement...

I have a column with the hours of the day (0 to 23) and I need to have to periods, from 8 to 20 and from 21 to 7.... as well as other true requirements already implemented.

Now... the complete formula for the morning period is done and it works:

=IF(AND(F2<$O$6;G2>$P$6;B2>=8;B2<=20);"P5";"OK")

The last AND expression is the hours range.. The problem is the evening problem....

=IF(AND(F2<$O$6;G2>$P$6;B2>=0;B2<=7);"P5";"OK") -> With this I only miss the 21,22 and 23 hours... the problem is how to... is there a way to keep all the ANDs and incorporate one OR for the last statement?

Many thanks for all the experts out there trying to help the newbies

[NBVC]

How about including an OR:

=IF(AND(F2<$O$6;G2>$P$6;OR(B2>=21;B2<=7));"P5";"OK")

[Cutter]

Maybe change this
=IF(AND(F2<$O$6;G2>$P$6;B2>=0;B2<=7);"P5";"OK")
to this
=IF(AND(F2<$O$6;G2>$P$6;OR(B2>=21;B2<=7));"P5";"OK")

[Dieneces]

.... I tried to use the OR in three different ways some with errors some with no results... Now I see what I was doing wrong... I was trying to put the OR outside the AND (doesn't make any sense I know... it as by mistake #|)

Many thanks for thw wise and quick replys.