I want to have the formula in a cell always constant. I know I can use "$B$5". But when I enter some value into that particular cell the formula is getting erased.

Can someone please help me with this?