![]() |
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 |
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 |
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