How to conditionally fill a cell in Excel from another cell?

Question

excel

There is a price list with availability, and you need to make sure that the "+" sign in the next cell is put when there are only sizes 42 43 44 (in any order, in any number of sizes, for example 42 42 42 43 44 44). But only if there are 42 43 44, if at least one of them does not exist, so that there is a "-" sign

Answer 1

Insert in cell A1 your text with the available sizes, and in the adjacent cell B1 the following formula:
And in cell C1, C2 and C3 the required sizes (41, 42, 43 in your case)

Answer 2

=IFERROR(IF(SUM(FIND({42;43;44};A1)),"+");"-")
Array formula. Enter by pressing Ctrl+Shift+Enter. A1 - cell with dimensions