Formula

[Trevor]

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" <Trevor@discussions.microsoft.com> wrote in message
news:1199CE3B-FFA0-4197-9A31-2573BB01C9FE@microsoft.com...
> 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

[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" <Trevor@discussions.microsoft.com> wrote in message
> news:1199CE3B-FFA0-4197-9A31-2573BB01C9FE@microsoft.com...
> > 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" <Trevor@discussions.microsoft.com> wrote in message
news:B76ED195-8B1C-4513-B985-F515A09B6B8D@microsoft.com...
> 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" <Trevor@discussions.microsoft.com> wrote in message
>> news:1199CE3B-FFA0-4197-9A31-2573BB01C9FE@microsoft.com...
>> > 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
>>
>>
>>

[CLR]

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" <Trevor@discussions.microsoft.com> wrote in message
> > news:1199CE3B-FFA0-4197-9A31-2573BB01C9FE@microsoft.com...
> > > 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
> >
> >
> >

[CLR]

=$A$1

Vaya con Dios,
Chuck, CABGx3


"Trevor" <Trevor@discussions.microsoft.com> wrote in message
news:1199CE3B-FFA0-4197-9A31-2573BB01C9FE@microsoft.com...
> 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