
Evaluate a Formula in Microsoft Excel
How can you evaluate the results of your formula in Excel? There's actually several ways.
Use F9 Key
We have a formula in C1, and we want to know the first part's results.
Select A1*A2 in the formula bar to see its result, as shown:
Evaluate Formula
Another method is to select the cell with the formula and hit Tools®Auditing®Evaluate Formula. The underlined area is the area of the formula that will evaluate first. This more or less automates the F9 process described above, but you don't have to select each area in the formula bar.
Click evaluate to see the result of the underlined area.
Continue clicking it to see each portion of the formula's result. You'll eventually get a final result.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 19982014 by MrExcel Consulting  All rights reserved