Valid if question

[AntonyCole1979]

Hi Everyone, I have 2 columns [Min Order Qty] and [Order Qty]. I want only to allow multiples of the [Min Order Qty] in [Order Qty]. So if [Min order Qty]=25 then [Order Qty] to only allow multiples of 25. Please can someone help me with the expression.

Thanks

Antony

[LeventK]

@AntonyCole1979
You can use this expression in Valid_if property of [Order Qty] column

MOD([Order Qty],[Min Order Qty]) = 0

[AntonyCole1979]

Thanks for your help

Antony