| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to keep the value of a cell not a function of the other cell
cell D3 =10*ROUND((C3*1.1)/10,0)
Now I copied D3 to E3. (E3=D3) I have the result on E3 now. I want to do one of the two: 1. changing the value if C3, but I want E3 not to change 2. I want to delete D3 and C3, but I want the value in E3 to stay with no change. Thanks galsaba (is the function E3=#D3?) |
|
#2
|
|||
|
|||
|
Hi!
Make cell E3 a constant: Select E3 Goto EditCopy Then EditPaste SpecialValues OK Biff -----Original Message----- cell D3 =10*ROUND((C3*1.1)/10,0) Now I copied D3 to E3. (E3=D3) I have the result on E3 now. I want to do one of the two: 1. changing the value if C3, but I want E3 not to change 2. I want to delete D3 and C3, but I want the value in E3 to stay with no change. Thanks galsaba (is the function E3=#D3?) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
