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!

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

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.