Data Validation - restricted entry

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

Guest

Dear Sir

I want to restrict the users from entering values other than multiples of 100 in cell A1; need help!
 
Hi

Try this:

=A1/100=INT(A1/100)

Andy.

Sachin Wagh said:
Dear Sir,

I want to restrict the users from entering values other than multiples of
Click to expand...
100 in cell A1; need help!
 
Hi
select cell A1 and goto the data validation dialog and enter the
formula
=MOD(A1,100)=0
 
Back
Top