Put =A1*2.5 in cell B1, then double-click on the little black square in the
lower right corner of B1, the formula should copy down automatically

Vaya con Dios,
Chuck, CABGx3



"gabrielevery" wrote:


I'm pretty new to excel, but here is what I want to do:

I have 2 columns, A and B.

I want to input a number into the cells in column A, and have them
displayed in the cell that I put them.

I then want that number to be multiplied by 2.5 and outputed to the
adjacent cell in colum B.

Its for a time sheet and I am sick of having to multiply everything by
2.5 on a calculator, I figure excel would allow me to do it
automatically...Thanks for any help. I understand how to do math on
individual cells, but I want it to affect the whole column without
having to specify each cell individually.


--
gabrielevery
------------------------------------------------------------------------
gabrielevery's Profile: http://www.excelforum.com/member.php...o&userid=32650
View this thread: http://www.excelforum.com/showthread...hreadid=524530