Aug 02 2019 04:03 AM
Aug 02 2019 04:03 AM
Aug 02 2019 04:31 AM
@Deleted
Use this formula in C1:
=IF(ISNUMBER(SEARCH("apple",A1))*
ISNUMBER(SEARCH("orange",B1)),
"Fruit","Not Fruit")
Aug 02 2019 04:34 AM
Solution@Deleted this formula in C1 should work
=IF(AND(B1="orange",A1="apple"),"fruit","not fruit")
Aug 02 2019 12:47 PM
Aug 02 2019 01:40 PM
Aug 02 2019 01:50 PM
Aug 02 2019 02:20 PM
Another formula:
= AND( COUNTIFS( products, {"*apple*";"*orange*"} ) )
This tests whether "apple" is to be found in either cell, returning 0, 1, or 2. Then it tests the second element of the array constant to determine whether "orange" is to be found in neither, one or both, again giving 0, 1, or 2. The AND only returns TRUE if neither element of the resulting array is zero.
A byproduct of such an approach is that
orange juice | pineapple |
returns true irrespective of their order.
Aug 02 2019 04:34 AM
Solution@Deleted this formula in C1 should work
=IF(AND(B1="orange",A1="apple"),"fruit","not fruit")