conditional validation formula

a conditional validation so that so that when C2 = A1, B1,C1,D1 then the
value of D2 must be greater than 0 but less than or equal to 8 otherwise the
value is 0

this is what I have.

=IF(D2=or(A1,B1,C1,D1), ,0) this is a validation formula
written in D2

How do I write is greater than 0 but less than or equal to 8 in the true
portion of the formula

You can't have data>validation that will validate for greater than 0 and
less than or equal to 8 as input and
allow for zero.. Anyway data>validation for that would look like

=AND(ISNUMBER(MATCH(C2,A1:D1,0)),D2>0,D2<=8)

--
Regards,

Peo Sjoblom


"Larry" <Larry@discussions.microsoft.com> wrote in message
news:430C48D1-5272-4FF8-9A60-5EA612453201@microsoft.com...
>a conditional validation so that so that when C2 = A1, B1,C1,D1 then the
> value of D2 must be greater than 0 but less than or equal to 8 otherwise
> the
> value is 0
>
> this is what I have.
>
> =IF(D2=or(A1,B1,C1,D1), ,0) this is a validation formula
> written in D2
>
> How do I write is greater than 0 but less than or equal to 8 in the true
> portion of the formula