"Gee" wrote:
Hey, what about some kind of BETWEEN...will that work?

Excel does not have a "between" operator. But that is exactly what
AND(401<HI2,HI2<402) means. By the way, that is also why I write in that
order instead of AND(HI2401,HI2<402). Even thought the two forms are
identical in effect, the first form looks like a "between" operation.

In any case, the real point is: you have never said in English what it is
you are trying to accomplish with the AND() expression. By testing
AND(401<HI2,HI2<402), you seem to be trying to look for numbers with decimal
fractions. But you have never articulated; and some of your postings seem
to contradict that assumption.


----- original message -----

"Gee" wrote in message
...
Hey, what about some kind of BETWEEN...will that work?

"Gee" wrote:

It stopped working again...here's my formula:
=IF(AND(401<HI2,HI2<402),"YES","NO")

"Gee" wrote:

I thought it might be something like that. I changed the columns to no
decimal places, but since it was getting data from an external database
it
might have caused the problem.
It's working right now...if it stops I'll be back!
Thank you SO much for the help! I was really in a corner.


"JoeU2004" wrote:

"Gee" wrote:
Why has this worked for about 3 hours and then suddenly stopped??

Define "working".


=IF(AND(HI2401,HI2<402),"YES","NO")

It probably has nothing to do with time of day, unless the value in
H12 is
derived from time of day (i.e. NOW()).

More likely, the value in H12 is not what it appears to be. For
example, if
the value is 401.00001, it might be displayed as 401, so you might
expect
"NO". But AND(401<H12,H12<402) returns TRUE, so you actual get
"YES".

If that is not enough to help you, post again with details, namely
the
formula and value in H12, formatted to 13 decimal places.


----- original message -----

"Gee" wrote in message
...
Why has this worked for about 3 hours and then suddenly stopped??

Excel 2007 is what I'm using

=IF(AND(HI2401,HI2<402),"YES","NO")

Thank you in advance for any help you can give me.