View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
newtechie
 
Posts: n/a
Default 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