Custom Data Validation

[maacmaac]

I am trying to apply custom data validation for two cells

The first is data validation in cell B6. The only valid entries should be in mulitples of 100 (e.g. 100, 200, 300, .... etc).

The second cell is B12. The only valid enteries should be any number above 100 and not = 100, 200, 300, .... etc).

I tried using following formula in data validation for cell B6 but no luck. Couldn't figure out what to use for cell B12

=mod(B6,100)

[Macdave_19]

Select:

Data>Validation

from the drop down choose "List"

then in the textbox below enter the value's you want seperated by a comma like so

100,200,300.

or if you know how create a list of the numbers you want to use then highlight them and in the white box at the top left of the screen type a name and hit enter.

then in repeat the data validation part but in the box type:

=Thenameofyourlist

hope that helps

[maacmaac]

Thanks for suggestion. I thought of using the list except the list would need to be from 100 to 100,000 or more. Also, the second part of my validation question is to validate is for any number above 100 and not equal to 100, 200, 300, ... etc. Is there some type of formula I could use in place of a list? Thanks.

[maacmaac]

I am trying an alternative solution.

I am using following formula to generate a random number.

=INT((49*RAND())+2)*100

I tried using the same formula for my data validation but still not working. Any assistance tweaking this formula is appreciated. Thanks.

[shg]

Validation for B6 =MOD(B6,100)=0

For B12, =AND(B12>100, MOD(B12, 100)<>0)

[maacmaac]

Both results working. Thanks.