cell value based on null/not null in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Cell highlighting question 4
Sum a NULL cell 6
Excel formula, sum the value cell and if empty cell left blank 0
If cell not null use that value 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
Conditional Sum Argument results do not equal cell results Excel 3
setting cell values based on a 3rd cell 4
Using NULL in shading cells 1

Back
Top