The value entered in the cell will overwrite the existing formula. Reconsider the design of your spreadsheet.
Kees
Is there a way to have a formula in an excel cell which will display results or display a value if a value is intered in the same cell without losing the formula?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic