Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Multiply two columns in Excel or one column by one number

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Axia's Mom - 12 Jan 2006 03:05 GMT
I am a beginner at this. Using Excel, all I want to do is to multiply 2
columns  together to give a third column. For example, a list of numbers in
column A against a list of numbers in column B to produce a column C - (A2
times B2 to equal a number C2))  

or to multiply all the numbers in one column (like "calories" or A2-A18)
times one number (like 0.2) to produce a third column. I tried to do this but
the results replaced the numbers.  

and to multiply one column times two other numbers.

I'm going nuts (I'm swearing all over and I don't usually swear) trying to
add numbers for a book I'm writing. I've got macronutrients like protein and
I want to figure out how many calories the protein is by multiply the number
of calories (in column A) times 0.20

I would do this by calculator but I've got about a zillion numbers and last
time I tried it I made too many mistakes.

Thanks to anyone who can help.
Dave Peterson - 12 Jan 2006 03:22 GMT
You can use a formula:

=a2*b2
and fill down that column.

or
=a2*0.2

There are instructions at Debra Dalgleish's site for how to fill a range.

http://contextures.com/xlDataEntry01.html

> I am a beginner at this. Using Excel, all I want to do is to multiply 2
> columns  together to give a third column. For example, a list of numbers in
[quoted text clipped - 16 lines]
>
> Thanks to anyone who can help.

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.