I would like to apply a custom validation to ensure that the input value in a cell is equal to or an exact multiple of a value in another cell. For example, if the reference cell contains the value "2" then the only valid entry in the input cell should be 2,4,6,8,10 etc. (Zero should also be valid). Is this possible?

Thanks

dalymjl

Hope the attachment helps.

Microsoft Excel custom functions can do a variety of things related to the address and postal code information, such as import of demographic data, find zip codes within a radius, including the calculation of driving time and distance. Custom functions (also called user-defined functions or UDFs) to perform complex calculations or tasks and are used in cell formulas as standard Excel functions SUM, AVERAGE, or research.