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

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.

" wrote:

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

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


"Barb Reinhardt" wrote:

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.

" wrote:

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