LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peco Worker
 
Posts: n/a
Default Copy Function into other cells

I am trying to copy a easy function, =SUM(b10-B11), into other cells in the
same column and it will not work. It gives me the correct formula but it
gives me the same answer as the cell copied from.

So if I start with b10-b11 and then copied it down into c10-c11, it changes
the formula correctly. If the answer in for b10-b11 is 50 and the anwser for
c10-c11 is 45 it still answers it as 50.

Has anyone else ever had this problem?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing worksheet cells from within a function James4U2enjoy Setting up and Configuration of Excel 1 October 14th 05 02:16 PM
Using SUM function with #N/A in some cells Jeeper Excel Worksheet Functions 5 June 10th 05 06:28 AM
write a function to determine if cells have names andrewm Excel Worksheet Functions 5 June 9th 05 07:28 PM
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"