Your visual formula will appear here…
Formula Summary
Formula Length0
Output Length0
Nesting Depth0
Parts Edited0
Complexity0
Performance0
Error Guards0
Arrays0
Functions0
Volatile Funcs0
Editable Parts0
Ranges0
Strings0
Numbers0
Booleans0
Operators0
Punctuation0
How to Use This Tool 📝
- Enter Formula: Type or paste your formula into the input box, or select a pre-built example from the dropdown.
- Edit & Update: In the editor, click directly on any colored part (like a range or number) to change its value. The “Live Formula Output” updates instantly.
- Switch Views & Themes: Use the controls in the “Editor” tab to change how the formula is displayed or to select a different color theme.
- Full Formula: The default, interactive view that mimics a formula bar.
- Tree View: Shows the formula’s structure, making it easy to understand nested functions.
- All Editable: A simple list of every single editable part for quick, repetitive changes.
- Unique Editable: Groups identical parts. Editing one instance (e.g., a range) updates all its duplicates in the formula.
- Review Summary: Switch to the “Formula Summary” tab for a detailed analysis, including complexity, performance scores, and a count of all components.