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

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

Regards
Brijesh
0
Poojary (1)
4/6/2010 5:29:01 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
430 Views

Similar Articles

[PageSpeed] 48

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

In "Custom" for Data Validation.


-- 
Regards
Dave Hawley
www.ozgrid.com
"Brijesh Poojary" <Brijesh Poojary@discussions.microsoft.com> wrote in 
message news:1F46DC05-D143-407F-BB81-D5D9109914D6@microsoft.com...
>
> I want a cell should to accept >=0 or <=30 or Y or N
>
> Regards
> Brijesh 

0
dave2624 (251)
4/6/2010 5:45:04 AM
Reply:

Similar Artilces: