 # Not using blank cells in a IF & MIN statement

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".

Code
1. =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

## Files

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

Maybe :cool:

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

Bruce :cool:

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

Quote from skywriter;772277

Maybe :cool:

Code
1. =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.

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

My pleasure, thanks for the feedback. :cool:

Bruce :cool: