basics

[Guest]

How do i copy a formula and not have it assume to change the cells. I am trying to create a wookbook for the purchase records of livestock. Using an index grid i need to have each cell in column a multiplied by cell c7 then show a total in each cell of column b. how do i copy the formula from a1 to a2 without it automaticly changing the c7 to c8 and c9 and so on but still change a1 to a2 and so on.

 

[Bernard Liengme]

You need to make the references absolute.
Example:
in B10 you have =A10*C7 and you copy this to B11 it becomes =A11*C8
in B10 you have =A10*$C$7 and you copy this to B11 it becomes =A11*$C$7
in B11 you have =A11*$C$7 and you copy this to C11 it becomes =B11*$C$7
but in B11 you have =$A11*C$7 and you copy this to C11 it becomes =$A11*D$7

A $ prevents either a row or a column from changing; two $s keeps both fixed
Best wishes


--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

How do i copy a formula and not have it assume to change the cells. I am

trying to create a wookbook for the purchase records of livestock. Using an
index grid i need to have each cell in column a multiplied by cell c7 then
show a total in each cell of column b. how do i copy the formula from a1 to
a2 without it automaticly changing the c7 to c8 and c9 and so on but still
change a1 to a2 and so on.

 

[Norman Harker]

Hi Lee!

Use $C$7

See:
Chip Pearson:
http://www.cpearson.com/excel/relative.htm

An explanation of cell referencing.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/