formulas

[voyager_kate54]

Can someone please help with a formula for multiple cells. I am doing
inventory. I need to multiply quantity (column g) times cost (column k) to
equal in column m. I have been entering the formula singlely for each cell
but it is time consuming. I know there is an easier way, just can't figure it
out. HELP

 

[Barb Reinhardt]

Have you tried copying the formula you have for one row to the other rows in
question. Alternatively, you can drag the formula down as needed.

 

[voyager_kate54]

formula is such for example =g100*k100 target cell is column m so the target
for total is m100. i am not sure how to copy formula, when i try, it asks if
i want to change the destination of cells. i am confused as to how to copy
just the formula and make it work for multiple cells. thank you for your
assistance