Analyze a formula with F9

The shortcut key F9 allows you to view the result of a part of your formulas. For example, if you have a very complex formula (as in the video below) and this formula returns an error, the F9 key will help you to easily find which part of your formula contains the error and must be modified.

At this address , you'll find the parsing tool, created by Roberto Mensa, Krisztina Szabó and Gábor Madács. You can download it for free :) And you can review other Shorcut method to improve your speed with Excel

Related articles

Have a look at these other articles that could help you in your work

Permanent link to this article: https://www.excel-exercise.com/analyze-a-formula-with-f9/

Leave a Reply

Your email address will not be published. Required fields are marked *