Questions on how to write formulas using Arrayformula, IFS, and FIND functions in Google spreadsheets

IFS is not used, but it can be achieved using the following formula:

=ARRAYFORMULA(IF(ISERR(FIND("Apple", A1:A))), IF(ISERR(FIND("Banana", A1:A))), IF(ISERR(FIND("Mikan", A1:A))), ", 3), 2))

FIND returns #VALUE! when no string is found, so we used ISERR for error determination.

I have never used IFS, so I used IF.

The finished ceremony is long and difficult to correct.
If you want to add or change features, it may be easier to recreate them, so I'll show you how to create them.

An expression that returns a given value if the string is found, or 999 if it is not found.

=IF(ISERR(FIND("Apple", A1)), 999, 1)
= IF(ISERR(FIND("Banana", A1)), 999, 2)
= IF(ISERR(FIND("Tangerine", A1)),999,3)

Replace the first expression 999 with the following expression:

=IF(ISERR(FIND("Apple", A1)), IF(ISERR(FIND("Banana", A1)), 999, 2), 1)

Returns a given value if the desired string is found, or returns the result of the built-in expression.

In the same way, incorporate the following formula:

=IF(ISERR(FIND("Apple", A1)), IF(ISERR(FIND("Banana", A1)), IF(ISERR(FIND("Mikan", A1)), 999, 3), 2)

Apply ARRAYFORMULA().

=ARRAYFORMULA(IF(ISERR(FIND("Apple", A1)), IF(ISERR(FIND("Banana", A1)), IF(ISERR(FIND("Mikan", A1)), 999, 3), 2))

Set the coverage to all cells in column A.< Replace A1 with A1:A.

=ARRAYFORMULA(IF(ISERR(FIND("Apple", A1:A))), IF(ISERR(FIND("Banana", A1:A))), IF(ISERR(FIND("Mikan", A1:A))), 999, 3), 2))

Replace 999 with an empty string.That's it.

=ARRAYFORMULA(IF(ISERR(FIND("Apple", A1:A))), IF(ISERR(FIND("Banana", A1:A))), IF(ISERR(FIND("Mikan", A1:A))), ", 3), 2))