Thread: How do I get an IF statement to pull a date range??
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Browner
 
Posts: n/a
Default How do I get an IF statement to pull a date range??

If i wanted a cell to equal a value if a particular cell was within a
certain range, how would i accomplish that?


For example:

Cell A1=51 and cell B2 to equal 10 if cell A1 is between 50 and 60

I can do this easily for greater then or equal to but not when
combining the 50 and <60 particulars. Please help!


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=357335

Reply With QuoteReply With Quote