Quotients in rows
 

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.
I need B1/B2, C1/C2, D1/D2, etc. that will appear in B5, C5, D5, etc.
Thanks

Quotients in rows
 

In B5: =B1/B2
Drag the Fill Handle to copy from B5 to D5


"Sheba" wrote:

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.
I need B1/B2, C1/C2, D1/D2, etc. that will appear in B5, C5, D5, etc.
Thanks

Quotients in rows
 

Using the Fill Handle & dragging the formula B1/B2 to C5, D5, etc., the
formula still states B1/B2 in these cells

"Teethless mama" wrote:

In B5: =B1/B2
Drag the Fill Handle to copy from B5 to D5


"Sheba" wrote:

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.
I need B1/B2, C1/C2, D1/D2, etc. that will appear in B5, C5, D5, etc.
Thanks

Quotients in rows
 

you have to put an equal sign in the formula
=B1/B5
Make sure all the cells format as General, not Text

"Sheba" wrote:

Using the Fill Handle & dragging the formula B1/B2 to C5, D5, etc., the
formula still states B1/B2 in these cells

"Teethless mama" wrote:

In B5: =B1/B2
Drag the Fill Handle to copy from B5 to D5


"Sheba" wrote:

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.
I need B1/B2, C1/C2, D1/D2, etc. that will appear in B5, C5, D5, etc.
Thanks

Quotients in rows
 

ToolsOptionsCalculation.

Set it to Automatic.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 10:34:02 -0800, Sheba
wrote:

Using the Fill Handle & dragging the formula B1/B2 to C5, D5, etc., the
formula still states B1/B2 in these cells

"Teethless mama" wrote:

In B5: =B1/B2
Drag the Fill Handle to copy from B5 to D5


"Sheba" wrote:

Numbers (Dividends) are entered in Rows B1 to M1.
Divisor numbers are entered in Rows B2 to M2.
I would like quotients to appear in Rows B5 to M5.
How do I enter a formula in B5 that can be copied through to M5.
I need B1/B2, C1/C2, D1/D2, etc. that will appear in B5, C5, D5, etc.
Thanks