| 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 |
| 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 | |||
Threaded Mode
