Quotients in rows

S

Sheba

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
 
S

Sheba

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

Teethless mama

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