# How to Debug Complex Formulas in Coda

> To debug complex formulas in Coda, reference values from anywhere in your doc, break the formula into smaller parts, and add base price and tax rate to calculate subtotal cost. Verify that columns exist and data types match, test the formula with different values, and watch the total price column recalculate automatically when inputs change.

Canonical: https://livedemo.ai/tutorials/how-to-debug-complex-formulas-in-coda/
Apps: Coda
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3ad6ab56e05a00fe1fd9/preview?step=1

## Steps

1. Here's the base price value that we'll use in the formula.
2. Values can be referenced from anywhere in your doc, making formulas more flexible.
3. Let's break down this formula into smaller parts to understand what's happening.
4. This simple formula adds base price and tax rate to calculate the subtotal cost.
5. Make sure your columns exist and values match the expected data type (text, number, list, etc.).
6. When you change Base Price, Subtotal, or Shipping Fee, the Total Price column recalculates by itself.
7. Test your formula with different values to ensure it works correctly in all scenarios.