Quotients in rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Using the Fill Handle & dragging the formula B1/B2 to C5, D5, etc., the
formula still states B1/B2 in these cells
 
you have to put an equal sign in the formula
=B1/B5
Make sure all the cells format as General, not Text
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opposite direction 9
Insert columns and values programmatically with IF statement 9
how do I create a nonadjacent series for autofill to go by? 3
Is there a formula that can do this? 3
SUM determined by drop-down list 9
IF function 1
SORT data containing formula 5
concatenate in combination 3

Back
Top