COUNTTEXT

=IF(COUNTIF(E2,"*down for*"),"Down","Up")

=IF(COUNTIF(F3,"*down for*"),"Down","Up")