Data validation, alpha or numeric characters

[tsammons]

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!!!

[Ron Coderre]

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

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

Does that help?

Regards,
Ron

[Max]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[tsammons]

Thank you soooo much . . . this worked.

[Max]

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" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you soooo much . . . this worked.