1

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

|improve this question
  • Welcome to Web Applications Geert-Jan, I think your question is a duplicate of the one I just added. – Jacob Jan Tuinstra 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. – Jacob Jan Tuinstra Sep 8 '14 at 8:58
  • @JacobJanTuinstra: yup I accept it ;) Just wanted to confirm. thanks – Geert-Jan Sep 8 '14 at 9:06
1

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

|improve this answer

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.