which operand do I use?

J

jim_in_Roscoe

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.
 
G

Gord Dibben

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
 
J

jim_in_Roscoe

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

jim_in_Roscoe

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
 
Top