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.