View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
been drilbled to 2007 been drilbled to 2007 is offline
external usenet poster
 
Posts: 14
Default IF function between a range of numbers e.g 1000 to 2000

hi,

=AND(a1=1000,a1<=2000)
result either true or false
maybe..

"suz" wrote:

I want to check if a number is ina range between 1000 and 2000 and I can't
get the IF function to work propoerly using the greater than and smaller than
signs