| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Require Minimum Amount When Entering Data
I have an estimating sheet that I made in Excel. I allow my estimators to
enter a percentage to markup materials, and Excel computes a selling price based on cost. I want the the data entry cell to require a minimum 10%. If they try to enter a number less than 10%, I need Excel to warn them, or show some sort of error. Any ideas will be appreciated. Thanks. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA? | Excel Worksheet Functions | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
Threaded Mode
