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