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 ToolsAuditingEvaluate 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.