> ## Documentation Index
> Fetch the complete documentation index at: https://sheets-docs.elkar.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Formula Tracing 

> Understand any Excel formula in plain English. Debug complex calculations and optimize performance.

## Never get lost lost again

Decode any complex formula in seconds whether you built it or inherited it.

* Understand formulas built by previous team members
* Decode complex financial models
* Figure out why calculations seem wrong

## What Elkar Explains

<CardGroup cols={2}>
  <Card title="Complex Formulas" icon="function">
    **Nested IF statements**, SUMPRODUCT, array formulas, and advanced functions
  </Card>

  <Card title="Dependencies" icon="link">
    **What cells affect this formula** and how changes will impact results
  </Card>

  <Card title="Logic Flow" icon="chart-network">
    **Step-by-step breakdown** of how the calculation works
  </Card>

  <Card title="Business meaning" icon="business-time">
    \*\*Understand the logic \*\*behind models and draw clear business insights from the data
  </Card>
</CardGroup>

## How It Works

1. **Click on any cell** with a formula you want to understand
2. **Hit "Trace"** and **click the +** on the right
3. **Explore** the explanation and **retrace** every sub-calculations

<Tip>
  **Pro tip:** Use formula tracing when taking over someone else's spreadsheet. It's like having the original builder explain their work.
</Tip>

## Live Demo: Tracing

<iframe className="w-full aspect-video rounded-xl" src="https://www.youtube.com/embed/u9_Mpf8CU2U?autoplay=1&mute=1=1&loop=1&playlist=u9_Mpf8CU2U" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />

***