You cannot have a formula in a cell then enter a value into that cell.

One or the other.

Use another cell for the calculated value as RD suggests.

OR we can provide VBA event code to do all in one cell.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 16:28:02 -0700, Nickydad
wrote:

I want to be able to enter a value into C2, for example, and have a formula
that will take that value and multiply it by .02, for example. The result to
be reflected in C2. Can I do this?