Re: Office 2004 - Excel question
- From: Rowbotth <rowbotth@xxxxxxxxxxxxxxx>
- Date: Sun, 25 Dec 2005 19:07:17 GMT
In article <4169brF1d4tr4U1@xxxxxxxxxxxxxx>,
Paul Förster <paul.foerster@xxxxxxx> wrote:
> Hi,
>
> ... ok, this may be a little OT but I use Office:mac 2004, so it's at
> least somehow Mac realted. ;-)))
>
> I have this situation:
>
> Cell E3 contains a value.
> The B column contains values too, ie. B2=3, B3=8, B4=17, B5=6, etc.
> I need this:
> C2=B2/E3
> C3=B3/E3
> C4=B4/E3
> C5=B5/E3
> ...
>
> If I put the formula =B2/E3 into cell C2, then copy it and paste it
> into the whole C column, then the E3 part gets counted up too, thus
> referencing a wrong cell, ie. E4, E5, E6, etc.
>
> How can I make the Bx cell part of the formula increase like it
> correctly does now but keep the E3 cell part constant and still fill
> the whole C column without having to edit each and every C cell by hand?
Constants should always be prefixed with the $ symbol. That should work
for you.
H.
.
- References:
- Office 2004 - Excel question
- From: Paul Förster
- Office 2004 - Excel question
- Prev by Date: Re: Questions about Intel Macs
- Next by Date: Re: anti virus
- Previous by thread: Re: Office 2004 - Excel question
- Next by thread: Re: Upgrading 300 Mhz Mac G3
- Index(es):
Relevant Pages
|
