Formula

[Trevor]

Can any one help me, its simple if you know how. What is the formula to make
one cell absolute to another.

 

[Guest]

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.

 

[CLR]

=$A$1

Vaya con Dios,
Chuck, CABGx3

 

[Trevor]

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

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.

 

[Guest]

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.

Andy HI what im need is to know for example i need to type into cell B4 a
formula
B3 * absolute reference to B7

 

[CLR]

Try

=B3*$B$7

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

Vaya con Dios,
Chuck, CABGx3

Andy HI what im need is to know for example i need to type into cell B4 a
formula
B3 * absolute reference to B7