If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How is it that a cell can transfer the correct formula, but th
The formula is a simple B8-C8. Normally when a formula is copied and entered
into other cells it adjusts for being placed in a different row or column. However, if we past the formula a row lower (B9-C9) it shows the correct formula but the value from the row it was copied from. So, if B8-C8 = 11, then the number 11 shows up in the cell with B9-C9 even if it should total 25. One way we have found to fix it cell by cell is that if we hit ENTER a second time after the formula has been pasted it will clear the wrong value and apply the formula. However, for a large spreadsheet, this can be rather time consuming. "Peo Sjoblom" wrote: What's the formula? What's the result? What do you expect? Regards, Peo Sjoblom "kbigs" wrote: When we copy and paste a cell that has a formula in it, it is transferring the row adjusted formula, but the value from the cell that it was copied from. The settings in paste special are all correct. Any suggestions? |
#2
|
|||
|
|||
Sounds like your calculation is set to manual.
Tools Option Calculation tab, And make sure "Automatic" is checked. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "kbigs" wrote in message ... The formula is a simple B8-C8. Normally when a formula is copied and entered into other cells it adjusts for being placed in a different row or column. However, if we past the formula a row lower (B9-C9) it shows the correct formula but the value from the row it was copied from. So, if B8-C8 = 11, then the number 11 shows up in the cell with B9-C9 even if it should total 25. One way we have found to fix it cell by cell is that if we hit ENTER a second time after the formula has been pasted it will clear the wrong value and apply the formula. However, for a large spreadsheet, this can be rather time consuming. "Peo Sjoblom" wrote: What's the formula? What's the result? What do you expect? Regards, Peo Sjoblom "kbigs" wrote: When we copy and paste a cell that has a formula in it, it is transferring the row adjusted formula, but the value from the cell that it was copied from. The settings in paste special are all correct. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula not producing correct result | Jerry W. Lewis | Worksheet Functions | 1 | May 7th, 2004 04:45 AM |
Is this formula correct? | Dave R. | Worksheet Functions | 2 | May 4th, 2004 07:28 PM |
Does cell contain a formula? | Frank Kabel | Worksheet Functions | 4 | February 24th, 2004 09:09 PM |
copying and controling a formula cell to cell | kevin | Worksheet Functions | 5 | February 13th, 2004 01:26 PM |
Formula help | Wally | Worksheet Functions | 6 | December 5th, 2003 12:18 PM |