View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheba Sheba is offline
external usenet poster
 
Posts: 6
Default 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