Forum Discussion
Change a value in a cell only if such a cell is empty
Hello, I have a "trivial" problem with excel. Let "A1" be an empty cell. I would like that: - if "A1 is empty", then "A1 = value", otherwise "A1 remains empty" I have tried as follows: =IF(ISBLAN...
Hi Ennio,
you can only solve this using a macro, which would replace empty cell with a certain value. A formula in A1 referring to itself will result in the circular reference error
Yury