The last part of your formula is a circular statement, Ent. You can't have X9 look for the value in X9 and return it.The format for the if statement is
=If(Condition, Response if true, Response if false)
I would put this in X9
=If(T9="yes", "", value currently in X9)
I wouldn't have the reference X9, but the value that is currently in X9.The last part of your formula is a circular statement, Ent. You can't have X9 look for the value in X9 and return it.
So the first half is fine, but for the latter you need a different value - "no" - for instance.
Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.
If you're not already familiar with forums, watch our Welcome Guide to get started.
Join over 807,865 other people just like you!