Questions

Answer for:

Calculation within a cell.

Message 7 of 11

View entire thread
+
0 Votes
gresher

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.