Forum Discussion
Hide a formula
Oh! I just realized the simplest solution. So long as I'm correct that the original situation was that the formula, per se, is hidden and it's only the hardcoded "California" that is appearing.
Just make the result visible only after A1 and B1 have content in them, using an IF condition.
=IF(AND(A1="",B1=""),"",A1&"California"&B1)
This will keep C1 blank until entries are made in A1 and B1.
Depending on what goes into A1 and B1, assuming they're text fields of some kind, you might want to put spaces before and after the word "California"
=IF(AND(A1="",B1=""),"",A1&" California "&B1)
How about this, then, as a solution: Use a cell off to the side (or on a different tab) to do the concatenation involved in the formula =A1&"California",&B1.
Let's say it's cell Z1
Then in C1, protected, just have the entry =Z1
And column Z can be hidden from sight altogether, just by being way off to the side, or highlight the column and select "Hide"
Oh! I just realized the simplest solution. So long as I'm correct that the original situation was that the formula, per se, is hidden and it's only the hardcoded "California" that is appearing.
Just make the result visible only after A1 and B1 have content in them, using an IF condition.
=IF(AND(A1="",B1=""),"",A1&"California"&B1)
This will keep C1 blank until entries are made in A1 and B1.
Depending on what goes into A1 and B1, assuming they're text fields of some kind, you might want to put spaces before and after the word "California"
=IF(AND(A1="",B1=""),"",A1&" California "&B1)
- Oh that’s exactly what I wanted. It worked seamlessly. Thanks a lot! Really appreciate it.
Thanks
