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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - I want a cell should 2 accept only =0 or <=30 or Y or N (https://www.excelbanter.com/new-users-excel/260759-i-want-cell-should-2-accept-only-%3D0-%3D30-y-n.html)

Brijesh Poojary

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

ozgrid.com

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

All times are GMT +1. The time now is 02:00 AM.