booya2 Posted January 27, 2005 Posted January 27, 2005 I have a question guys... In Excel how can I convert a whole column of numbers to 85% of their current value. At work I have a price list in an Excel spreadsheet but need to convert it to 15% off for a major account we have. I'm usually not the go to guy at work for this type of project, and have limited skills with Excel. I'm not sure what to enter into the formula bar or what function to use in the drop down list to accomplish this task. I know this is probably a dumb question, but thanks in advance for any help guys! GO BILLS!
col_forbin Posted January 27, 2005 Posted January 27, 2005 The formula would be =sum(whatever cell number*.85)
HopsGuy Posted January 27, 2005 Posted January 27, 2005 You could in the column next to the prices enter the formula: =A1*.85 then paste that down the whole way. Or you can put 0.85 in a free cell, copy that cell then highlight the column where the prices are, select "Paste Special" from the edit menu. The dialog box will have a choice in the operation section to Multiply. This will change those prices. Then you save the spreadsheet under a different name. This should be pretty easy for you. Here's a great resource that I use all the time: Mr. Excel
stevestojan Posted January 27, 2005 Posted January 27, 2005 =A1*0.85 Then drag the bottom right corner down. sorry... saw it answered
Recommended Posts