Trying to do a shifting multiplication and summation
Posted by Will on April 22, 2001 5:35 PM
Well, i'm sure this is pretty easy to do but I'm pretty stupid when it comes to excel. I tried looking in the help files and was just further confused. Pretty much what i'm trying to do is :
c[k]=a[k]*b+a[k-1]*b+a[k-2]*b+..a*b[k] where k is the row number in c where i'm storing the sum
obviously excel doesn't use brackets so like c[k] would be Ck or column C row k.
So like for example it should give
any help would be appreciated, thanks.
and so on.