I have the numbers 1-8 in a column, one in each cell. When I try to find the minimum or maximum by using =MIN(A2:A9) it simply returns 0. This is also true when I try it with MAX. Am I doing something wrong?
1 | =MIN(A2:A9) Result:0 |
2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 |
MacBook Pro, Mac OS X (10.7)
Make sure the column with 1 - 8 is formatted as "automoatic" or a number
Thanks, I checked and it was automatic, I changed it to number, it still doesn't work.
It must have something to do with how the data got there. I am using the formula =IF(D31>-1,IF(D31<6,"1","")) to return a 1 to the cell A2 and =IF(D31>-1,IF(D31<6,"2","")) to return a 2 to A3 and so on...
If I just type in 1, 2, 3, 4, 5, 6, 7, 8 the MIN formula works, so I am guessing the above mentioned formula is messing with it. Any ideas on how to fix this problem?
Yes this is important information....
You formula returns a non-numeric result when it returns "".
Can you share what you are trying to do? This will help guide the response.
Wayne
R,
1 is a number.
"1" is a string.
The MIN of a range of strings is 0, as is the MAX.
To fix your problem, take the quotes out of your expressions.
Jerry
MIN and MAX Formulas returning 0
