Answer for using the “$” to lock a fomular

https://365datascience.com/dwqa-answer/answer-for-using-the-to-lock-a-fomular/ -

Hi Abieyuwa, 

when we have C$5:C$61 we are fixing the rows. That means when we copy the formula we’re insuring we’ll remain between the rows 5 and 61, which is where our values are.

On the other hand, when we have $B61 we’re fixing the column. That means when we copy this formula we’re sure we’ll remain in the same column. Here we copy the values for code, which are all in column B.

To recap:

1. If we fix before the letter, i.e. $A1, $B1, $C1 and so on, we’re fixing the column.

       2. If we fix before the numbers A$1, A$2… we’re fixing the row.

       3. If we fix both $A$1, we’re fixing both row and column. This ensures the value won’t change or shift position, when we copy it.

 

Best, 

Eli

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy