close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()