​​ ​

The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.


You can continue to find trusted guidance and support on the official Apple Support site. 


We want to thank the community members who have contributed their time and expertise to help others with their Apple products.


MIN and MAX Formulas returning 0

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)

Posted on Aug 3, 2011 11:42 AM

5 replies

Aug 3, 2011 2:17 PM in response to Rome_GA

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?

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

MIN and MAX Formulas returning 0

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.