In the worksheet shown, the multiple is 100.
Data validation rules are triggered when a user adds or changes a cell value.
When a custom formula returns TRUE, validation passes and the input is accepted.
When the formula returns FALSE, validation fails and the input is rejected.
We can do this with the MOD function.
MOD function
TheMOD functionreturns the remainder of two numbers after division.
The formula used to validate input looks like this:
The value in C5 is 500.
The MOD function divides 500 by 100 and gets 5, with a remainder of zero.
For example, MOD(10,3) = 1.
The result of MOD carries the same sign as the divisor.
Related videos
How to create zebra stripes with conditional formatting
