Nov 18 2021 10:42 AM
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.
Nov 18 2021 10:59 AM
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.
Nov 18 2021 11:57 AM