Data Validation on Cells

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

Guest

How can I restraint the user from entering odd numbers in the cell?( but I need the outcome to be in multiples of 5).
Thanks.


Ringo Tan
 
Hi

select the cell that you want to put the validation on and choose
data / validation
choose custom and type in the formula box
=AND(MOD(A1,5)=0,MOD(A1,2)=0)
where A1 is the current cell
copy & paste special - validation as necessary

Cheers
julied

ringo tan said:
How can I restraint the user from entering odd numbers in the cell?( but I
Click to expand...
need the outcome to be in multiples of 5).
 
Back
Top