Data Validation
 

Hi, I have a data validation formula that works fine when figures in
multiples 84 are entered into the cell and if not gives an error. But I
need to rewrite it so it can also work if the figure is in multiples of
61 as well as 84. This is what I have:
=MOD(F21,84)=0
Any help would be great. Thanks

Hi Eintsein,
will =AND(MOD(F21,61)=0,MOD(F21,84)=0) do what you want?
Ken Johnson

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

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

Eintsein,
when you said "multiples of 61 as well as 84" I took that to be 61 and
84 at the same time when I should have interpreted it to mean 61 or 84.
I assume Sandy's solution has worked for you.
Ken Johnson

Thanks Sandy, your solution did work. I'm most appreciative that both
you Guys took the time to post a solution. Cheers