How do I enter a formula that multiplies columns?

[Scott]

I'm trying to enter a formula so that when I type numbers in columns, like B
& C, I get the result (of multiplying) the columns in column D or wherever.

I can do it individually, but for the life of me I can't figure out how to
make it apply to all the numbers as I add them.

Help would be outstanding!!

TKS

 

[carlo]

Hi TKS

I am not quite sure if I understand you correctly, but what I would do
is this:
If you want to have numbers in Columns A, B and C and multiply them in
Column D, you could enter following formula to your column D:
=A1*B1*C1
which of course only works, if all three fields have a number in it,
otherwise it results in 0.
To avoid this you could change the formula to:
=IF(A1="",1,A1)*IF(B1="",1,B1)*IF(C1="",1,C1)
that would mean though, that if you leave all three columns empty it
would result in 1.
Now you could change it to:
=IF(AND(A1="",B1="",C1=""),0,IF(A1="",1,A1)*IF(B1="",1,B1)*IF(C1="",
1,C1))

hope that helps you

Cheers Carlo

PS: maybe there will be a wordwrap, all formulas should be on one
line!

 

[Ken Hudson]

Hi Scott,

In cell D1 enter:

=IF(B1*C1=0,"",B1*C1)

Then copy that formula down all the rows in column D that you wil be using.
As you enter values in B and C, you will get the multpication result in D.
Otherwise column D will not display anything.
HTH

 

[jmoore]

being new to excel myself, this sounds like "how do i copy". if the formula
in column d, cell whatever- works ok, then it just needs to be copied to the
remainder of the column. click on the d cell, then either CTL C, or click on
copy, move to the cell/s you want to copy to, CTL V, or click paste. if you
dont highlight the cells to copy to, CTL V will copy the formula until you
press esc. this might be the blind leading the blind.