![]() In cell C11, we see a formula that refers to the 3 cells above. ![]() There's no references in this formula, so this is just a one-off conversion. If I click into the first formula cell, I can see that it's using the CONVERT function to convert 3 pounds to grams. To make it easier to see which cells contain formulas, I'll go ahead and add a fill to these cells. When I click OK, all formulas in the worksheet are selected. We can easily do that by using Go To Special and then selecting Formulas. Let's take a look through the formulas in this model to see how they work.įirst, let's find all the formulas. ![]() Here we have a simple model that shows the expense of making coffee at home vs. In this video, we'll look at how to quickly find formulas and trace how they are related to one another using the concept of precedents and dependents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |