Dave Peterson Wrote:
=if(and(a129.7,a1<30.3),"between","not between")
or
=if(and(29.7<a1,a1<30.3),"between","not between")

I think I like the second one. It kind of looks like A1 should be
trapped
between the two values.

Dave Peterson

Dave is into bondage? All righty, then. It gets the job done.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468308