Re: conditional validation 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:430C48D1-5272-4FF8-9A60-5EA612453201@xxxxxxxxxxxxxxxx
>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


.

Relevant Pages

  • Reg exp question
    ... I'm trying to validate a number field that has to be exactly six digits and ... cannot start with a zero: ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Reg exp question
    ... > I'm trying to validate a number field that has to be exactly six digits ... > cannot start with a zero: ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Marquee For Firefox
    ... This poster - zero ... being hard or impossible to validate, ... think the idea is you just make your own DTD which includes marquee, ... which doesn't look at the DTD qua a DTD at all. ...
    (alt.html)
  • Identity crisis
    ... But, when I switch to the other identity, I show zero names in that contact ... although I am sharing an ... Chris ... Prev by Date: ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: including . in a pattern match
    ... > zero or one decimal point followed by ... Is no whole-number portion an ... one or more digits, possibly followed by a decimal and one or more ...
    (perl.beginners)