# 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.`

``` (adsbygoogle = window.adsbygoogle || []).push({}); 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 The correct value of the week number Mixed reference Compare 2 columns Using conditional formatting to highlight dates The WEEK functions Create an online survey with Excel How to round in k\$ without formula? Function SEARCH Calculation of tenths, hundredths and thousandths with Excel XLS or XLSX file ? ```
``` This post has no tag ```
``` ```
``` Permanent link to this article: https://www.excel-exercise.com/analyze-a-formula-with-f9/ (adsbygoogle = window.adsbygoogle || []).push({}); Leave a Reply Your email address will not be published. Required fields are marked * Message: * Name: * Email: * Website: ```
``` Frédéric LE GUEN Follow Excel Exercice on Facebook Facebook Page (adsbygoogle = window.adsbygoogle || []).push({}); ```
``` Copyright All rights reserved to FLG Consulting Services Ltd (2017) Conception site web : Isidore, le majordome du Net Return to top Powered by WordPress and the Graphene Theme. ```
``` /* <![CDATA[ */ var hugeit_lightbox_obj = {"hugeit_lightbox_size":"17","hugeit_lightbox_width":"","hugeit_lightbox_transition":"none","hugeit_lightbox_speed":"200","hugeit_lightbox_href":"False","hugeit_lightbox_title":"false","hugeit_lightbox_scalephotos":"true","hugeit_lightbox_rel":"false","hugeit_lightbox_scrolling":"false","hugeit_lightbox_opacity":"0.301","hugeit_lightbox_open":"false","hugeit_lightbox_overlayclose":"false","hugeit_lightbox_esckey":"true","hugeit_lightbox_arrowkey":"false","hugeit_lightbox_loop":"true","hugeit_lightbox_data":"false","hugeit_lightbox_classname":"false","hugeit_lightbox_fadeout":"200","hugeit_lightbox_closebutton":"true","hugeit_lightbox_current":"image","hugeit_lightbox_previous":"previous","hugeit_lightbox_next":"next","hugeit_lightbox_close":"close","hugeit_lightbox_iframe":"false","hugeit_lightbox_inline":"false","hugeit_lightbox_html":"false","hugeit_lightbox_photo":"false","hugeit_lightbox_height":"","hugeit_lightbox_innerwidth":"false","hugeit_lightbox_innerheight":"false","hugeit_lightbox_initialwidth":"300","hugeit_lightbox_initialheight":"100","hugeit_lightbox_maxwidth":"768","hugeit_lightbox_maxheight":"500","hugeit_lightbox_slideshow":"false","hugeit_lightbox_slideshowspeed":"500","hugeit_lightbox_slideshowauto":"false","hugeit_lightbox_slideshowstart":"start slideshow","hugeit_lightbox_slideshowstop":"stop slideshow","hugeit_lightbox_fixed":"true","hugeit_lightbox_top":"false","hugeit_lightbox_bottom":"false","hugeit_lightbox_left":"false","hugeit_lightbox_right":"false","hugeit_lightbox_reposition":"false","hugeit_lightbox_retinaimage":"true","hugeit_lightbox_retinaurl":"false","hugeit_lightbox_retinasuffix":"@2x.\$1","hugeit_lightbox_returnfocus":"true","hugeit_lightbox_trapfocus":"true","hugeit_lightbox_fastiframe":"true","hugeit_lightbox_preloading":"true","hugeit_lightbox_title_position":"5","hugeit_lightbox_style":"1","hugeit_lightbox_size_fix":"false","hugeit_lightbox_watermark_width":"30","hugeit_lightbox_watermark_position":"3","hugeit_lightbox_watermark_img_src":"https:\/\/www.excel-exercise.com\/wp-content\/uploads\/2016\/09\/Emoji-A-chier.gif","hugeit_lightbox_watermark_transparency":"100","hugeit_lightbox_watermark_image":"false","hugeit_lightbox_type":"old_type","lightbox_top":"false","lightbox_bottom":"false","lightbox_left":"false","lightbox_right":"false"}; /* ]]> */ /* <![CDATA[ */ var lightbox_type = "old_type"; var is_watermark = "false"; var ajaxUrl = "https:\/\/www.excel-exercise.com\/wp-admin\/admin-ajax.php"; var get_post_id = {"site_url":"https:\/\/www.excel-exercise.com","admin_ajax_url":"https:\/\/www.excel-exercise.com\/wp-admin\/admin-ajax.php","post_id":"336"}; var get_post_id_ = [""]; /* ]]> */ /* <![CDATA[ */ var wpcf7 = {"apiSettings":{"root":"https:\/\/www.excel-exercise.com\/wp-json\/contact-form-7\/v1","namespace":"contact-form-7\/v1"},"recaptcha":{"messages":{"empty":"Please verify that you are not a robot."}},"cached":"1"}; /* ]]> */ /* <![CDATA[ */ var ezTOC = {"smooth_scroll":"1","scroll_offset":"30"}; /* ]]> */ ```