I need to allow either a specific letter (P,D,E, or A) or a number between 1
and 10 (decimals to two places) in a range of cells. I can create one or the
other but not both - HELP?!?

Hi Bettany,

I can think of one way, but there is probably a better one out there.

In the interim, in another sheet you could create this range (which goes to
row 1004) Highlight, name it (insert-name-define) and in your cell that you
want the drop down in, data-validation-list-source is: "=mynamedlist" (minus
the quotations and mynamedlist to be replaced with whatever you named your
range.

hth

BigPig


"betany70" wrote:

I need to allow either a specific letter (P,D,E, or A) or a number between 1
and 10 (decimals to two places) in a range of cells. I can create one or the
other but not both - HELP?!?

Try this Custom Formula in your Data Validation:

=IF(OR(A1="A",A1="D",A1="E",A1="P"),TRUE,IF(AND(A1 1,A1<10,A1*100=INT(A1*100)),TRUE,FALSE))

HTH,
Elkar


"betany70" wrote:

I need to allow either a specific letter (P,D,E, or A) or a number between 1
and 10 (decimals to two places) in a range of cells. I can create one or the
other but not both - HELP?!?