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!

On Dec 27, 8:56*am, Scott wrote:
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