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