Dynamic Formula
 

If in Column A there is data and Column B carries out a calculation on Column
A and displays the result, how do I get Column B to automatically update when
I enter data into Column A?

Thanks in advance

Alan

On Sun, 29 May 2005 05:04:02 -0700, awwtau
wrote:

If in Column A there is data and Column B carries out a calculation on Column
A and displays the result, how do I get Column B to automatically update when
I enter data into Column A?

Thanks in advance

Alan

Tools/Options/Calculation
Calculation: Automatic


--ron

Can you have the whole of Column B set with a formula that automatically
updates given the value of Column A? I know you can click the bottom right of
a cell and that carries the formula onto the next row but I don't want to
have to do this with every row, so it would be good if the entire column was
set with the formula?


"Ron Rosenfeld" wrote:

On Sun, 29 May 2005 05:04:02 -0700, awwtau
wrote:

If in Column A there is data and Column B carries out a calculation on Column
A and displays the result, how do I get Column B to automatically update when
I enter data into Column A?

Thanks in advance

Alan

Tools/Options/Calculation
Calculation: Automatic


--ron

If data already exists in Column A, then a *double* click on the "fill
handle" of the formula cell in Column B will copy the formula down Column B,
as far as there is data in Column A.

If there is no data in Column A, then you must click *and drag* the "fill
handle" of the formula cell down Column B as far as needed.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"awwtau" wrote in message
...
Can you have the whole of Column B set with a formula that automatically
updates given the value of Column A? I know you can click the bottom right
of
a cell and that carries the formula onto the next row but I don't want to
have to do this with every row, so it would be good if the entire column
was
set with the formula?


"Ron Rosenfeld" wrote:

On Sun, 29 May 2005 05:04:02 -0700, awwtau

wrote:

If in Column A there is data and Column B carries out a calculation on
Column
A and displays the result, how do I get Column B to automatically
update when
I enter data into Column A?

Thanks in advance

Alan

Tools/Options/Calculation
Calculation: Automatic


--ron