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

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



"jlowry" wrote:

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

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


"CLR" wrote:

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



"jlowry" wrote:

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

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
--
Brevity is the soul of wit.


"jlowry" wrote:

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

Post your formula and data configuration,
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jlowry" wrote in message
...
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