cell value based on null/not null in another cell

S

spence

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
 
B

bpeltzer

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)
 
Top