View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dorothy J Dorothy J is offline
external usenet poster
 
Posts: 10
Default range in an IF statement

I need the IF statement to look for numbers 1100 through 1199, then put 11 in
another cell. How do I get the IF statement to recognize the range 1100
through 1199? Meaning, any number between 1100 and 1199 should be given the
number 11?
--
Dorothy J