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".
I'm trying to find a way to return "No Measurement" if the cells in that range are blank.