| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Hybrid Mode
