| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell only accept dates | Excel Discussion (Misc queries) | |||
| Set cell to only accept 1 character | Setting up and Configuration of Excel | |||
| Can a cell be set to accept input only once? | Excel Worksheet Functions | |||
| Why won't cell accept any formula ? | Excel Discussion (Misc queries) | |||
| Cell to accept checkmark or "x" | New Users to Excel | |||
Linear Mode
