Answer for:

Calculation within a cell.

Message 12 of 11

View entire thread
0 Votes

As all the others above have said, as soon you type something into the cell your calculation would be overwritten. The only way I can see off achieving the same result would be to use Visual Basic to replace the value after being input by the user or, as the others have said, you need to have a reference cell.