How do I look to see if another cell contains something
Posted by andrew miller on January 04, 2002 6:46 AM
I'm writing "if" statements. I know how to do "if a cell = something,then enter a certain value", but is there any way to say "if a cell contains a certain word, then place a certain value. For instance a column may have either "exterior wall" or "interior wall" entered, but all I'm interested in is the word "wall". Is there any way to just look to see if a cell contains the word "wall", instead of = "wall". Thanks.