MS Excel question. - GoFuckYourself.com

robfantasy · 12-17-2003, 01:31 PM

I want to create a new column that takes all the prices in Column D and marks them up 20%. How do i do this?

Bryan Havoc · 12-17-2003, 01:37 PM

In column E write =D1 * 1.20

Copy that cell down tot he end of your list

arg · 12-17-2003, 01:38 PM

Say you've got D1-D20 with numbers. In E1, type "=D1*1.2". Then copy and paste it to E2-E20. If there are a ton of rows, I think you can click on a dot in the lower right corner of the cell and drag it downward, or something like that, and they'll all fill in with E1's formula.

robfantasy · 12-17-2003, 02:00 PM

cool thanks, how do i make the values into dollars.

ie.
12.0825 = $12.08

Goliath · 12-17-2003, 02:51 PM

Quote:

Originally posted by robfantasy
cool thanks, how do i make the values into dollars.

ie.
12.0825 = $12.08

Highlight the cells, right click, and hit format cells. Click the number tab and hit Currency.

12-17-2003, 01:31 PM	#1
robfantasy Confirmed User Industry Role: Join Date: Jun 2002 Location: Medellin, Colombia Posts: 6,445	MS Excel question. I want to create a new column that takes all the prices in Column D and marks them up 20%. How do i do this? __________________ Looking to speak w/ high volume nutra CPA affiliates or networks... msg me

12-17-2003, 01:37 PM	#2
Bryan Havoc Confirmed User Join Date: Aug 2002 Location: New Jersey Posts: 784	In column E write =D1 * 1.20 Copy that cell down tot he end of your list __________________ Bryan Havoc // ICQ - 165029472 [email protected] FreePaysiteCash.com

12-17-2003, 02:00 PM	#4
robfantasy Confirmed User Industry Role: Join Date: Jun 2002 Location: Medellin, Colombia Posts: 6,445	cool thanks, how do i make the values into dollars. ie. 12.0825 = $12.08 __________________ Looking to speak w/ high volume nutra CPA affiliates or networks... msg me

12-17-2003, 01:38 PM	#3
arg Confirmed User Join Date: Feb 2003 Posts: 1,164	Say you've got D1-D20 with numbers. In E1, type "=D1*1.2". Then copy and paste it to E2-E20. If there are a ton of rows, I think you can click on a dot in the lower right corner of the cell and drag it downward, or something like that, and they'll all fill in with E1's formula.