The Evaluate Formula window allows you to work with complex formulas to see if they are working properly by calculating one step at a time, showing the calculation first and then the result of each argument in the formula. Evaluating formulas while you are developing them allows you to make sure that they are functioning as you planned.