Thread: if statement with a range without a cell reference ie, #s 1100 to
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 if statement with a range without a cell reference ie, #s 1100 to
=IF(G2=1200,12,IF(G2=1100,11,IF(G2=1000,10,IF(G2=6 00,6,""))))

I am trying to get the statement to calculate the numbers between 1100 and
1199; 1000 and 1999, and 600 thru 999. That if a number is put into cell g2
that is between 1100 and 1199, 11 will be in cell d. It won't take the range
without having a cell reference.
--
Dorothy J
Reply With QuoteReply With Quote