I need to fill a cell with the smaller number in a line, but I can't find a
funcition to do so. thank
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
quot;Felipequot; wrote:
gt; I need to fill a cell with the smaller number in a line, but I can't find a
gt; funcition to do so. thank
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.comquot;Felipequot; gt; wrote in message
...
gt;I need to fill a cell with the smaller number in a line, but I
gt;can't find a
gt; funcition to do so. thank
funcition to do so. thank
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
quot;Felipequot; wrote:
gt; I need to fill a cell with the smaller number in a line, but I can't find a
gt; funcition to do so. thank
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.comquot;Felipequot; gt; wrote in message
...
gt;I need to fill a cell with the smaller number in a line, but I
gt;can't find a
gt; funcition to do so. thank
文章標籤
全站熱搜
