Multiplier Sheets

[Thermterra]

Hello,
How do you multiply a column and have the results reappear in the nextcolumn? E3:E3631*1.3 = F3:F3631, is the code I tried.

 

[MrKowz]

In cell F3, enter =E3*1.3 then copy the formula down by clicking and dragging the little black box that appears in the bottom right of the cell you are on. If you want the results in column F to never change, then after you use the formula, highlight column F, right click on it and click "copy". Then right click it again and "paste special", choose "Values", and click OK. This will "hardcode" the results in the column and overwrite the formulas.

 

[Thermterra]

Thankyou very much! It worked well.

 

[Arlene012248]

startthe three store sheets. First compute the sum in cell B 4 and then compute the average in c5. Copy the rnge b4:C5 to the rnge b5:c11. The firt sheet should resemble figure 6-65. I do not know how to start a forum so i hope you can help me Arlene012248