Creating formula

  • Thread starter Thread starter JohnB
  • Start date Start date
J

JohnB

How would I do this (in Excel 2007)?

I have 2 columns of numbers. I would like to divide column B by column A
and put the result in the next, blank column over. And then do that for
each line.
I have no clue. How would I do that? Thanks.
 
Maybe, you can fill that third column with a bunch of formulas:
=b1/a1

Or to avoid errors if A1 is 0:
=if(a1=0,"",b1/a1)
 
True, but how would I do it for the entire spreadsheet?
It seems that the row number would need to be a variable?
 
The easiest way to copy an incremented formula down a column is to
double-click on the fill handle.

Fill handle is the small black lump at right bottom corner of the cell.

Hover pointer over that lump and a small cross will appear.

D-click on that to fill down.

If the data in the adjacent column is non-contiguous left-click on the fill
handle and drag down.

The row numbers will increment.

See help on relative and absolute cell references for more.


Gord Dibben MS Excel MVP

True, but how would I do it for the entire spreadsheet?
It seems that the row number would need to be a variable?
Click to expand...
 
That worked perfect.
Thanks, I learned something new.


Gord Dibben said:
The easiest way to copy an incremented formula down a column is to
double-click on the fill handle.

Fill handle is the small black lump at right bottom corner of the cell.

Hover pointer over that lump and a small cross will appear.

D-click on that to fill down.

If the data in the adjacent column is non-contiguous left-click on the
fill
handle and drag down.

The row numbers will increment.

See help on relative and absolute cell references for more.


Gord Dibben MS Excel MVP
Click to expand...
 
Hi,

Another alternative is to copy column B to column C and then select column A
and copy it. Select column C and choose Edit, Paste Special, Divide
 
Back
Top