I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.

You need to learn about absolute and relative
see HELP as topics "About cell and range references", which points
to better topic "The difference between relative and absolute references"

Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jim_in_Roscoe" wrote in message
...
I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.

Assume the number is in A1 and you wish to use it in all cells.

=B1*$A$1 entered into C1 and filled down will increment the B1 but leave the

A$1 as an absulute reference.

See help on absolute and relative referencing more more detail.


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 19:02:03 -0700, jim_in_Roscoe
wrote:

I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.

That was excellent, just what I needed. I hope my explanation of the problem
wasn't too convoluted.
Thanks a million.
Jim

"Gord Dibben" wrote:

Assume the number is in A1 and you wish to use it in all cells.

=B1*$A$1 entered into C1 and filled down will increment the B1 but leave the

A$1 as an absulute reference.

See help on absolute and relative referencing more more detail.


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 19:02:03 -0700, jim_in_Roscoe
wrote:

I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.

Thanks,
Help is much more helpful when you know what to ask help for.
The absolute and relative tip id the push in the right direction.
Thanks,
Jim

"David McRitchie" wrote:

You need to learn about absolute and relative
see HELP as topics "About cell and range references", which points
to better topic "The difference between relative and absolute references"

Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jim_in_Roscoe" wrote in message
...
I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.