Product formula help
 

Hi there,

I'm new here so I don't know if this kind of a question was here before ;)
Here's the problem: On a worksheet I have two columns with about 100 or even
more rows and in every filed there is a number (i.e. in A1 is typed for
example 100, in A22 is typed 65983, in B3 is typed 456...) and in the third
column (C) I have to make a product of the A and B field in the same row
(i.e. if in A1 is a number such as 100, in B1 number 50, in the field C1 has
to print 5000 with a function).

Is there a short way, a some kind of formula that makes a product of two
fileds in the same row (A1, B1) and prints that product in the third filed
(C1). It would realy help couse there are just too many rows for me to type
in each one of the 'C' row =A1*B1 etc...

Thx

--
How does it sound when Darth Vader snores?!

After you enter in C1;

=A1*B1

Re-select C1.

You'll see a small black square in the lower right corner of the selected
cell.
This is called the "fill handle".

As you pass the cursor over this square, the cursor will change from a fat
white cross, to a skinny black cross.

At this point, you can click and drag the cursor down the column, copying
the contents of C1 to the other cells in Column C.
The formula will also change automatically, so as to reference each of the
cells in Columns A & B.
This occurs because the formula was created with "relative" references
(A1*B1).

If the formula was entered with "absolute" references ($A$1*$B$1),
The formula would still copy down Column C, but the cell addresses would
remain the same, and *not* change.

This helps if you might want to multiply each cell in Column A with the
*same* cell, say D1.
=A1*$D$1

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Elbowhite" wrote in message
...

Hi there,

I'm new here so I don't know if this kind of a question was here before ;)
Here's the problem: On a worksheet I have two columns with about 100 or
even
more rows and in every filed there is a number (i.e. in A1 is typed for
example 100, in A22 is typed 65983, in B3 is typed 456...) and in the
third
column (C) I have to make a product of the A and B field in the same row
(i.e. if in A1 is a number such as 100, in B1 number 50, in the field C1
has
to print 5000 with a function).

Is there a short way, a some kind of formula that makes a product of two
fileds in the same row (A1, B1) and prints that product in the third filed
(C1). It would realy help couse there are just too many rows for me to
type
in each one of the 'C' row =A1*B1 etc...

Thx

--
How does it sound when Darth Vader snores?!

You can copy C1 and paste it into C2:C100, or just simply put your mouse
on the lower right corner of C1 and drag the cell down.


Elbowhite Wrote:
Hi there,

I'm new here so I don't know if this kind of a question was here before
;)
Here's the problem: On a worksheet I have two columns with about 100 or
even
more rows and in every filed there is a number (i.e. in A1 is typed
for
example 100, in A22 is typed 65983, in B3 is typed 456...) and in the
third
column (C) I have to make a product of the A and B field in the same
row
(i.e. if in A1 is a number such as 100, in B1 number 50, in the field
C1 has
to print 5000 with a function).

Is there a short way, a some kind of formula that makes a product of
two
fileds in the same row (A1, B1) and prints that product in the third
filed
(C1). It would realy help couse there are just too many rows for me to
type
in each one of the 'C' row =A1*B1 etc...

Thx

--
How does it sound when Darth Vader snores?!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=398415