Thread: Data Validation
View Single Post
  #2   Report Post  
Sandy Mann
 
Posts: n/a
Default

Try:

=AND($F$21<"",OR(MOD($F$21,84)=0,MOD($F$21,61)=0) )

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Eintsein_mc2" wrote in message
oups.com...
Hi Ken, I tried it and now it dosnt matter what figure I put into the
cell it comes up with an alert. Thanks for trying