to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i .

[Guest]

if cells b1-b10 have random #'s & are totaled in b11 & i put in the formula
in cell c1 of +b1/b11 to get the % of b1 of the total // how can i copy this
formula to c2-10 & make the 2nd half of the formula reference b11 only?

 

[JE McGimpsey]

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

One way:

C1: =B1/B$11

 

[Guest]

=B1/$B$11

regards,

Peo Sjoblom

 

[Gord Dibben]

bvi

Change B11 to $B$11

=B1/$B$11 entered in C1 and copied down to C10

Gord Dibben Excel MVP