Beyond the Help files . . .

 

 

Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows  ¨  Free Downloads


 


 

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.

 

Back to top...

 

 

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 © 1998-2014 by MrExcel Consulting | All rights reserved