Not using blank cells in a IF & MIN statement

Please see attachment. forum.ozgrid.com/index.php?attachment/69373/

This is what i am attempting to do.

If the Minimum number, in B3:B8, is <= 0.09 then return "Below Detection"
If the Minimum number, in B3:B8, is > 0.09 then return the Minimum number.

This works until B3:B8 is left empty, when this occurs it returns "Below Detection".

=IF(MIN(B3:B8)<=0.09,"Below Detection",(MIN(B3:B8)))

I'm trying to find a way to return "No Measurement" if the cells in that range are blank.

Thanks

cmbonner

Re: Not using blank cells in a IF &amp; MIN statement

Quote from skywriter;772277

Maybe :cool:

Code

=IF(COUNTBLANK(B3:B8)=6,"No Measurement",IF(MIN(B3:B8)<=0.09,"Below Detection",(MIN(B3:B8))))

Thanks a ton!

I tried and googled all day yesterday and never saw the COUNTBLANK function.