Formula

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

Guest

Can any one help me, its simple if you know how. What is the formula to make
one cell absolute to another.
 
Hi
Don't really understand the question - but here goes.
If you want a cell to always show the same as another, type = in the first
cell and then click the second with your mouse and press Enter. This will
'link' the two cells, and if you move the second, the first will stay linked
to it.
If you want to link to the cell that is always a row up and a column left
(for example) from the first, use the OFFSET function.
Hope this helps.
 
Andy HI what im need is to know for example i need to type into cell B4 a
formula
B3 * absolute reference to B7
--
Many Thanks
Trevor


Andy B said:
Hi
Don't really understand the question - but here goes.
If you want a cell to always show the same as another, type = in the first
cell and then click the second with your mouse and press Enter. This will
'link' the two cells, and if you move the second, the first will stay linked
to it.
If you want to link to the cell that is always a row up and a column left
(for example) from the first, use the OFFSET function.
Hope this helps.
Click to expand...
 
Hi
What do you want the result to be if you drag and drop B7 to somewhere else,
for example? Do you want the formula to refer to the existing, moved cell,
or do you still want it to refer to the now-empty B7.

--
Andy.


Trevor said:
Andy HI what im need is to know for example i need to type into cell B4 a
formula
B3 * absolute reference to B7
Click to expand...
 
Try

=B3*$B$7

and see if it does what you want it to.....

Vaya con Dios,
Chuck, CABGx3



Trevor said:
Andy HI what im need is to know for example i need to type into cell B4 a
formula
B3 * absolute reference to B7
Click to expand...
 
Back
Top