HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?
 

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.

HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?
 

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.


--
a7n9


------------------------------------------------------------------------
a7n9's Profile: http://www.excelforum.com/member.php...o&userid=32149
View this thread: http://www.excelforum.com/showthread...hreadid=562926

HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?
 

Enter your new price in an empty cell.

Copy that cell.

Select the date range and Paste SpecialMultiplyOKEsc.

Delete the contents of the new price cell.


Gord Dibben MS Excel MVP

On Wed, 19 Jul 2006 09:01:01 -0700, jcpayne
wrote:

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.