How do I multiply cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a rookie please help! I need to get cell "G" to show the dollar amount of cell "C" cost/unit multiplied by cell "F" Quantity. When doing inventory each week and I change my quantities I want cell "G" to automatically figure in the product of the 2 cells. How do I do this

Thanx.......Gene
 
G is a column.. G1 would be a cell, and that's usually where formulae go...
so in G1 put:

=C1*F1

you can then format it as a dollar amount, by clicking on G1 then click on
the dollar sign icon in your toolbar.


gene_pitman said:
I am a rookie please help! I need to get cell "G" to show the dollar
Click to expand...
amount of cell "C" cost/unit multiplied by cell "F" Quantity. When doing
inventory each week and I change my quantities I want cell "G" to
automatically figure in the product of the 2 cells. How do I do this?
 
Gene- don't ask the same question more than once!! Especially 20 minutes
after asking the first time! We here need time to solve these problems-- and
for issues as complex as yours, we often need a little more time.



gene_pitman said:
I am a rookie please help! I need to get cell "G" to show the dollar
Click to expand...
amount of cell "C" cost/unit multiplied by cell "F" Quantity. When doing
inventory each week and I change my quantities I want cell "G" to
automatically figure in the product of the 2 cells. How do I do this?
 
Back
Top