| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
pasting formula doesn't work
I use excel all the time & have not encountered this before except when
copying and pasting formula related to pivot table data. I copy a cell with a formula, when I paste it the formula is correct but the result isn't, it just returns the value of the copied cell so for example a1/b1 = 10.35 the formula will show as a2/b2 but the result will still be 10.35 even 'though it should be, for example, 24 Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
| How does this formula work | Excel Worksheet Functions | |||
| Copying & Pasting Formula | Excel Discussion (Misc queries) | |||
| Trouble copying and pasting a formula | Excel Worksheet Functions | |||
| formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions | |||
Threaded Mode
