Custom Validation

K

kalz

my validation criterias for the cell are:
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!
 
P

Peo Sjoblom

=AND(MOD(A1,4)=0,A1>100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top