Excel Function Help?

Question

I need a function that will multiply the (Row x, Column x) by (Row X, Column Y) and Post results in (Row X, Column Z). But I need to replicate it for all rows without changing the code. Maybe Something like (=Product ((Whatever Row, Column x), (Whatever Row, Column Y)) THe rows change every time, but the columns will always be the same. THanks!

Answer 1

well, type the equation
lik,
=(A1*B1)
this equation will placed the answer of cells A1*B1 in the desired cell
suppose u hav the answer in C1
but if u wanna hav A2*B2 in C2
A3*B3 in C3,
then, point in the right lower end of the C1 cell, the pointer will change in to a hand.then drag it downwards till u get whr u want to end the sequence. release it n VOILA.... u've got it.

n also if u wanna make somthin not to change, - to b xact), place a $ mark b4 it
for xampe, if u typed $A2*$B2, then the columns will not be chaned whrever u copy the formula.

Answer 2

Hopefully I understand you correctly, but I think what you are saying is that you need a formula to use down a column. It's the same formula every time, just different numbers? Remember that in Excel, Columns are represented by Letters of the Alphabet and Rows are represented by numbers. Here's the easiest way.

In the first cell at the top of the column type the following:

=1a*1b

then press enter.

Click on that cell and you will see a small black sqare in the lower right hand corner of the cell. That is the "fill handle" click on the square and drag it down the column as far as you need to. Excel will automatically paste the formula into the rest of the cells that you need.

Here's a quick way to remember any formula you need. Start with an equal sign (=) and then type the cell number you want (Example 1A, which is the first row, first column) and then use whatever operator you want: addition (+) subtraction (-) division (/) multiplication (*), and then type the other cell number you want, then press enter and the answer will appear. I hope this helps. As soon as you type that equal sign, excel will know that you are using a formula.

Answer 3

in cell (row x, column z) put an = sign and then click on the cell you want to multiply, the * sign, and the other cell. hit enter. Then go back to that cell, copy the cell. go to the other cells you want that formula in, highlight them. Paste special, formula.