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

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?

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

One way:

C1: =B1/B$11


In article ,
bvi wrote:

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?

=B1/$B$11

regards,

Peo Sjoblom

"bvi" wrote:

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?

bvi

Change B11 to $B$11

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

Gord Dibben Excel MVP

On Thu, 23 Dec 2004 08:49:02 -0800, bvi wrote:

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?