Change a value in a cell only if such a cell is empty

[Ennio Condoleo]

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(ISBLANK(A1);"any_value";"")

but this is not working, because an error due to the circular reference appears.

Thanks in advance

[#2]

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