Data validation, alpha or numeric characters
 

I need to enter either the letters "nd" in a cell, or a numeric range of
less that 5.0. Can this be done with validation? If not "nd" or <5,
then I would like spreadsheet to pop up the "stop" box.

Please help!!!

Thanks!!!


--
tsammons
------------------------------------------------------------------------
tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335
View this thread: http://www.excelforum.com/showthread...hreadid=499996

Data validation, alpha or numeric characters
 

If you only want "nd" or the integers between 1 and 4, inclusive:
DataValidation
Allow: List
Source: nd,1,2,3,4

Alternatively, If you only want "nd" or any numeric value less that 5,
try this:
DataValidation
Allow: Custom
Formula: =or(A1="nd",A1<5)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499996

Data validation, alpha or numeric characters
 

One way ..

Assume inputs would be made in col A, A1 down

Select col A
Click Data Validation
Select Custom under "Allow"
Put as the "Formula:"
=OR(A1<5,A1="nd")
Click OK

Test it out ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"tsammons" wrote in
message ...

I need to enter either the letters "nd" in a cell, or a numeric range of
less that 5.0. Can this be done with validation? If not "nd" or <5,
then I would like spreadsheet to pop up the "stop" box.

Please help!!!

Thanks!!!


--
tsammons
------------------------------------------------------------------------
tsammons's Profile:
http://www.excelforum.com/member.php...o&userid=30335
View this thread: http://www.excelforum.com/showthread...hreadid=499996

Data validation, alpha or numeric characters
 

Thank you soooo much . . . this worked.


--
tsammons
------------------------------------------------------------------------
tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335
View this thread: http://www.excelforum.com/showthread...hreadid=499996

Data validation, alpha or numeric characters
 

You're welcome (from us) !
Believe Ron arrived fractionally ahead (1 min? <g),
and provided a more comprehensive response with 2 options
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"tsammons" wrote in
message ...

Thank you soooo much . . . this worked.