| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Min function with cells in a Row returns incorrect result.
I have some values in a row like (A5:G5)
0.0035,0.0038,0.0029,0.0038,0.0022,0.0038,0.0038. In cell A8 I have formula =Min(A5:G5) and it gives me values 0.0038 instead of 0.0022. I am using Excel 2003. I have tried checking the format of the cells copying psting to a new work boomas values but no help In have even tried =Min(Transpose(A5:G5)) but no help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate creating list that returns blank cells | Excel Worksheet Functions | |||
| Function to look at two cells and return a third | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Threaded Mode
