multiplication of two array in a particular way

R

Rahul

i have 4 different numbers in two columns say A & B. i want to
multiply them & get the result in column C, multiplication should be
done in the following manner:-

C1= A1*B1
C2= A2*B1+B2*A1
C3= A1*B3+A2*B2+A3*B1
C4= A1*B4+A2*B3+A3*B2+A4*B1

can you please help me in this?
 
P

Pete_UK

I don't see what your problem is - can't you just put those formulae
in the cells stated and then you have what you wanted?

Pete
 
M

Mike H

Hi,

Unlike your previous question where there was a logical order for the
summing this appears random and while I hope someone provides a solution, I'm
a bit doubtful it can be done in a single formula. I suggest you enter those
formulas as you describe.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help calculating probabilities 7
how to use if formula in list (data validation list) 1
Lookup / Summary Table 0
Can a cell be turned on or off? 1
Hyperlinks with lookups 0
Need to have data in one column 1
Urgent help with Excel formula. Please please help 1
Extract multiple numbers from a cell 3

Top