ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   geting the smaller number in a line?? (https://www.excelbanter.com/excel-discussion-misc-queries/62082-geting-smaller-number-line.html)

Felipe

geting the smaller number in a line??
 
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. R.Ramachandran

geting the smaller number in a line??
 
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

"Felipe" wrote:

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


Chip Pearson

geting the smaller number in a line??
 
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


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





All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com