Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Works for me. What exactly doesn't work?
-- Vasant "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
What do you mean 'it doesn't work'? What does it tell you?
There's nothing wrong with your formula. Are you sure the number is actually a number, or is it text that looks like a number. Select A1. Make sure it is formatted as General or Comma, then press F2 & then press Enter. See if that changes the formula's results. Post back and let us know. "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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Thank you all.
I had the incorrect formatting on my s/sheet. Should have tried that first. "Duke Carey" wrote: What do you mean 'it doesn't work'? What does it tell you? There's nothing wrong with your formula. Are you sure the number is actually a number, or is it text that looks like a number. Select A1. Make sure it is formatted as General or Comma, then press F2 & then press Enter. See if that changes the formula's results. Post back and let us know. "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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Function Help | Excel Worksheet Functions |