Overtyping a formulas answer
I need to automatically calculate a number in one column based on another column, but also need the ability to overrule this result at times and manually enter an answer in the "calculated" column.
When I do I don't want to change the column formula to a line formula as multiple lines are continually being added and things will get very messy with insertions and additional lines without a cell formula.
Annual requirement Minimum stock
120 10 (Annual requirement/12)
2400 200 "
10 In this case I want to overtype 25 instead
Am I expecting too much, or has somebody done this?