IF function question


This is what I'm trying to do:
If the cell in column F is blank, replace the cell with the contents of the cell from column E, otherwise leave column F as is.
I tried =IF(F2="",E2,F2)
This give me errors.

2 Replies


You cannot do that with a formula in column F, it leads to circular references.

The easiest option is to place the formula =IF(F2="",E2,F2) in cell G2 and fill down.

The alternative would require VBA code, but that seems overkill here.

I did this and it worked. Thank you. Once I did this for column G, I had to do a Copy and Paste "values" in column G before I could delete colum F and have it automatically relaced by column G.
Thanks again.