software

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?

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
quot;edgarquot; gt; wrote in message
...
gt; id like to know how can i multiply two columns. in excel, if i
gt; have numbers
gt; on column c and want to multiply it with column f, what should
gt; i do?
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
quot;edgarquot; wrote:

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

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

quot;CLRquot; wrote:

gt; Assuming you want the products in column G, then in G1 put this formula
gt;
gt; =C1*F1
gt;
gt; Then, left click and hold on the little black square in the lower right
gt; corner of G1 and drag it down column G as far as you have data in column
gt; F.....
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;edgarquot; wrote:
gt;
gt; gt; id like to know how can i multiply two columns. in excel, if i have numbers
gt; gt; on column c and want to multiply it with column f, what should i do?

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,quot;quot;)

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 quot;automaticallyquot;.

hth
Vaya con Dios,
Chuck, CABGx3
quot;edgarquot; wrote:

gt; thank you, that works. is it possible when i type a number on c column and a
gt; number on f column that it will automatically put the product on g column?
gt; just like when i do the sum function, when i type in a number in a column, it
gt; automatically put the total in another column.let say i have about 20 rows of
gt; numbers in column c and and f, when i input numbers in those column, is the
gt; product will automatically input in column g? if not, how can i do this?
gt; also, when i'm done with the product on column g, how can i add all those and
gt; put the total at the bottom of column g? thank you for your help, i
gt; appreciate it.
gt;
gt; mr. alalay
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Assuming you want the products in column G, then in G1 put this formula
gt; gt;
gt; gt; =C1*F1
gt; gt;
gt; gt; Then, left click and hold on the little black square in the lower right
gt; gt; corner of G1 and drag it down column G as far as you have data in column
gt; gt; F.....
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;edgarquot; wrote:
gt; gt;
gt; gt; gt; id like to know how can i multiply two columns. in excel, if i have numbers
gt; gt; gt; on column c and want to multiply it with column f, what should i do?

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, CABGx3quot;CLRquot; gt; wrote in message
news
gt; The formula I gave you is what does the multiplication. If it is in
column G
gt; of any row, it will multiply the respective values in columns C and F.
gt; However, it will return zero if either of the two cells are
empty.....which
gt; may not be hat you want. If you would prefer that the cell in column G be
gt; blank if one or both of the other two cells are blank, then use this
formula
gt; instead.........
gt; =IF(COUNT(C1,F1)=2,C1*F1,quot;quot;)
gt;
gt; You can type it in G1 and then copy and paste it as far down column G as
you
gt; expect to have entries in C and F, even if they are not there yet. If
there
gt; are no values in the respective cells in columns C and F, then these
column G
gt; cells will be blank. Then, when you populate columns C and F, this
formula
gt; in column G will provide the product of them quot;automaticallyquot;.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;edgarquot; wrote:
gt;
gt; gt; thank you, that works. is it possible when i type a number on c column
and a
gt; gt; number on f column that it will automatically put the product on g
column?
gt; gt; just like when i do the sum function, when i type in a number in a
column, it
gt; gt; automatically put the total in another column.let say i have about 20
rows of
gt; gt; numbers in column c and and f, when i input numbers in those column, is
the
gt; gt; product will automatically input in column g? if not, how can i do this?
gt; gt; also, when i'm done with the product on column g, how can i add all
those and
gt; gt; put the total at the bottom of column g? thank you for your help, i
gt; gt; appreciate it.
gt; gt;
gt; gt; mr. alalay
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Assuming you want the products in column G, then in G1 put this
formula
gt; gt; gt;
gt; gt; gt; =C1*F1
gt; gt; gt;
gt; gt; gt; Then, left click and hold on the little black square in the lower
right
gt; gt; gt; corner of G1 and drag it down column G as far as you have data in
column
gt; gt; gt; F.....
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;edgarquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; id like to know how can i multiply two columns. in excel, if i have
numbers
gt; gt; gt; gt; on column c and want to multiply it with column f, what should i do?
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

quot;CLRquot; wrote:

gt; Sorry, I forgot to add, that this formulla will add up all the items in
gt; column G for you from G1 to G20......you can adjust those cells to fit your
gt; needs.....
gt;
gt; =SUN(G1:G20)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt; quot;CLRquot; gt; wrote in message
gt; news
gt; gt; The formula I gave you is what does the multiplication. If it is in
gt; column G
gt; gt; of any row, it will multiply the respective values in columns C and F.
gt; gt; However, it will return zero if either of the two cells are
gt; empty.....which
gt; gt; may not be hat you want. If you would prefer that the cell in column G be
gt; gt; blank if one or both of the other two cells are blank, then use this
gt; formula
gt; gt; instead.........
gt; gt; =IF(COUNT(C1,F1)=2,C1*F1,quot;quot;)
gt; gt;
gt; gt; You can type it in G1 and then copy and paste it as far down column G as
gt; you
gt; gt; expect to have entries in C and F, even if they are not there yet. If
gt; there
gt; gt; are no values in the respective cells in columns C and F, then these
gt; column G
gt; gt; cells will be blank. Then, when you populate columns C and F, this
gt; formula
gt; gt; in column G will provide the product of them quot;automaticallyquot;.
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;edgarquot; wrote:
gt; gt;
gt; gt; gt; thank you, that works. is it possible when i type a number on c column
gt; and a
gt; gt; gt; number on f column that it will automatically put the product on g
gt; column?
gt; gt; gt; just like when i do the sum function, when i type in a number in a
gt; column, it
gt; gt; gt; automatically put the total in another column.let say i have about 20
gt; rows of
gt; gt; gt; numbers in column c and and f, when i input numbers in those column, is
gt; the
gt; gt; gt; product will automatically input in column g? if not, how can i do this?
gt; gt; gt; also, when i'm done with the product on column g, how can i add all
gt; those and
gt; gt; gt; put the total at the bottom of column g? thank you for your help, i
gt; gt; gt; appreciate it.
gt; gt; gt;
gt; gt; gt; mr. alalay
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Assuming you want the products in column G, then in G1 put this
gt; formula
gt; gt; gt; gt;
gt; gt; gt; gt; =C1*F1
gt; gt; gt; gt;
gt; gt; gt; gt; Then, left click and hold on the little black square in the lower
gt; right
gt; gt; gt; gt; corner of G1 and drag it down column G as far as you have data in
gt; column
gt; gt; gt; gt; F.....
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;edgarquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; id like to know how can i multiply two columns. in excel, if i have
gt; numbers
gt; gt; gt; gt; gt; on column c and want to multiply it with column f, what should i do?
gt;
gt;
gt;

