Data Validation (Specific Decimals or Whole #)

T

testes

is it possible to set up a data validation where the only numbers tha
someone can enter into a cell are either whole numbers or end in ".5
numbers can be 0, 1, 1.5, 5000.5, etc.... basically any decimal
other than .5 or .0 are not wanted. can anyone help out
 
R

Ron Coderre

Using Cell A1, try this:

Data>Data Validation
Allow: Custom
Formula: =MOD(A1,0.5)=0

Does that help?

Regards,
Ro
 
T

testes

one last thing, is it possible to make this formula a multi- validatio
formula? where the two conditions are that it's either in .0 or .
format and that the number doesn't exceed a certain number in anothe
cell
 
R

Ron Coderre

Again using Cell A1, try this:

Data>Data Validation
Allow: Custom
Formula: =AND((MOD(A1,0.5)=0),(A1<=SomeCell))

Does that help?

Regards,
Ron
 
Top