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
- Nov 03 Mon 2008 20:47
geting the smaller number in a line??
close
全站熱搜
留言列表
發表留言