Formula for multi answers [Closed]


I'm not yet a member, first time user, however interested to be registered as soon.

Hi looking for the right formula for the following.

a b c d e f
SM-YANG L0297 SOLD SOLD 26-Feb-17 = answ

If C has a "$ value (e.g.$200) F will show text "available", but if C has text "Sold" or "On hold" or "Under offer", F will show same text.

thank you