| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF function with manual entry
Is there a way for the formula below to evalutate the IF statements, and if
they are all false, to force a manual entry? So if < to "57110" and < to "80" then I would like Excel to open a box (or something) for me to enter the 5 digit number. I have this formula in each row of column H to evaluate the entry made into Column G. =IF(MID(G316,13,5) = "57110",MID(G316,13,5),IF(MID(G316,7,2)="80",MID(G 316,7,5),"")) Thank you for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prohibit manual entry via Drop Down | Excel Worksheet Functions | |||
| Auto Date with Manual Entry Protection | Excel Worksheet Functions | |||
| Data entry too slow even with calc set to manual | Excel Discussion (Misc queries) | |||
| Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
| Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
Threaded Mode
