h1

EVALUATING COMPLEX FORMULAS

October 5, 2010

We have all received a formula from a colleague trying to be smart and found it difficult to understand the make-up thereof. Excel provides a tool to evaluate the results and make-up of a formula in the form of the ‘evaluate formula’ button in the ‘formulas’ tab in the ribbon. With the cell selected, click the ‘evaluate formula’ button and then click the ‘evaluate..’ button multiple times. Each time it is clicked the next parameter in the formula/function is evaluated.

 

Evaluate Formula

Evaluate Formula

 

This is a very useful feature for understanding a complex formulas and for troubleshooting such formulas.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: