Yep, Thx.

"Bob Phillips" wrote:

Susan,

You do know that -999 is greater than -1000 don't you?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SueC" wrote in message
...
Hi

I am trying to use an if formula to check whether a number is <-1000. I
have
tried the following and it doesn't work.
=if(A1<-1000,"true","")

Please can you help.
Thanks