Forum Discussion
Any way to have conditional default value in a cell while also can set the cell value manually
I want to have a cell being filled with some default value depending on another cell value. - This is the easy part. Meanwhile I want to have the capability to set the cell value arbitrarily in a ...
weikun ,
There's nothing stopping you overwriting the formula with an arbitrary value in a manual way.
So if cell B1 contained the formula:
=IF(A1="","Write your given name in A1 and last name here","Write your last name here")You would initially see:
And once you'd entered something in A1, it would change to
And then you could fill in cell B1
The problem is, the text entered in B1 has overwritten the formula, and if you want the prompt back, you'll have to retype the whole formula again - there is no way of having the default formula restored unless you enable the spreadsheet for macros and write a macro - the one found here would do the job