cell value based on null/not null in another cell

I would like to write a formula in cell C23 so that this cell will display as
empty if cell A23 is empty (null) but will pull the value from cell A1 if A23
has a value entered into it. I have spent some time working in Access but my
knowledge of Excel sytax is limited.

Thanks in advance

Assuming that the condition on A23 really is empty (and not, for instance, a
formula whose result is a null string): =if(isblank(a23),"",a1)

"spence" wrote:

> I would like to write a formula in cell C23 so that this cell will display as
> empty if cell A23 is empty (null) but will pull the value from cell A1 if A23
> has a value entered into it. I have spent some time working in Access but my
> knowledge of Excel sytax is limited.
>
> Thanks in advance