Skip to main content

Evaluate the formula - step by step process

Evaluate the formula - step by step process

This is the best trick to debug the complex formulas, each part of the formula can be evaluated individually.

Step 1: Please select a cell with formula, then click on Evaluate formula under Formulas menu or tab
Step 2: Dialogue box appear, click on evaluate which shows the result of the formulas in step by step process


Once done click on close button.


Labels:

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more