Evaluate Formula
Evaluate Formula helps you inspect a formula’s calculation process step by step. It provides the tools you need to trace calculation logic and locate errors in complex formulas, making your work more efficient and helping you accomplish tasks with ease. With Evaluate Formula, you can select a cell that contains a formula, review the current formula content, identify the parameter currently pending evaluation, use Step In to view referenced cell values, use Evaluate to perform one calculation step at a time, and use Step Out to return from nested references to the outer formula. Whether you're checking referenced values, analyzing nested functions from the inside out, or finding where a regular formula goes wrong, Evaluate Formula helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.