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
-
In column E write =D1 * 1.20
Copy that cell down tot he end of your list -
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.Comment
-
cool thanks, how do i make the values into dollars.
ie.
12.0825 = $12.08Looking to speak w/ high volume nutra CPA affiliates or networks... msg meComment
-
Highlight the cells, right click, and hit format cells. Click the number tab and hit Currency.Originally posted by robfantasy
cool thanks, how do i make the values into dollars.
ie.
12.0825 = $12.08"Stop the teasin' and start the pleasin'"Comment
Comment