formula help

[gabrielevery]

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 the
displayed in the cell that I put them.

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

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

 

[Guest]

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

 

[Paul B]

gabrielevery, if your data starts in A1 just put =A1*2.5 in B1 and copy down

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gabrielevery" <[email protected]>
wrote in message
news:[email protected]...

 

[gabrielevery]

and if i wanted to round that value up to the nearest whole number
where would i put the ROUNDUP functio

 

[gls858]

and if i wanted to round that value up to the nearest whole number,
where would i put the ROUNDUP function

Use this formula in col B =ROUND(A1*2.5,0)

gls858

 

[Paul B]

gabrielevery, try this, =ROUNDUP(A1*2.5,0)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gabrielevery" <[email protected]>
wrote in message
news:[email protected]...