Is it possible to have a formula somehow on cell A1 that checks as a conditional if A1 is empty?

Obviously, the default way I'm getting a circular dependency error. However, I figure some formula might be (?) smart enough to see that when A1 is in the conditional (and not a part of the new value) it's not really a circular dependency after all.

So does a function like this exist?

Basically: if cell itself is empty -> fill it, otherwise do nothing

  • Welcome to Web Applications Geert-Jan, I think your question is a duplicate of the one I just added. Sep 8 '14 at 7:50
  • @JacobJanTuinstra: not quite. Given your answer to that question I'm trying to assign =IF(ISBLANK(A1)=TRUE,"Blank cell","Not blank") to A1. Obviously assigning it to any other cell would work.
    – Geert-Jan
    Sep 8 '14 at 8:51
  • 1
    Ok, no dup. but would you accept no for an answer? That's not possible. Sep 8 '14 at 8:58
  • @JacobJanTuinstra: yup I accept it ;) Just wanted to confirm. thanks
    – Geert-Jan
    Sep 8 '14 at 9:06

For plain old formula's, that's not possible, simply because it will create a circular dependency.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.