Forum Discussion

Ennio Condoleo's avatar
Ennio Condoleo
Copper Contributor
Aug 14, 2017

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

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

 

Thanks in advance

excel

1 Reply

Sort By
  • Yury Tokarev's avatar
    Yury Tokarev
    Steel Contributor
    Aug 14, 2017

    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

Resources