Ganesh wrote on Sat, 23 Aug 2008 11:36:00 -0700:

Ganesh wrote on Sat, 23 Aug 2008 11:12:00 -0700:

Hello friends i know how to multiply a single row or column
that if i want that Multiply A1 and A2 then i write in my
desire box "=A1*A2" thats it.

But the problem is this that i want to multiply all data of
the A row with B row and want to show in C how i can.

It could be done with an array formula: Select say, C1:C8,
=A1:A8*B1:B8, Ctrl Enter.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not


First try using a signature after your response, it makes it less work
for me. You might also want to read up on Array Formulas; they are
useful.

I dont know where i type the array formula, can u please tell me the
full procedure

Taking my example, Select C1:C8, in the formula bar put =, then select
A1:A8, insert *, select B1:B8; give Ctr--enter.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not