number comparion function

K

kysiow

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
 
M

Max

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.
 
I

iturnrocks

kysiow said:
Hi!;

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

Thanks & Regards
Click to expand...

assuming your 3 numbers are in A1, B1, C1

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