| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula down - cell references change - result is same for al
Hello,
I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same foral
ace wrote:
Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! Check that calculation is set to automatic. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Make sure calculation is set to automatic.
Excel 2007: Formulas tabCalculationCalculation OptionsAutomatic All other versions of Excel: ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "ace" wrote in message ... Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Hi,
My guess is that calculation has been turned to manual. Do the formula update if you tap F9? If so E2003 Tools|Options - Calculation tab and select automatic E2007 Office button - Excel options - Formulas and select automatic Mike "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same fo
Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how did it get set to Manual? :-) -- ace "Mike H" wrote: Hi, My guess is that calculation has been turned to manual. Do the formula update if you tap F9? If so E2003 Tools|Options - Calculation tab and select automatic E2007 Office button - Excel options - Formulas and select automatic Mike "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same fo
ace wrote:
Thanks to all of you smart people who knew the answer to my problem. It was in fact the manual setting in the formula options. My next question is, how did it get set to Manual? :-) Excel uses the calculation setting from the first workbook that is opened. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula down - cell references change - result is same for al
Do you have auto or manual calculate on the spreadsheet? Go to tools,
options, calculation and see what your settings are. You may need to change it to Automatic Calculation. "ace" wrote: Hello, I am having this problem: 1. I enter this formula in cell D1: A1 + B1 - C1 2. The result is 10 3. I copy the formula down the column 4. All the results in column D are 10 even though the cell references are adjusted for the new row Help! Thanks! -- ace |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update/change cell references in a formula | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| how do i copy a formula when cell references r not together | New Users to Excel | |||
| How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
| how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
Hybrid Mode
