| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Control Sheet
I need to check that the values entered in a seperate sheet are entered
correctly within a certain range. If the entry is out of range, the user must get an error message that the entry is invalid. For instance: =IF(AND(A1=1;A1<=500);allow entry;disallow and prompt user because of invalid entry) What do I do? Best regards, Sonni |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set up stock control sheet in excel | Excel Worksheet Functions | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Threaded Mode
