vector multiplication.

.ash.

New Member
Joined
Nov 24, 2008
Messages
2
hi, i need help in knowing how to use an array formula for the following (and even help in knowing if i need an array formula!)

i have my data in pairs like this: (ax1, by1),(cx2, dy2),...
(im using the numbers 1,2,3... only as index to denote the pair, not as powers!)
and in excel i have A1=a, B1=b, A2=c, B2=d so i have the coefficients for all X in column A and for Y in column B.
what i need is to multiply the following:
(ax + by) * (cx + dy) * (ex + fy) * ....

as you know, the result is the summation of the multiplication of the combinations, something like:
(a*c*e)x^3 + (a*c*f)x^2y + (a*d*e)x^2y + ...
for the case with 3 pairs.

how can i get not only the total summation but also see the results of each partial multiplication above?

hope i made my situation clear. do i need arrays? do i need VB?

i will deeply appreciate any help.
thanks
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,371
Members
405,447
Latest member
WPY

This Week's Hot Topics

Top