If either condition is FALSE, the formula returns FALSE.
The test for multiple words is done using the SEARCH function with help from COUNT.
When a match is found, SEARCH returns the position of the match.
When no match is found, SEARCH returns the #VALUE error.
The COUNT function gets a count of numbers in the array returned by SEARCH.
COUNT ignores errors by default.
Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers.
SEARCH returns the position offind_textinsidewithin_textas a number.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
The AND function is commonly used with other…
