geting the smaller number in a line??

F

Felipe

I need to fill a cell with the smaller number in a line, but I can't find a
funcition to do so. thank
 
B

B. R.Ramachandran

Hi,

If, for example, the numbers are in A1, B1, ...., X1, enter the following
formula in Y1 (or any other convenient location).
=MIN(A1:X1)

Regards,
B. R. Ramachandran
 
C

Chip Pearson

Perhaps the MIN function is what you want. E.g.,

=MIN(A1:L1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top