simple? pasting simple formula, error on copy

[sns]

I have some store buying spreadsheets I made up.

Very very basic, one of the columns has a total at the bottom or end as you
may call it for total $ amount bought. that final number is in c33. c1, c2,
c3 etc is a amount from each vendor.

I want to have a column telling me the percentage being spent on each,
simple enough so I make a column with the following formula =c33/c5. I get
a number, change it to percentage and BAM I have exactly what I want. I
pasted that formula and pasted it into all the other rows of that certain
column, but I keep getting the #div/0 error, cause the new formulas I am
pasting keep moving down a row, where they should be pasting
=c33/c6....c33/c7...c33/c8 and so on, it is pasting c34/c6....c35/c7 and so
on....how can I make that c33 stay constant. I tried hitting the f4 key to
make c33 absolute, but still dont work.

thanks for help

 

[J.E. McGimpsey]

You need to use a mix of relative and absolute references:

D1: =C1/C$33

then copy down.

D2 will have

=C2/C$33

D31 will have

=C31/C$33

See "the difference between absolute and relative references" in XL
Help.


=In article <[email protected]>,

 

[Gord Dibben]

sns

When performing this operation, make sure you are in "Edit" mode for that
cell. F2 will get you there.

Highlight that particular cell reference and then hit F4 to cycle through the
options.

Gord Dibben Excel MVP

 

[sns]

Gord, that worked perfect, thanks so much for the quick reply, my wife will
think I am a genius now! thanks

 

[Gord Dibben]

Great.

A guy needs all the help he can get to become a genius in his wife's eyes.

I have not yet reached that plateau. Still time, it's only been 27 years.

Gord