Thanks Bob, that’s thinking outside the box. Now I’d like to swap out
the 7 with a cell reference. Such that
=IF(COUNTIF(A1:A100,"<E5"),"yes","no") but that's not working.

Example: if(or(E5A1, E5A2, E5A3, …, E5A100), “yes”, “no”)