Running calculations with < in Excel

My day job is as a building scientist, I help people understand the impact that the built environment has on their health, well-being and productivity through data driven consulting. This means that I often conduct environmental quality testing to establish concentrations of pollutants in the air, in water, in materials or on surfaces. Without going into too much detail, when a result is obtained from our in-house lab or an external lab often the result is below the detection limit […]

Continue Reading