![]() Once you're in Edit Mode, you can use the F9 key to check the calculated value of any part of the formula.Īlthough you can select parts of the formula manually, the Function Tooltip makes it much easier to select things precisely. And you may want to expand the formula bar to give yourself more space to work. ![]() In general, it's easier to debug a formula in the formula bar. Now let's use the F9 key to see what the STATUS formula is doing. You can see that both Age and Status are calculated values. You can do this quickly by using Go To Special > Formulas. We've covered this before, but whenever you inherit a new worksheet, make sure you understand first where the formulas are. In addition to names, we have a column for birthdate, a column for age, and a column for legal status. In this video, we'll look at how to use the F9 key to quickly break a formula down into pieces that you can understand. One thing you'll frequently do in Excel is check or debug formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |