The linking of cell D8 to cell B5 ensures that any updates in the formula of the latter are automatically reflected in the range D9:D19 of the data table. ![]() ![]() Had we not linked cells D8 and B5, any changes to the formula of cell B5 would not have changed the value in cell D8.įor instance, if the formula of cell B5 is multiplied by 2, all the outputs obtained in the range D9:D19 are automatically multiplied by 2. Consequently, the outputs in the range D9:D19 would not have been updated automatically. ![]() Cell D8 shows the value of cell B5, as shown in the following image.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |