I want a cell should 2 accept only >=0 or <=30 or Y or N

[Brijesh Poojary]

I want a cell should to accept >=0 or <=30 or Y or N

Regards
Brijesh

 

[ozgrid.com]

=OR(AND(A1>=0,A1<=30),A1="Y",A1="N")

In "Custom" for Data Validation.