Hit Ctrl + Z to return the formula to its proper form. 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 |