how can i multiply two columns

[Guest]

id like to know how can i multiply two columns. in excel, if i have numbers
on column c and want to multiply it with column f, what should i do?

 

[Chip Pearson]

In the cell where you want the result, enter

=C1*E1

Copy this formula down as far as you need to go.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Assuming you want the products in column G, then in G1 put this formula

=C1*F1

Then, left click and hold on the little black square in the lower right
corner of G1 and drag it down column G as far as you have data in column
F.....

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

thank you, that works. is it possible when i type a number on c column and a
number on f column that it will automatically put the product on g column?
just like when i do the sum function, when i type in a number in a column, it
automatically put the total in another column.let say i have about 20 rows of
numbers in column c and and f, when i input numbers in those column, is the
product will automatically input in column g? if not, how can i do this?
also, when i'm done with the product on column g, how can i add all those and
put the total at the bottom of column g? thank you for your help, i
appreciate it.

mr. alalay

 

[Guest]

The formula I gave you is what does the multiplication. If it is in column G
of any row, it will multiply the respective values in columns C and F.
However, it will return zero if either of the two cells are empty.....which
may not be hat you want. If you would prefer that the cell in column G be
blank if one or both of the other two cells are blank, then use this formula
instead.........
=IF(COUNT(C1,F1)=2,C1*F1,"")

You can type it in G1 and then copy and paste it as far down column G as you
expect to have entries in C and F, even if they are not there yet. If there
are no values in the respective cells in columns C and F, then these column G
cells will be blank. Then, when you populate columns C and F, this formula
in column G will provide the product of them "automatically".

hth
Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Sorry, I forgot to add, that this formulla will add up all the items in
column G for you from G1 to G20......you can adjust those cells to fit your
needs.....

=SUN(G1:G20)

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

thank you, i think that should work. i have another situation, i've been
trying what you told me and it work so far, but when i do a formula to a
column that is small, it wont won't. if i do =(c1+f1) and type it into a
column that is smaller than the 9 character formula that i just input, then
it wont show the sum, i tried it and it won't work, but if i widen the column
in such that it will fit all those characters, it work. how can i make a
longer formula for a small column that would work. also, how can i have excel
add or subract numbers that has conversion, i.e., column a is
dwt(pennyweight) and column b is grain. there are 24 grains in one dwt, how
can i make a formula that will convert such as if the grain column is greater
than or equal to 24, it will carry it forward to the dwt column, i hope it
doesn't sound too confusing, thank you very much for your help.

edgar

 

[Guest]

Whether or not characters appear in a column is a matter of the "result" of a
formula, not the length of the formula itself......you can have a 50
character formula in a 9 character wide cell and if the result is 4
characters, it will show up.....but if you have a 6 character formula in a 9
character cell and the result is 12 characters, it will not display properly.

If you have 51 grains in A1 then =INT(A1/24) in B1 will return 2, and
=A1-(INT(A1/24)*24) in C1 will return 3. Or, =INT(A1/24)&" dwt,
"&A1-(INT(A1/24)*24)&" gr" will return 2 dwt, 3 gr.

hth
Vaya con Dios,
Chuck, CABGx3