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