Row functions

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I am very new to excel, so this question may be simple. How do I set
up a formula for an entire row, were the computer will divide the
numbers in each cell by (ex: 93), and then multiply. Thanks
 
Multiply by what?

If your row of numbers is row 2, starting in cell A2, and the number you
want to multiply by is in cell A1, then in cell A3 put the formula
=A2*$A1/93, then copy across the rest of your row.
 
To multiply all the numbers in a row by a value like 93, put 93 in a cell and
pull-down:

Edit > Copy

Then select the row (or all the cells in the row) and pull-down:

Edit > PasteSpecial and check the Muliply button in the Operation area
 
Numbers in column A

In B1 enter =A1/93 * 12 your value or another cell reference

Double-click on B1 fill handle to copy down.


Gord Dibben MS Excel MVP
 
Back
Top