Formulation Question

[bsp12]

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!

[bsp12]

FYI- I am using the most current version of Excel.

[arlu1201]

Bsp12,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.