View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default IF function between a range of numbers e.g 1000 to 2000

=IF(AND((A11000),(A1<2000)),"Yes","No")
--
Gary's Student


"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