It's just so weird.
It just stops working out of the blue.
I guess it's just an Excel 07 thing?

"Jacob Skaria" wrote:

The formula is fine with the cell reference Column HI Row 2..

and returns YES if HI2 is between 401 and 402 (eg: 401.1)

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

If this post helps click Yes
---------------
Jacob Skaria


"Gee" wrote:

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.