Skip to content

AI formula generator

Ask for the calculation, not the syntax.

Describe the rule, source columns, target range, and edge cases. Griddy can write the formulas into Excel or Google Sheets so you can inspect the actual references instead of copying an answer from a chat window.

Try it in ExcelUse it in Google Sheets

Best for formulas with a clear business rule and known input columns. Review absolute references, error handling, and copied ranges before relying on the result.

Commission calculator in ExcelReal product demo
Griddy reads a sales table and fills a commission summary with formulas based on the rules in the prompt.

Concrete formula prompt

“Fill the commission table in columns G–L. Use SUMIF for total sales, COUNTIF for deal count, AVERAGE for average deal size, and IF statements for the tiered commission rate and final commission amount.”

The request names the output range, calculation for each column, and tiered rule. Griddy can use the existing headers and sales rows to place formulas in the summary table.

Expected output

  • SUMIF formulas that total sales for each rep from the source rows.
  • COUNTIF and AVERAGE formulas for deal count and average deal size.
  • An IF-based commission rate tied to the stated thresholds.
  • A final commission formula filled down for every rep in the summary.

For thresholds and exceptions, state the exact boundary behavior—for example, whether $10,000 belongs to the lower or higher tier.

Workflow

From request to workbook.

  1. 01

    Identify inputs

    Select the source table or name its sheet and columns. Confirm that headers are unique and that numbers and dates are stored in the expected data type.

  2. 02

    State the rule

    Describe the calculation in business terms, including conditions, thresholds, missing-value behavior, and whether references should remain fixed when formulas fill across or down.

  3. 03

    Name the destination

    Tell Griddy which column or range should receive the formula and what number format to apply. Protect source or note columns explicitly when needed.

  4. 04

    Audit a few rows

    Inspect the first, middle, and last formula, then test boundary cases such as blanks, zeros, dates at the cutoff, and values exactly on a threshold.

Formula work

From one-cell math to connected workbook logic.

Formula generation is distinct from general spreadsheet AI: success means the right expression is in the right cells, with references that continue to work when the sheet changes.

01

Lookups and joins

Build XLOOKUP, INDEX/MATCH, VLOOKUP, or conditional lookups across sheets while handling missing matches and duplicate keys.

02

Conditional totals and dates

Use SUMIFS, COUNTIFS, IF, IFERROR, date windows, and text rules for operating reports and exception lists.

03

Forecast and finance formulas

Connect assumption cells to revenue, margin, tax, cash, ratio, NPV, IRR, or CAGR calculations without hard-coding the output.

Learn more

Review before you rely

A formula can be valid and still be wrong.

Spreadsheet syntax is only half the job. The business rule, range boundaries, error behavior, and future copy behavior all need review.

  • Verify relative and absolute references before filling the formula through a table.
  • Test blanks, zero denominators, missing lookups, duplicate keys, and exact threshold values.
  • Check that full-column references or volatile functions are appropriate for the workbook size.
  • Keep assumptions in labeled cells so reviewers can see what drives the result.

Keep going

Related spreadsheet resources

PlatformAI for ExcelSee how Griddy edits formulas and other workbook objects in Excel.PlatformAI for Google SheetsUse the same prompt pattern from the Google Sheets sidebar.GuideHow to automate Excel with AICombine formula work with cleanup, pivots, charts, and formatting.TemplatesStart with named fieldsUse a structured pipeline, budget, or tracker to give formulas clearer context.

FAQ

Before you start.

Does Griddy put the formula into the spreadsheet?

Yes. Griddy can write formulas into supported Excel or Google Sheets ranges. You should still inspect the inserted expression, references, and filled range before using the result.

Can it write formulas across sheets?

Yes. Cross-sheet formulas are supported. Name the source and destination sheets, specify which ranges must remain untouched, and state whether values should stay formula-driven rather than being pasted.

How do I get a better formula result?

Include the source columns, target cells, business rule, edge cases, and expected format. If the rule has tiers or dates, spell out the exact boundaries.

Can it explain an existing formula?

Griddy can analyze workbook logic and explain formulas in context. For a repair, state the expected behavior and ask it to preserve cells that are already correct.

Put the rule in words.

Start with one formula range, verify the references, and build from there.

Excel PluginSheets Plugin