Defalt cell content with a formula

J

Jay3253

I would like to give a cell with a formula in it a defalt value.

ex: if cell E1 had the following equation

=if(A1="No",B1,C1) where the default value is instructions or a word.

Also how do I give a cell a default value if you can input any value?

Thank you
Jaso
 
F

Frank Kabel

Hi Jason
not quite sure what you want to achieve. If you have entered a formula
you'll get this formula result. In your case cell contents from either
B1 or C1.
 
J

Jay3253

I would like it to have a certain word in the cell everytine it i
opened. Like "Input date in B1" or give information. I want to d
this so they have to input new date every time they open the sheet an
not use what was there before
 
F

Frank Kabel

Hi
for this you'll need (IMHO) VBA. e.g. put some code in the
workbook_open event. But reading your previous post what should happen
to the formula in this cell?
 
Top