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