From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using evaluation in Excel

Using evaluation in Excel - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Using evaluation in Excel

Formulas can get very complicated very quickly. So when you start getting answers that don't look right or maybe you just want to double check to see that they are right, the Evaluation feature can help you examine a formula piece by piece. If you watched the movie on the IF function, this is a similar worksheet and here's what this worksheet is saying. It's looking at the sales of all of these people and it's evaluating, it's creating an average. If you take a look at any of the commission rates and look at this complicated formula, what the formula is doing is it's saying if the amount that the person's sold is at least average or average or above average, then let's give them a higher commission rate. If not, if they're selling below the average then we give them a lower commission rate and we're finding the commission rates over here in Column F. So let's go and evaluate this formula piece by piece to make some sense out of it. So go up to the Formulas tab and over here under…

Contents