Row functions
 

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

Row functions
 

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

"steve" wrote in message
oups.com...
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

Row functions
 

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
--
Gary''s Student - gsnu200738


"steve" wrote:

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

Row functions
 

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

On Mon, 20 Aug 2007 10:54:27 -0700, steve wrote:

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