View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default How do I multiply 1 cell x 1 cell and answer in 3rd cell?

Check the help file for summing and multiplying. :)
Something like:
In cell E3: =C3*D3
In cell E2: =SUM(E3:E65536)
(which will add up all of E column from E down to the last row regardless of
the number of rows you use)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Melody" wrote in message
...
Hi;
I would like to multiply one cell (Hours worked) with another cell
(hourly wage) and get the answer in the third cell (Wage earned). The
other
variable is that I would like the Wage Earned column to add all of the
wages
earned and do that in the cell designated. As an example, I have my hours
worked in Column C and my hourly wage in Column D. I would like to have
the
product of these two columns to appear in Column E. I also have a formula
in
E2 that sums the numbers in Column E. This is so that I can just place in
my
hours work with the my hourly wage, have it figured for me, and then added
so
that I have a total of wages from the company I have the spreadsheet for.
Your help would be very appreciated.

--
Snicker''''s Mom