Row functions

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
 
D

David Biddulph

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

Gary''s Student

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
 
G

Gord Dibben

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
 
Top