Forum Home
Press F1
 
Thread ID: 5265 2000-08-09 08:38:00 If a cell has certain text, display this in another Guest (0) Press F1
Post ID Timestamp Content User
5810 2000-08-09 08:38:00 If a cell has certain text, display this in another

I would like to display some text in cell A2, that is conditional on certain text being entered in cell A1

If A1 has either of the following text entered
Cow
Sheep
Goat
Horse
Bull

How do I get cell A2 to diaplay Grass

Ok, Im not into livestock, but the ideal is still the same.

Thanks in anticipation.....John
Guest (0)
1