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?)

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?)

.