|
I need to autofill Column C with Column B x 55%
Hi, My column B has a bunch of prices in it, now I want to autofill column C somehow using the data from column B x 55%. how can I do this? -- ExcelNoobie ------------------------------------------------------------------------ ExcelNoobie's Profile: http://www.excelforum.com/member.php...o&userid=35191 View this thread: http://www.excelforum.com/showthread...hreadid=549552 |
I need to autofill Column C with Column B x 55%
The formula should be in cell C: =B1*.55 - this only gives you the
percentage. If you want the total of that plus the number in cell B then the forumula should be =B1*.55+B1. To copy the formula down, position the cursor in the right bottom part of the cell and drag it down to the number of cells you need. HTH, newtechie "ExcelNoobie" wrote in message ... Hi, My column B has a bunch of prices in it, now I want to autofill column C somehow using the data from column B x 55%. how can I do this? -- ExcelNoobie ------------------------------------------------------------------------ ExcelNoobie's Profile: http://www.excelforum.com/member.php...o&userid=35191 View this thread: http://www.excelforum.com/showthread...hreadid=549552 |
I need to autofill Column C with Column B x 55%
great! thanks for the help! I can't believe I have so little knowledge of excel hahah. its frustrating! -- ExcelNoobie ------------------------------------------------------------------------ ExcelNoobie's Profile: http://www.excelforum.com/member.php...o&userid=35191 View this thread: http://www.excelforum.com/showthread...hreadid=549552 |
| All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com