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

  • Thread starter Thread starter Brijesh Poojary
  • Start date Start date
B

Brijesh Poojary

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

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

In "Custom" for Data Validation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement 2
How can I stop a formula from executing based on a cell value? 4
If percentage is 10% when y or 0% when n 6
If all cells in a range are N/A, then N/A? 3
Counting with Date Range as Criteria 5
validation - conditional format 4
Time sheet validation 2
to reconise Y or N with a colour ? 3

Back
Top