Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula copies value from original cell only
Trying to copy a simple formula (=e2*3) to the next cell. If the cell I am
copying equals 5, the value is posted to cell to which I ma copying and not the appropriate result. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula copies value from original cell only
Not sure if I understand do you want the formula to be copied to the next
cell or the actual result of the formula (that being 5)? If you want to copy and paste the result use copy....paste special.....values. "smaem" wrote: Trying to copy a simple formula (=e2*3) to the next cell. If the cell I am copying equals 5, the value is posted to cell to which I ma copying and not the appropriate result. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula copies value from original cell only
Tools/ Options/ Calculation
Set to Automatic, not Manual. -- David Biddulph "smaem" wrote in message ... Trying to copy a simple formula (=e2*3) to the next cell. If the cell I am copying equals 5, the value is posted to cell to which I ma copying and not the appropriate result. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Is There a Formula that copies another cell exactly in Excel? | Excel Discussion (Misc queries) | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
hyperlinks following in copies of original file | Excel Discussion (Misc queries) |