| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
You can't have datavalidation that will validate for greater than 0 and
less than or equal to 8 as input and allow for zero.. Anyway datavalidation for that would look like =AND(ISNUMBER(MATCH(C2,A1:D1,0)),D20,D2<=8) -- Regards, Peo Sjoblom "Larry" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula for conditional concatenating? | Excel Worksheet Functions | |||
| IF, AND, OR Conditional formula? | Excel Worksheet Functions | |||
| How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel | |||
| conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
| How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
Linear Mode
