Centralized Billing
One invoice for the whole team, billed monthly or annually. Add seats as you grow — no per-seat surprises mid-cycle.
Spreadsheet Productivity
Six tools the formula bar should have had.
Everything you need to write, debug, and manage complex formulas without the headache.
Free plan — no credit card required.
Excel formula editor
A code editor, built for formulas.
Painless editing — our multi-line code editor brings code-grade readability to formulas with syntax highlighting, structured formatting, and indentation.
- Color-coded functions and ranges to easily spot errors or references.
- Auto-suggest for formula functions and range names as you type — no more memorizing every function name.
- Find & replace within formulas to quickly update field names or values.
- Dark mode and customizable font size for comfortable long work sessions.
editor.js
=IFS(
D14 > @@Threshold, “Approved”,
AND(D14 > 0, C14 = “VIP”), “Review”,
TRUE, “Reject”
)
D14 > @@Threshold, “Approved”,
AND(D14 > 0, C14 = “VIP”), “Review”,
TRUE, “Reject”
)
Convert Excel formulas to Google Sheets
Excel syntax support.
Compatibility mode converts Microsoft Excel™ formulas to Google Sheets™ and back, so you never get stuck rewriting formulas from scratch.
- Converts most Excel-specific functions (XLOOKUP, SUMIFS variants) to their Google Sheets™ equivalents — and alerts you when something can't be transferred.
- Identifies Sheets™ functions with different names in Excel (ARRAYFORMULA usage, date functions, etc.).
- Reduces migration headaches when moving legacy spreadsheets to Google Sheets™ for team collaboration.
- Accurate description for every formula in Google Sheets™ and Microsoft Excel™.
Excel
Sheets
=XLOOKUP(A2, D:D, E:E)=ARRAYFORMULA(XLOOKUP(...))Excel formula builder
Visual formula builder — no-code formula creation.
Build formulas step by step without writing a single character of code. The builder fills in the syntax for you while you focus on the logic.
- Real-time preview of the formula as it's built, so you learn the syntax as you go.
- Reduce errors by filling arguments through form fields with built-in validation.
- Add an endless number of nested groups and expressions without thinking about syntax.
- Reorder, edit, and remove parts of any formula with drag-and-drop simplicity.
Formula Builder
QUERY
SELECT A, B, SUM(C)
WHERE D = ‘Active’
WHERE D = ‘Active’
Google Sheets & Excel variables
Variables, finally.
Define values like exchange rates, tax rates, and constants once — then use them across your entire workbook. Change one number and 500 formulas update at the same time.
- Create and manage variables (exchange rates, constants, targets) in a dedicated sidebar. Update the value in one place.
- Use variables in formulas by name (e.g. @@TaxRate inside a formula) — Formula Foundry replaces them with the value behind the scenes.
- Ensure consistency: all team members use the same approved values — perfect for financial and business reporting integrity.
- Toggle or update variables for scenario analysis (see how a change to @@InterestRate ripples through every model).
The variable syntax is brilliant. Changing tax rate from 0.08 to 0.10 instantly updated 500+ formulas. Makes spreadsheets maintainable.
— Namrit Sheth, Data Analyst
{ } Variables
@@TaxRateSHEET
0.21
@@Q4_ForecastGLOBAL
=SUMIFS(…) * (1 + @@Growth)
Excel formula explainer & debugger
Your personal AI assistant.
Use AI to suggest formulas, explain complex ones in plain English, and debug errors — then fine-tune the result in the editor.
- Natural language to formula: speed up formula creation when you're not sure how to start.
- Formula explain: paste a confusing formula and get a step-by-step explanation in seconds — great for learning or auditing complex sheets.
- Error debug suggestions: when a formula isn't working, the AI hints at what might be wrong (missing range, misused function, off-by-one ranges).
- Saves time for novice users while still teaching how the formula works for next time.
How do I sum column A only if B is “Paid”?
Use SUMIF:
=SUMIF(B:B, “Paid”, A:A)
Reusable formula library
Reusable snippets library.
Stop reinventing the wheel. Save your most-used formulas as snippets and insert them with one click — and share the library with your team so everyone is using the same tested, approved versions.
- Create snippets from any formula and give them names for easy recall.
- Snippet search — quickly find a saved formula by typing keywords.
- Sync snippets across your devices via your Google account — your library goes where you go.
- Save snippets for both the formula editor and the formula builder.
Snippets
Library
New
- MRR CalculationTEAM
Calculates monthly revenue across all subscriptions…
2h ago Toom - Regex: Email ValidPRIVATEYesterday
- Sales Funnel CohortSHAREDUsed 14 times
For finance and data teams
Built for teams & enterprise.
Centralized billing, domain-based onboarding, and the support coverage your finance, data, and revenue teams expect.
Domain-Based Invites
Auto-add anyone on your work domain. Onboard a 30-person finance team in minutes, not days.
Shared Snippet Libraries
Curate an approved snippet library so your team uses tested, audited formulas — instead of someone's old XLOOKUP from a Slack thread.
Enterprise SSO
Sign-in via your identity provider (SAML or OIDC) on Enterprise, set up with your IT team during onboarding.
Priority Support & Onboarding
A named onboarding session for your team plus priority response times when something gets in the way of a deadline.
Talk to Sales
Average reply time: under 1 business day.
Free Excel add-in & Google Sheets add-on
Ready to forge
better formulas?
Install Formula Foundry in 30 seconds. Start free, no credit card.
Free plan — no credit card required.
Formula Foundry features FAQ
Frequently Asked Questions
- Yes — every feature on this page is available to try on our free plan. Install the add-on and you'll automatically have access. No credit card required. When you're ready for more, you can upgrade to one of our paid plans.
- Pro and Business plans can be billed monthly or annually. Monthly subscriptions can be canceled anytime. Annual plans get at least two months free. All payments are managed via our secure payment portal.
- Absolutely. Formula Foundry doesn't store your spreadsheet data — all computations happen inside your Google Sheets™ or Microsoft Excel™. We only store your name, email address, and snippets, which can be removed by request anytime. We comply with Google's security standards for Google Workspace™ add-ons.
- We're here for you. All users get access to our online documentation and contact forms. We also love feedback — many of our newest features came directly from user suggestions.