Data Validation (Specific Decimals or Whole #)

[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

 

[Ron Coderre]

Using Cell A1, try this:

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

Does that help?

Regards,
Ro

 

[testes]

yes that works perfect. thank you very much

 

[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

 

[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