=if(count(a:a)=0,"<2",max(a:a))

Pete wrote:

I have a column of data that I am trying to manipulate, I'm not sure which
formula to use. My column has "<2" in every cell. But if a number, say 5,
appears, it has to select the highest number. Otherwise, it stays at <2

--

Dave Peterson