Cell that contains formula but needs to allow text as well

[DoubleZ]

I have cells in columns F-K that each ahave an IF formula that makes them
blank if the cell in Column E has a "no" in it. Situationally, I need to be
able to write an "x" in some of the boxes if Column E has a "yes" in it. My
problem is this: If I type "yes" in column E and type some "x's" in Columns
F-K and later change my mind and write "no" in column E, then the "x's"
remain because the IF formulas are not erased. Is it possible to make the
formulas remain and allow text at the same time? Do I need a macro for this?

 

[Gord Dibben]

You can either have a formula or manually entered data in a
cell..................not both.

Try this in F1

=IF(E1="no","",IF(E1="yes","X","neither"))


Gord Dibben MS Excel MVP