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