Custom Validation

[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!

[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)



"kalz" <[email protected]> wrote in message
news:[email protected]...
> 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!