View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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?