Try squaring the numbers before comparing them. This will eliminate the
negative issue, assuming you want the value closest to zero.
=a6^2<a8^2 should meet your needs regardless of positive or negative
values.
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=399121