Defalt cell content with a formula

  • Thread starter Thread starter Jay3253
  • Start date Start date
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
 
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.
 
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
 
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?
 
Back
Top