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?