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

Brijesh Poojary · Apr 6, 2010

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

Regards
Brijesh

ozgrid.com · Apr 6, 2010

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

In "Custom" for Data Validation.

If percentage is 10% when y or 0% when n	6	Jan 31, 2009
How can I stop a formula from executing based on a cell value?	4	Oct 5, 2008
If all cells in a range are N/A, then N/A?	3	Nov 10, 2006
IF Statement	2	Jun 9, 2009
Counting with Date Range as Criteria	5	Oct 16, 2009
Time sheet validation	2	Oct 31, 2008
How do you restrict a cell to accepting only "Y" or "N" ?	2	Dec 20, 2007
to reconise Y or N with a colour ?	3	Jul 13, 2005

Ask a Question