Our Company has an order form for our customers.

Our products have different and specific Case Pack Quantities depending on the item. We want the form to “self correct” preferably UP in quantity so that the quantity they are requesting is changed to higher and even Case pack amount.

EXAMPLE:
Napkins – 300 each per case

Customer fills out in the “Quantity” column that they want 800 napkins. I want the 800 quantity to automatically change to 900 because, 900 would be 3 cases of napkins (300 each).

Does this make sense? Kind of hard to explain in text.
Thanks for any suggestions!