The MIN() function

[BNCOXUK]

Hi, I used the MIN() function to get the minimum value of a range. But I found even if the range has all missing values, the MIN() still produces a value of 0. This is not right for me.

I tried to use IF and ISNUMBER() to resolve this problem:

=MIN(IF(ISNUMBER(C1:C10),C1:C10,""))

But this still produces a value of zero.

How can I achieve this goal if a blank missing value is returned by MIN(), if the range has all these missing values?

---------- Post added at 01:58 PM ---------- Previous post was at 01:26 PM ----------

Thanks in advance for help.

[NBVC]

Does this work?

=IF(COUNT(C1:C10)=0,"",MIN(C1:C10))

[BNCOXUK]

It worked. Thanks.

[Cutter]

@ BNCOXUK

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.