tpeters752
New Member
- Joined
- Sep 2, 2002
- Messages
- 2
Here is a sample of what I have and what the correct answer should be. I am trying to use the formula =IF(c2<>" ";c2;IF(b2<>" ";b2;a2))
This message was edited by tpeters752 on 2002-09-03 12:34
Book1.htm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ColumnA | ColumnB | ColumnC | correct | ||
2 | MainSt | AprilSt | AprilSt | |||
3 | ElmSt | BlueSt | BlueSt | |||
4 | OakSt | OakSt | ||||
5 | MapleSt | GreenSt | MaySt | MaySt | ||
Sheet1 |
This message was edited by tpeters752 on 2002-09-03 12:34