CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
arul selvan
arul selvan

Reputation: 624

Minimum order and multiples in data validation

I have the minimum order qty in H1 I have the multiplier in H2 (multiplier means in multiples of)

If minimum order qty is 10 and multiplier is 2, in cell H5 to H100, the user can type anything equal to or more than 10 and in multiples of 2, which means he can type 10,12,14,16,18,....

I don't want a drop down.

Is it possible to achieve by data validation?

How else can it be achieved?

Upvotes: 0

Views: 35

Answers (1)

CMB
CMB

Reputation: 5163

Solution:

You can use a custom formula for data validation:

Use this formula on cell range H5:H100: =AND(H5>=$H$1,MOD(H5-$H$1,$H$2)=0)

enter image description here

Output:

enter image description here

The marked entries from cell H5 are invalid.

Upvotes: 1

Related Questions