Thread: Between function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Between function
You can use the AND function. Try =AND(B2100,B2<400) in cell C2 of
your example. Then copy it down.

- John

Reply With QuoteReply With Quote