Hello all,
I have a feeling that this is going to be an easy (ish) question, so posted in the new users section.
i am wanting to define the content of a cell, dependant on what exists in another cell.
in simple terms,
i want cell A1 to display 'Fruit' if cell A2 contains 'Apple', 'Banana', or 'Grape'.
cell A1 should display 'Vegetable' if cell A2 contains 'Potato', 'Carrot', or 'Swede'.
cell A2 can contain more than one value, but only fruit OR veg - ie could contain "Banana Apple", but not "Potato Grape".
so far I have this simple formula, in cell A1
=(IF(A2 = "APPLE", "FRUIT", "VEGETABLE"))
but this does not cater for anything much.
Any help would be greatly appreciated.
Thanks, Mark
Bookmarks