possible "or" function?

D

DangerMouse114

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
 
N

Norman Harker

Hi!

Frank's reply looks OK to me:

=IF(A1="","Open 8",A1)
in cell B1



--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
D

DangerMouse114

Sorry never saw that. But there is a problem with that. A-1 could b
anynumber or things. I maybe wrong but if you use that formula th
first " " would have to have what ever you expect might show up in A1
So it would work if A1 had only one possible data entry expected t
possibly be there.

any sugestions
 
S

Steve Garman

Have you tried Frank's suggestion? It does exactly what you asked for.

If that's not what you wanted then you'll have to explain your needs again.

By the way, Frank's formula makes no mention of "A-1" and it makes no
assumptions about what is in cell A1.
 
Top