HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?

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

Guest

I am trying to enter a formula to calculate an entire row.

example: i want to take the total in each cell and multiple it by a new price.
 
If you're saying there are numbers from cell A1 to A10 and you want to
multiply each cell by let's say 10, then a single formula won't do it.
But you could drag the formula that would automatically calculate the
expected formula.
 
Enter your new price in an empty cell.

Copy that cell.

Select the date range and Paste Special>Multiply>OK>Esc.

Delete the contents of the new price cell.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1
Conditional Formatting for entire row 4
How do I find & replace pieces of a formula? 4
hidden rows problem 7
move a row of data from one work sheet to another using a formula 1
using the =page! feature to transpose a row to column 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top