Data Validation on Cells

R

ringo tan

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
 
J

JulieD

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation on Cells 2
Data Validation on Numbers 1
Formula Error 3
Cell Validation for Decimals 2
Excel does not accept text format! 0
Crating User Form to Add Names 1
Cell Validation 2
trim spaces in a cell 4

Top