formula help
 

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

formula help
 

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

formula help
 

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"
wrote in message
news:gabrielevery.24zh8z_1142883905.3407@excelforu m-nospam.com...

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

formula help
 

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


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

formula help
 

gabrielevery wrote:
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

formula help
 

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"
wrote in message
news:gabrielevery.24zmkn_1142890803.7083@excelforu m-nospam.com...

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


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