| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change line in Chart | Charts and Charting in Excel | |||
| Superscript of 1 number changes line height--losing top of charac. | Excel Discussion (Misc queries) | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How can I asign a number value to a text line in Excel? | Charts and Charting in Excel | |||
Linear Mode
