| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quotients in rows
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Quotients in rows
ToolsOptionsCalculation.
Set it to Automatic. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 10:34:02 -0800, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Linear Mode
