AM is not a cell reference. Is that a named range?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Denise" wrote:

I want to to use a formula to return "true" in cell AM if cell AK is <=00:30
and false if it is 00:30

I am using the formula =if(AM<=0.020833333,TRUE,FALSE)

This is returning FALSE for any time that is 00:30 or greater. I tried
putting 00:30 in the formula but it wont accept that.

Thanks for any help.