Forum Discussion
IF + Manual
Not literally possible. Once you enter something else "manually" you've obliterated what was there before.
However, you could do your manual entry in a designated cell in the same row, off to the side.
Assume your "X" --predetermined "normal" condition text--is in cell X1
Set aside column "Y" (but every row running down the sheet) for your manual entry
The formula could then read
=IF(A1=1;$X$1;Y1)
Another solution, depending on how many "manual" entries are expected, how fluid you want those to be...if, in other words, your normal expectation is answer A, but you also will allow B, C, D, E, F, G, H (etc., but finite) is to use Data Validation with A as the default value.
In short, I can envision several ways to approach this, but would need to find out from you a bit more the "big picture" of what you're trying to do.