Prevent specific text being entered into a cell

[benjinorth]

Is there a way I can prevent users being able to enter the text "N/A" or "None" into certain cells using data validation?

in cell A1 is "What is the name of your current employer?"
in cell A2 is a blank cell where the user would answer.

If they are unemployed I don't want N/A or None being input, just to be left blank.

The formula I have in Cell A2 is (I've entered this under custom in data validation)
=IF(A2="n/a","",IF(A2="none",""))

An error message would then appear when invalid data is entered ("n/a" or "none" being invalid data) stating that "if unemployed please leave this cell blank"

The problem I have is that any value I enter flags the error message.
I'm fully aware that my formula is probably flawed.

Am I close?
Can anyone help me find a solution?

Thank you

 

[Joe4]

Try:

=and(a2<>"n/a",a2<>"none")

 

[benjinorth]

Perfect thank you!!

 

[Joe4]

You are welcome!