| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if an entry is a multiple of another cell
I am creating an order form in which I have cells that are used to enter a
certain quantity of pencils. The pencils must be ordered in multiples of 12. How can I use Data Validation to check if the ordered quantity is always a multiple of 12? Thanks, JM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to check what date a specific data entry (cell) was entere | Excel Discussion (Misc queries) | |||
| single-cell multiple entry with pull-down list? | Excel Discussion (Misc queries) | |||
| Check if cell entry belongs to a name list-how? | Excel Discussion (Misc queries) | |||
| Entry into check box dependent on other check box. | Excel Worksheet Functions | |||
| How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
![JMM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
