So I took away the negativity and added B4=0, reversed the outcomes and that
does exactly what I want.

Thanks for everyone's valuable help.

"WLMPilot" wrote:

Formual for C4:

=IF(OR(B4<"stock",B4<"np",B4<"ff",B4<""),"pc", "")
.......