Posted to microsoft.public.excel.worksheet.functions

Rahul

external usenet poster

Posts: 2

multiplication of two array in a particular way

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Weird Multiplication!	Gary T	Excel Worksheet Functions	6	November 23rd 07 02:15 AM
Multiplication	Danny Mac	Excel Worksheet Functions	8	December 7th 06 10:28 PM
multiplication	fitpeach3	Excel Worksheet Functions	2	September 19th 06 11:07 PM
avoiding multiplication	weeclaire	Excel Discussion (Misc queries)	4	April 7th 06 02:07 PM
Matrix Multiplication	Jeff	Excel Discussion (Misc queries)	1	January 18th 06 08:15 PM

All times are GMT +1. The time now is 04:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us