=IF(C5="*MDF*","",[your criteria])

Dave
--
Brevity is the soul of wit.


"kmwhitt" wrote:

I have a cell that I would like the user to be able to enter text into only
if another cell contains the word "MDF". I would like to do this with
validation.

Here is what I have tried:

=IF(COUNTIF(C5,"*MDF*")0,0,€œ €œ)

I would like the formula to do nothing if the word "MDF" is in C5, if not I
want it to clear the cell thus the blank space.

Any suggestions?

Thanks,

Kevin