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