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.
Click to expand...

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
 
Top