Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Validation
my validation criterias for the cell a
input must be divisble to 4 and larger than 100 I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one cell. Would anyone know the way to fulfill both? thx! |
#2
|
|||
|
|||
=AND(MOD(A1,4)=0,A1100)
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "kalz" wrote in message ... my validation criterias for the cell a input must be divisble to 4 and larger than 100 I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one cell. Would anyone know the way to fulfill both? thx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom validation | Excel Discussion (Misc queries) | |||
Custom Format and Data Validation Q | Excel Worksheet Functions | |||
custom validation | Excel Worksheet Functions | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |