[Solved] Continuous Function down a Column?

[chuck_747]

OK I can explain this I am trying to create a spread sheet that has 4 Columns and 200 rows (easy) They are titled as Name | Sell Price | Amt. Sold | Income.

that's the easy part now i know there must be a way to do this i just cant figure it out ... OK i would like to Multiply (Sell Price ) and ( Amt. Sold) to Equal (Income)
easy to do one at a time D2=B2*C2 ( BUT 200 TIMES !!) What i need is a way to BASICLY do this D#=B#*C# ( Having the formula add in current row in it respective place ) .... So i guess Select all of Column D = Column B* Column C but add the proper answer for each row???? I hope that makes sense .. please help its for work Monday.

Thanks

[RoryOF]

You should look at the
Tutorial on Absolute, Relative and Mixed references

[kingfisher]

As you say, in D2 enter the formula =B2*C2

With the cell pointer still in D2, grab the bottom right corner and drag it down to the 200th row. The formula will copy into the cells and the row number will change in each cell. Because you are copying the formula in the same column, you do not need to worry about absolute references but it is worth looking at that tutorial.

[chuck_747]

Awsome thanks... I new there was a way to do it.. I apreciat the help