How do I calculate the average, minimum, and maximum of a column of numbers
containing less than (<1) values and also some cells are empty? I want the
less than values to be calculated as zeros when averaging and the minimum
values to say <1 if it is the minimum. Example:

2
3
4

<1
<1
5

<1
4
<1

In this example the maximum is 5, the minimum is <1, and the average should
be 2.

Thanks
--
JD