Whether or not characters appear in a column is a matter of the quot;resultquot; 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)amp;quot; dwt,
quot;amp;A1-(INT(A1/24)*24)amp;quot; grquot; will return 2 dwt, 3 gr.

hth
Vaya con Dios,
Chuck, CABGx3
quot;edgarquot; wrote:

gt; thank you, i think that should work. i have another situation, i've been
gt; trying what you told me and it work so far, but when i do a formula to a
gt; column that is small, it wont won't. if i do =(c1 f1) and type it into a
gt; column that is smaller than the 9 character formula that i just input, then
gt; it wont show the sum, i tried it and it won't work, but if i widen the column
gt; in such that it will fit all those characters, it work. how can i make a
gt; longer formula for a small column that would work. also, how can i have excel
gt; add or subract numbers that has conversion, i.e., column a is
gt; dwt(pennyweight) and column b is grain. there are 24 grains in one dwt, how
gt; can i make a formula that will convert such as if the grain column is greater
gt; than or equal to 24, it will carry it forward to the dwt column, i hope it
gt; doesn't sound too confusing, thank you very much for your help.
gt;
gt; edgar
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Sorry, I forgot to add, that this formulla will add up all the items in
gt; gt; column G for you from G1 to G20......you can adjust those cells to fit your
gt; gt; needs.....
gt; gt;
gt; gt; =SUN(G1:G20)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; gt; wrote in message
gt; gt; news
gt; gt; gt; The formula I gave you is what does the multiplication. If it is in
gt; gt; column G
gt; gt; gt; of any row, it will multiply the respective values in columns C and F.
gt; gt; gt; However, it will return zero if either of the two cells are
gt; gt; empty.....which
gt; gt; gt; may not be hat you want. If you would prefer that the cell in column G be
gt; gt; gt; blank if one or both of the other two cells are blank, then use this
gt; gt; formula
gt; gt; gt; instead.........
gt; gt; gt; =IF(COUNT(C1,F1)=2,C1*F1,quot;quot;)
gt; gt; gt;
gt; gt; gt; You can type it in G1 and then copy and paste it as far down column G as
gt; gt; you
gt; gt; gt; expect to have entries in C and F, even if they are not there yet. If
gt; gt; there
gt; gt; gt; are no values in the respective cells in columns C and F, then these
gt; gt; column G
gt; gt; gt; cells will be blank. Then, when you populate columns C and F, this
gt; gt; formula
gt; gt; gt; in column G will provide the product of them quot;automaticallyquot;.
gt; gt; gt;
gt; gt; gt; hth
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;edgarquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; thank you, that works. is it possible when i type a number on c column
gt; gt; and a
gt; gt; gt; gt; number on f column that it will automatically put the product on g
gt; gt; column?
gt; gt; gt; gt; just like when i do the sum function, when i type in a number in a
gt; gt; column, it
gt; gt; gt; gt; automatically put the total in another column.let say i have about 20
gt; gt; rows of
gt; gt; gt; gt; numbers in column c and and f, when i input numbers in those column, is
gt; gt; the
gt; gt; gt; gt; product will automatically input in column g? if not, how can i do this?
gt; gt; gt; gt; also, when i'm done with the product on column g, how can i add all
gt; gt; those and
gt; gt; gt; gt; put the total at the bottom of column g? thank you for your help, i
gt; gt; gt; gt; appreciate it.
gt; gt; gt; gt;
gt; gt; gt; gt; mr. alalay
gt; gt; gt; gt;
gt; gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Assuming you want the products in column G, then in G1 put this
gt; gt; formula
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =C1*F1
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Then, left click and hold on the little black square in the lower
gt; gt; right
gt; gt; gt; gt; gt; corner of G1 and drag it down column G as far as you have data in
gt; gt; column
gt; gt; gt; gt; gt; F.....
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;edgarquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; id like to know how can i multiply two columns. in excel, if i have
gt; gt; numbers
gt; gt; gt; gt; gt; gt; on column c and want to multiply it with column f, what should i do?
gt; gt;
gt; gt;
gt; gt;