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

Assume data will be entered in cols A to C, from row1 down

Then we could place in D1:
=IF(COUNT(A1:C1)<3,"",MIN(A1:C1))
and copy D1 down

Col D will return the minimum of the 3 numbers entered in cols A to C. Col D
will remain "blank" until the 3 numbers for each row is fully entered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

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