Hi Sue,
Works like charm to me. Are you sure you are putting values lower than -1000
in A1, e.g. -1001, -2000, etc.?
Regards,
KL
"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
|