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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF function with manual entry
Yes!
In fact there is a built-in feature called Data Validation that does exactly what you want. Click on G316 and: Data Validation... . Settings Custom Formula =OR(MID(G316,13,5) ="57110",MID(G316,7,2)="80") -- Gary''s Student - gsnu200850 "Vince" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine IF function with manual entry
Gary,
Tried the solution, but get an error message saying: "The value you entered is not valid." "A user has restricted values that can be entered into this cell" Also, I need the number evaluated by the if statement or the manually entered number to be into cell H316 Thanks, "Gary''s Student" wrote: Yes! In fact there is a built-in feature called Data Validation that does exactly what you want. Click on G316 and: Data Validation... . Settings Custom Formula =OR(MID(G316,13,5) ="57110",MID(G316,7,2)="80") -- Gary''s Student - gsnu200850 "Vince" wrote: 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 |
Reply |
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) |