Aug 14 2017 04:22 AM
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
Aug 14 2017 05:04 AM
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