Entering Formulas
 

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?

Entering Formulas
 

Not without VBA coding.
A cell can either hold a value (2 or .02 or Hello) or it can hold a formula
that may or may not reference other cells, as:
=2 * 2
or
=.02 * C2
or
=SUM(A1:A104)

So if you were to put a formula into C2 such as =.02 * C2, the first thing
you would get is a warning from Excel that you have a Circular Reference,
meaning a cell is dependent on itself or part of itself for a result (well,
it gets even worse, but that's simplified). Even if you ignore that error,
then the second you type something into that cell, the formula disappears.

So to take a value that was entered into C2 and find out what that value
multiplied by .02 is, you put the formula =C2 * .02 into some other cell.

"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?

Entering Formulas
 

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?