Combine IF function with manual entry

[Vince]

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(G316,7,5),""))


Thank you for your help

 

[Gary''s Student]

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")

 

[Vince]

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,