Cells are cheap, use two cells. One to hold the user input and the other to
hold a formula.

The formula would look at the user input cell and use it if it is not empty.
--
Gary''s Student - gsnu200761


"ranvin56" wrote:

I'm trying to use a "If" statement in a cell. I to try and fill the cell with
a response if a certain critria is met. However, if the critia is not met I
would like to have the person input thier own data. However if they do input
their own data I would like to keep the formula intact for that cell.
When I put the "If" formula in the cell and test it by causing the situation
where I would have to input my own data once I input my data in that cell it
erases the formula.
Can anyone suggest a solution to this problem?