Data Validation Number Multiple 100 Excel Formula
In this case, the MOD function is used to perform a modulo operation, which returns the remainder after division. The formula used to validate input is: The value in C5 is 500. The MOD function divides 500 by 100 and gets 5, with a remainder of zero. Since 0 = 0, The rule returns TRUE and the data validation passes: If a user enters, say, 550, the remainder is 50, and validation fails: Note: Cell references in data validation formulas are relative to the upper left cell in the range selected when the validation rule is defined, in this case C5....