Forum Discussion
If cells equal then next returns
Hello, Could someone help me with a formula to produce the below: - If cell A1 has the word “apple” - and then cell B1 has the word “orange” - return the word “fruit” in cell C1 Thanks
Deleted this formula in C1 should work
=IF(AND(B1="orange",A1="apple"),"fruit","not fruit")
Deleted
Use this formula in C1:
=IF(ISNUMBER(SEARCH("apple",A1))*
ISNUMBER(SEARCH("orange",B1)),
"Fruit","Not Fruit")