Hi JM,
You can use
Data Validation in Excel to check if the ordered quantity is always a multiple of 12. Here are the steps:
- Select the cell or cells where you want to apply the validation.
- Go to the Data tab in the ribbon and click on Data Validation.
- In the Data Validation dialog box, select "Custom" from the "Allow" drop-down list.
- In the "Formula" field, enter the following formula: (assuming that the cell you want to validate is A1).
- Click on the "Error Alert" tab and enter a suitable error message, such as "Please enter a multiple of 12".
- Click OK to close the dialog box.
Now, whenever someone enters a quantity in the selected cell(s), Excel will check if it is a multiple of 12. If it is not, an error message will appear.