Audit a Formula with F9

Audit a Formula with F9
Last Updated on 12/05/2024
Reading time: 2 minutes

In Excel, you can audit your formula by analyzing each part of your formula with the shortcut F9

When using the F9 shortcut?

Let's say you have a complex formula with many functions VLOOKUP, INDEX, MATCH. But the result returned is incorrect, and you must find the reason.

Tips: Press Alt + Enter to add a break line to display your formula on multiple rows.

How do you audit a formula with the f9 key?

Select part of your formula with the mouse

And then press F9

As you can see, the result is displayed in place of your selection 🙂😎😍

Avoid this mistake ⛔

But be aware of this! If you press Enter at this step, the result will overwrite this part of your formula, and you will lose the formula you selected.

So, what do I do? 🤔

Don't press Enter but to leave edit mode, use

  • the Escape key
  • or Ctrl+Z

Tutorial video

Have a look at this video to see more examples to audit a formula with f9

Test a condition with F9

Now, if you want to visualize the result of a test, you have to select the full test (the 2 parts of the test and the comparison sign).

Press F9, and the test result will be displayed in your formula (instead of the formula selected).

UPDATE Excel 365

A recent Excel 365 update integrates this feature directly when you select a part of your formula.

  • The result of the selection appears directly in a tooltip
  • The size of the font is very small 🧐
  • This is why F9 is still useful

Leave a Reply

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

Audit a Formula with F9

Reading time: 2 minutes
Last Updated on 12/05/2024

In Excel, you can audit your formula by analyzing each part of your formula with the shortcut F9

When using the F9 shortcut?

Let's say you have a complex formula with many functions VLOOKUP, INDEX, MATCH. But the result returned is incorrect, and you must find the reason.

Tips: Press Alt + Enter to add a break line to display your formula on multiple rows.

How do you audit a formula with the f9 key?

Select part of your formula with the mouse

And then press F9

As you can see, the result is displayed in place of your selection 🙂😎😍

Avoid this mistake ⛔

But be aware of this! If you press Enter at this step, the result will overwrite this part of your formula, and you will lose the formula you selected.

So, what do I do? 🤔

Don't press Enter but to leave edit mode, use

  • the Escape key
  • or Ctrl+Z

Tutorial video

Have a look at this video to see more examples to audit a formula with f9

Test a condition with F9

Now, if you want to visualize the result of a test, you have to select the full test (the 2 parts of the test and the comparison sign).

Press F9, and the test result will be displayed in your formula (instead of the formula selected).

UPDATE Excel 365

A recent Excel 365 update integrates this feature directly when you select a part of your formula.

  • The result of the selection appears directly in a tooltip
  • The size of the font is very small 🧐
  • This is why F9 is still useful

Leave a Reply

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