| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Column Forumulas
I'm sure this is simple, but i suck with excel. Okay, I want to mulitply column A by column B and paste the product into column C. For example, A2 x B2 = C2, but for say, 100 rows without having to do it by hand. -- GuitarFingers ------------------------------------------------------------------------ GuitarFingers's Profile: http://www.excelforum.com/member.php...o&userid=34737 View this thread: http://www.excelforum.com/showthread...hreadid=544964 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Column Forumulas
Select the 100 cells in C, starting at C2
In the formula bar, enter =A2*B2 Use Ctrl-Enter to enter the formula (not just enter) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "GuitarFingers" wrote in message news:GuitarFingers.28atrz_1148452203.4625@excelfor um-nospam.com... I'm sure this is simple, but i suck with excel. Okay, I want to mulitply column A by column B and paste the product into column C. For example, A2 x B2 = C2, but for say, 100 rows without having to do it by hand. -- GuitarFingers ------------------------------------------------------------------------ GuitarFingers's Profile: http://www.excelforum.com/member.php...o&userid=34737 View this thread: http://www.excelforum.com/showthread...hreadid=544964 |
| 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 | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
