Data Validation

E

Eintsein_mc2

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
 
K

Ken Johnson

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

Eintsein_mc2

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
 
K

Ken Johnson

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
 
E

Eintsein_mc2

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