Formula to Count and Return a certain message (If possible)

We have a sales analysis that includes a stock count of the SKUs. I wanted to have a formula that could look at the SKUs and determine if the line 2 sizes that have 0 stock then that line is labelled as 'Fragmented Stock' in the Stock Position column.

Is there a way to do this or even something relatively similar? It's so we can easier look at lines that a fragmented to push shop by size messaging instead of manually checking everything.

Reattached document with examples of what I'd imagine this to look like.

Thanks