Excel N00b :(

[Yzzim]

I need to take one cell and multiply it by another cell and have the answer appear in another cell.

Example: Here is the forumla I have now pasted in cell E9

PRODUCT(C99)

Now how do I get that function to repeat throughout the spreadsheet? So C10 will multiply by D10 and give me the answer in E10, and so on.

Big thanks to anyone that can help me out!

 

[AtTheGates]

Click on cell E9. A black border surrounds the cells and there is a small black box in the lower right corner. Click and hold on the lower right corner and drag it down as far as you want. Double click here will copy down automatically if there is something in the left column. Copy & paste also works.

 

[Yzzim]

Originally posted by: AtTheGates
Click on cell E9. A black border surrounds the cells and there is a small black box in the lower right corner. Click and hold on the lower right corner and drag it down as far as you want. Double click here will copy down automatically if there is something in the left column. Copy & paste also works.

Wow, that seems waaaay too easy.

Thank you very much!