DON'T FORGET TO DO THIS.ĭoing this will help you to evaluate why a formula doesn't work or it can help to understand how the formula actually does what it does, which is a great learning tool because you can go back in the formula using the same procedure to make sure that you understand correctly what is happening. But not on my new Mac (El Capitan Excel for Mac 2015). To calculate a value of a specific part of a formula within the formula bar you just highlight the specific part, enter F9 and the calculated value appears in the formula. Hit Ctrl + Z to return the formula to its proper form. Excel for Mac: Calculation of an 'Interim result' with F9 in a formula within the formula bar. If you don't, those values will replace the elements of the formula.not what you want.Īt this point, you can click on another element of the formula to select it and hit F9 to see what is going on in that part. To return the formula to its proper form hit Ctrl + Z. This can be values, TRUE AND FALSE, and it can also show errors. Hit F9 and the selected part of the formula will be changed to what that selection really is. If you click on the bold text, that part of the formula will be selected. The active part of the formula is in BOLD. You will see a dialogue box that shows the elements that the function uses. Click in the formula past the opening bracket following a function where the cell references start. The formula will appear in the Formula Bar. If you have a formula that you want to see how it is calculating, the F9 key is a great help.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |