When using Evaluate Formula, common questions usually focus on button differences, window display, and nested function support; this FAQ includes 3 common questions and 3 glossary terms.
FAQ
What is the difference between Step In and Evaluate?
- Step In is used to open the currently underlined reference or inner formula content.
- Evaluate is used to perform the current calculation step and show its result.
- If you want to confirm a reference first, use Step In. If you want to continue the calculation path, use Evaluate.
What should I do if the content in the Evaluate Formula window is truncated?
- First, check whether the key part of the current formula is already visible.
- If the display is incomplete, drag the border of the pop-up window to enlarge the viewing area.
- After resizing the window, continue the evaluation steps to review the full formula more clearly.
Does Evaluate Formula support nested functions?
- Yes. It can review nested functions layer by layer in a complex formula.
- Use Step In to enter the current reference or inner level.
- Use Step Out to return to the outer formula and continue checking the overall logic.
Glossary
| Term | Definition |
|---|---|
| Evaluate Formula | A way to review a formula in its actual calculation order and display intermediate results and the current part being processed. |
| Step In | Opens the currently underlined reference or inner formula level so you can inspect its content. |
| Step Out | Returns from the current inner level to the outer formula so you can continue reviewing the full calculation flow. |