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
Num1lt;Celllt;Num2, if anyone can help I'd very much appreciate it.
Thanks.--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile: www.excelforum.com/member.php...oamp;userid=32099
View this thread: www.excelforum.com/showthread...hreadid=518550
=and(num1lt;cell,celllt;num2). note that if cell=num1 or cell=num2 it will
return false. It also only works if num1lt;num2.--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: www.excelforum.com/member.php...oamp;userid=22181
View this thread: www.excelforum.com/showthread...hreadid=518550
Thanks!! --
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile: www.excelforum.com/member.php...oamp;userid=32099
View this thread: www.excelforum.com/showthread...hreadid=518550
文章標籤
全站熱搜
