I would like b1 to state "Open 8", but only if the cell above it (a1
does not have any text in it. A1 only gets used some of the time bu
when it does I would like B1 to show what A1 shows, if A1 has nothin
then the text "open 8" should. Is this an "or" function or an "if"? an
how would i place the formula correctly?
Thanks again!
Eri
--
Message posted from
http://www.ExcelForum.com