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
|