Does anyone know if I can do this...

I have a column of values that I would like to find the average of,
but
some of the cells contain numbers with a < in front of them.
The average should use 1/2 the value of the numbers with < in front of
them.

Thanks in advance for your help!

Colleen