Formula Error

[ringo tan]

Dear Leo Heuser,

I have enter your formula =(A1>0)*(MOD(A1,10)=0) but why is it that when I
enter 10 or 20 in the cell, excel disallowed me? I need only to restraint
user from entering odd numbers in the cell, that means allow even numbers but
these even numbers must be in multiples of 5?

Thank you.
Ringo Tan

 

[Leo Heuser]

Dear Leo Heuser,

I have enter your formula =(A1>0)*(MOD(A1,10)=0) but why is it that when I
enter 10 or 20 in the cell, excel disallowed me? I need only to restraint
user from entering odd numbers in the cell, that means allow even numbers but
these even numbers must be in multiples of 5?

Dear Ringo Tan

I can't replicate this behaviour. I can enter 10, 20, 30 etc.
as requested!?

You are welcome to attach a copy of the offending workbook
to a personal mail (remove NOSPAM from my e-mail address),
and I'll take a look at it.

Please remain in the same thread. It was quite by chance,
that I saw your posting!

 

[ringo tan]

Dear Leo Heuser,

Thanks for your kind assistance
Anyway whats your personal email address?


Ringo Tan

 

[Leo Heuser]

leo.heuser then @ then adslhome.dk

Can't you get it from your newsreader?

LeoH