Formula Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
ringo tan said:
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?
Click to expand...
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!
 
Dear Leo Heuser,

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


Ringo Tan
 
Back
Top