Data Validation (Specific Decimals or Whole #)
 

is it possible to set up a data validation where the only numbers that
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 decimals
other than .5 or .0 are not wanted. can anyone help out?


--
testes
------------------------------------------------------------------------
testes's Profile: http://www.excelforum.com/member.php...o&userid=24965
View this thread: http://www.excelforum.com/showthread...hreadid=384925

Using Cell A1, try this:

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=384925

yes that works perfect. thank you very much.


--
testes
------------------------------------------------------------------------
testes's Profile: http://www.excelforum.com/member.php...o&userid=24965
View this thread: http://www.excelforum.com/showthread...hreadid=384925

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


--
testes
------------------------------------------------------------------------
testes's Profile: http://www.excelforum.com/member.php...o&userid=24965
View this thread: http://www.excelforum.com/showthread...hreadid=384925

Again using Cell A1, try this:

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=384925