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
|