Sometimes we want to freeze the values in the formula or function. This is used when you want to copy or pasting functions in several places, but we do not want to risk that Excel, when copying, I was disturbed. We wish to make clear that, wherever there is a function, we would always refers to one and the same cell. Then you need to put the absolute value function. We do so as we stand on the function, in addition to the value for which it is to be absolute and click on F4. Then will appear in the function of a dollar sign. We do this for each value in the formula. For example, there are two values, therefore, be two way to squeeze F4 while the cursor is standing next to each value.
