Use this keyboard shortcut to evaluate parts of a formula. This is not really a keyboard shortcut per se, but rather just a trick you can use to find out how Excel evaluates parts of a formula as it calculated. This is a great way to check a formula to find out how it works, or to debug a formula when it isn't working properly. See this video for a demonstration of F9 to evaluate parts of a formula.
When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s.