Can any one help me, its simple if you know how. What is the formula to make
one cell absolute to another.
--
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.

--
Andy.


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
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


"Andy B" wrote:

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.


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
Trevor

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" wrote in message
...
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" wrote:

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.


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
Trevor

Try

=B3*$B$7

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

Vaya con Dios,
Chuck, CABGx3



"Trevor" wrote:

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" wrote:

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.


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
Trevor

=$A$1

Vaya con Dios,
Chuck, CABGx3


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
Trevor