Thread
:
if a number is less than -1000 in Excel 2003
View Single Post
#
1
SueC
Posts: n/a
if a number is less than -1000 in Excel 2003
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
Reply With Quote