IF funtion question

E

escelnewbie

My situation is this: If the cell is empty then pick a name from a dro
down list from another cell, but if it is not blank then leave curren
data alone. The first part is easy enough IF(A1="", C1, ?) but th
second part I cannot figure out with the cell referencing itself an
giving error.
Can anyone help
 
S

Spencer101

escelnewbie;1609074 said:
My situation is this: If the cell is empty then pick a name from a dro
down list from another cell, but if it is not blank then leave curren
data alone. The first part is easy enough IF(A1="", C1, ?) but th
second part I cannot figure out with the cell referencing itself an
giving error.
Can anyone help.

I'm not sure what it is you're actually trying to do here. Which cel
are you putting that formula in?

Perhaps you could post an example workbook to make things clearer
 

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

Top