Showing Formula Calculation Steps In Excel
2. Click formula (1), then click evaluate formula (2).
3. Click on Evaluate
Note: Keep clicking evaluation to evaluate all your formulas. This is incase you’d have multiple formulas like
The A2 to A6 is one formula, and B2 to B5 is another. Repeating to click on evaluate will show the result of A2:A6, and B2:B5 respectively.