Function that determines whether a number is between two numbers
 

Hopefully this is a pretty simple one, I am looking for a function that
will return TRUE or FALSE if a number in a cell is between two
specificied numbers, since unfortunately, Excel doesn't like
Num1<Cell<Num2, if anyone can help I'd very much appreciate it.
Thanks.


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

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

Function that determines whether a number is between two numbers
 

Thanks!! :)


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