to put (say) 0.5 times the value of ANY other cell in an active cell :
in the active cell type =0.5*
then click the cell that you want 0.5 OF.
to copy a value from one cell to another (even text):
in the cell where you want the answer type = and then select (pick) the cell you want to copy.