Thread: Function that determines whether a number is between two numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrShorty
 
Posts: n/a
Default Function that determines whether a number is between two numbers

=and(num1<cell,cell<num2). note that if cell=num1 or cell=num2 it will
return false. It also only works if num1<num2.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=518550

Reply With QuoteReply With Quote