Hi,
I am trying to include an OR function within an IF function that reads non-numeric values from a cell, and produces a value_if_true/false depending on the non-numeric values from a specific cell are. Not the best explanation... I know, but here's an example:
if(A2="apple" OR "oranges",1,2)
If the word "apple" or "orange" is found in cell A2, return the value=1.
If a word different from "apple" or "orange" is found in cell A2, return the value=2.
Thanks![]()
Bookmarks