Not using blank cells in a IF & MIN statement

  • Please see attachment. ozgrid.com/forum/core/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".


    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

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