formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
Sum and Percentage Question... 2
writing a formula 3
formula for adjusting price 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Change formulas in a column based on a selection. 3
Excel A CountIF question... I think 2
IF functions 2

Back
Top