kysiow Wrote:
Hi!;

I have 3 numbers key in 3 different cells I would like to do the
number
comparison. The smallest number will auto display on new cell. If I
want to
do this kind of job, what function should I to use and how to do it.

Thanks & Regards

assuming your 3 numbers are in A1, B1, C1

=IF(AND(A1<B1,A1<C1),A1,IF(AND(B1<A1,B1<C1),B1,C1) )


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570229