Make Cell equal to result of other cell formula

This seems like it should be a fairly easy thing to do but I can't figure it out. I would like to make one cell equal to the value of another cell. That other cell has a formula which is dependant on yet another few cells. I know that I can copy and then do "paste special" and choose to paste only the "value", but I need that to happen automatically.

Example:

Please Login or Register  to view this content.

In K41 if I type in

Please Login or Register  to view this content.

the result is "#VALUE!"

I have this problem in many areas that I think could easily be fixed if I could do something where I can say that K41 = the value of K40 (not the formula that is in K40 but the actual result of that formula) times 15.

Thanks for any thoughts.