negative and positive outcomes

Hello, Goodmorning

In my sheet i got some negative and positive numbers -210(Negative) and 210(positive).

So when on F there is a Negative number on K must come (Yes).
and when on F there is a positive number on K must come (NO)
it must go on for all on F
Is there function for that in Excel what i got now

Please Login or Register  to view this content.

Greets,

Shima

If(F <0,"Yes","no")

Please Login or Register  to view this content.

okeey on the row it works now..
but how can i put in like it will do all of F?

because i got more numbers under it?
like this i think?

Please Login or Register  to view this content.