calculating mark up

[Guest]

i have a column of costs entered. i want to add 20% to each cell and store
that result in another cell. i can get it to calculate one cell but it will
not calculate the rest of the cells in that column.
whats wrong
thanks

 

[Guest]

If your costs are in cells A1:A100, then in B1 put this formula

=A1*1.2

then double click on the little black square in the lower right hand corner
of cell B1, and Excel will Auto-fill down column B as far as you have values
in column A.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

sum your range and multiply by 1.2.

If the column of costs is in B2:B100, then =SUM(B2:B100)*1.2 will get you
your answer.

Dave

 

[RagDyer]

Post your formula and data configuration,

 

[Guest]

THANK YOU SO MUCH - I NEW IT WAS SIMPLE BUT I DIDNT KNOW ABOUT THE DOUBLE
CLICK.
THANKS AGAIN