which operand do I use?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That was excellent, just what I needed. I hope my explanation of the problem
wasn't too convoluted.
Thanks a million.
Jim
 
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
 
Back
Top