Hi Soniya

One way:

=OR(MOD(A1,10)=0,MOD(A1,15)=0)*(A1<0)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Soniya" skrev i en meddelelse
...
Hi all,

I have this formula in data validation from an answer to
my prev question to allow entry of either muliples of 10
or 15.
=OR(MOD(A1,10)=0,MOD(A1,15)=0)

Now I would like to prevent 0 also in this range?

Ho can I modify the formulae?

TIA
Soniya