conditional validation formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Larry" <Larry@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Apr 2005 18:45:01 -0700

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
.

Follow-Ups:
- Re: conditional validation formula
  - From: Peo Sjoblom

Prev by Date: Re: cumipmt
Next by Date: sum if
Previous by thread: how can I get all worksheets to print at one time?
Next by thread: Re: conditional validation formula
Index(es):
- Date
- Thread