Thread: I want a cell should 2 accept only =0 or <=30 or Y or N
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default I want a cell should 2 accept only =0 or <=30 or Y or N
=OR(AND(A1=0,A1<=30),A1="Y",A1="N")

In "Custom" for Data Validation.


--
Regards
Dave Hawley
www.ozgrid.com
"Brijesh Poojary" <Brijesh wrote in
message ...

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

Regards
Brijesh

Reply With QuoteReply With Quote