Do Nothing If Meets Criteria

[Guest]

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

 

[Guest]

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

Dave

 

[Guest]

Thanks, Dave! My criteria is the second part. How can I get warning message
to pop up explaining to the user that the entry is invalid? Can this all be
done from within validation?

Thanks,

Kevin

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

Dave
--
Brevity is the soul of wit.

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