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

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

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