cell value based on null/not null in another cell

G

Guest

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If cell not null use that value 1
Sum a NULL cell 6
Conditional Sum Argument results do not equal cell results Excel 3
Cell highlighting question 4
setting cell values based on a 3rd cell 4
cell reference show cell name (ie. D45) and not cell value 4
If null, make cell blank 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top