formula help

  • Thread starter Thread starter gabrielevery
  • Start date Start date
G

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
 
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, 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]...
 
and if i wanted to round that value up to the nearest whole number
where would i put the ROUNDUP functio
 
gabrielevery said:
and if i wanted to round that value up to the nearest whole number,
where would i put the ROUNDUP function
Click to expand...
Use this formula in col B =ROUND(A1*2.5,0)

gls858
 
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]...
 
Back
Top