Excel Studio Updated October 2026

AI Excel formula generator that explains every formula

The Excel Studio Formula Assistant is an AI Excel formula generator: describe the calculation in plain English, paste your column headers if you like, and get the exact formula with an explanation, edge-case warnings and alternatives.

Start in Excel Studio See all capabilities

Formula

ready to paste into a cell

Steps

plain-English explanation

Edge cases

plus alternative formulas

Prompt example

Sum column D only where column C says "Approved" and column E is greater than 1000.

Describe the result

Say what the cell should calculate, in your own words.

Add context (optional)

Paste column headers or a few sample rows so the formula uses your real ranges.

Get four things back

The formula, a step-by-step explanation, edge-case warnings and alternative formulas.

In short

  • Describe what you want to calculate and the Formula Assistant returns a formula ready to paste into a cell.
  • Every answer includes a step-by-step explanation, edge-case warnings (for example, what happens when there is no match) and alternative formulas.
  • Pasting your column headers is optional, but it makes the cell references match your sheet.
  • Ask for anything from a simple IF to SUMIFS, XLOOKUP, INDEX/MATCH, date math and dynamic arrays such as UNIQUE and FILTER.
  • The Formula Assistant is part of Excel Studio, included with Pro ($20/month) and higher plans.
How it works

How to get a working formula on the first try

Any Excel formula generator is only as good as the request. These four habits remove most back-and-forth.

  1. 1

    Describe the result, not the function

    Write "the last purchase date for each customer", not "a MAXIFS". The assistant picks the function.

  2. 2

    Name the ranges and sheets

    Mention columns, header names and sheet names, for example "look up column B in the Orders sheet".

  3. 3

    Say which Excel you use

    Older versions lack XLOOKUP and UNIQUE. In many European locales, Excel separates arguments with semicolons instead of commas.

  4. 4

    Test the edge cases

    Check blanks, zeros and missing matches. The answer flags these, and you can ask for a safer variant.

Worked examples

Four plain-English requests and the formulas they produce

Illustrative examples based on requests from the Excel Studio documentation. A real answer also includes alternatives, and the ranges follow the headers you paste.

Example 1 SUMIFS Illustrative

Conditional total with two criteria

You type

"Sum column D only where column C says "Approved" and column E is greater than 1000."

Formula and explanation

  • SUMIFS adds the values in D for rows where every condition is true
  • C must equal "Approved"; the text match is not case-sensitive
  • E must be greater than 1000; the comparison operator goes inside the quotes
  • Edge case: if no rows match, the result is 0, not an error
=SUMIFS(D:D, C:C, "Approved", E:E, ">1000")

Alternative: =SUMPRODUCT((C2:C500="Approved")*(E2:E500>1000)*D2:D500) gives the same total and lets you add calculated conditions.

Example 2 MAXIFS Illustrative

Last purchase date per customer

You type

"Find the last purchase date for each customer in column A, looking up column B in the Orders sheet."

Formula and explanation

  • MAXIFS returns the largest, which means latest, date in Orders!B:B where Orders!A:A matches the customer in A2
  • Format the result cell as a date
  • Edge case: a customer with no orders returns 0, which Excel shows as a date in 1900; the second version returns a blank instead
=MAXIFS(Orders!B:B, Orders!A:A, A2) =IF(COUNTIF(Orders!A:A, A2)=0, "", MAXIFS(Orders!B:B, Orders!A:A, A2))

MAXIFS needs Excel 2019 or later. For older versions, ask for an alternative with MAX and IF.

Example 3 NETWORKDAYS Illustrative

Working days between two dates

You type

"Calculate the number of working days between the start date in A2 and the end date in B2, excluding weekends and the holidays in H2:H15."

Formula and explanation

  • NETWORKDAYS counts Monday-to-Friday days between two dates
  • Both the start date and the end date are included in the count
  • The optional third argument skips the holiday dates listed in H2:H15
=NETWORKDAYS(A2, B2, $H$2:$H$15)

Alternative: =NETWORKDAYS.INTL(A2, B2, 7, $H$2:$H$15) uses a Friday-Saturday weekend (weekend code 7).

Example 4 XLOOKUP Illustrative

Price lookup with a fallback

You type

"Look up the product code in A2 on the Products sheet and return the price from column C. Show "Not found" if the code is missing."

Formula and explanation

  • XLOOKUP searches Products!A:A for the code in A2 and returns the value from the same row in Products!C:C
  • The fourth argument shows "Not found" instead of the #N/A error
  • Exact match is the default, so no match-mode argument is needed
=XLOOKUP(A2, Products!A:A, Products!C:C, "Not found")

XLOOKUP needs Excel 2021, 2024 or Microsoft 365. For older versions: =IFERROR(INDEX(Products!C:C, MATCH(A2, Products!A:A, 0)), "Not found").

Formula reference

Eight everyday Excel formulas, explained

Use these as a starting point, or describe your own version to the Formula Assistant. Adjust the ranges to your sheet.

Weighted average

=SUMPRODUCT(B2:B100, C2:C100) / SUM(C2:C100)

Multiplies each value in B by its weight in C, adds the products, then divides by the total weight.

Works in: all current Excel versions

Running total

=SUM($B$2:B2)

The first reference is locked and the second moves as you fill down, so each row adds up everything above it.

Works in: all current Excel versions

Month-over-month growth without #DIV/0!

=IF(B2=0, "", (C2-B2)/B2)

Returns a blank when the previous month (B2) is zero. Format the cell as a percentage.

Works in: all current Excel versions

Flag overdue invoices

=IF(AND(D2<>"Paid", C2<>"", TODAY()-C2>30), "Overdue", "")

Marks invoices not marked Paid whose due date in C is more than 30 days ago. The C2<>"" check stops blank rows from showing as overdue.

Works in: all current Excel versions

Count unique values, ignoring blanks

=ROWS(UNIQUE(FILTER(A2:A500, A2:A500<>"")))

FILTER drops blanks, UNIQUE keeps one of each value and ROWS counts them. If the range is empty, wrap it in IFERROR(..., 0).

Works in: Excel 2021, 2024 and Microsoft 365

Rank sales, highest first

=RANK.EQ(B2, $B$2:$B$100, 0)

Order 0 ranks in descending order. Tied values share the same rank.

Works in: Excel 2010 and later

Two-way lookup (row and column)

=INDEX($B$2:$M$50, MATCH($P$2, $A$2:$A$50, 0), MATCH($Q$2, $B$1:$M$1, 0))

Finds the row of the item in P2 and the column of the month in Q2, then returns the value where they cross.

Works in: all current Excel versions

Text before the first comma

=LEFT(A2, FIND(",", A2) - 1)

Returns everything before the first comma, such as "Meier" from "Meier, Anna". FIND returns #VALUE! if the cell has no comma.

Works in: all current Excel versions

Formulas are written with commas between arguments. If your Excel uses semicolons, which is common in German, French and Swiss regional settings, replace the separating commas with semicolons.

Use Cases

What people use an Excel formula maker for

The Formula Assistant handles single formulas. When you need a whole workbook, the spreadsheet generator in the same studio builds it.

Conditional totals and counts

SUMIFS, COUNTIFS and AVERAGEIFS with several criteria, such as approved orders above a threshold.

Lookups across sheets

XLOOKUP or INDEX/MATCH with a clear fallback when the value is missing.

Dates and deadlines

Working days, due dates, overdue flags and month-end dates with EOMONTH.

Growth, margins and averages

Month-over-month growth, profit margin, weighted averages and rolling averages.

Text cleanup

Split names, extract codes and join columns with TEXTJOIN or the & operator.

Understanding inherited formulas

Paste a formula you did not write and ask what each part does and where it can break.

Files and limits

What the Formula Assistant gives you

What you typeA plain-English description of the calculation, plus optional column headers and sample rows as context.
What you getThe exact formula ready to paste, a step-by-step explanation, edge-case warnings and alternative formulas for the same result.
Where it livesThe Formula tab in Excel Studio, next to the spreadsheet generator and 27 instant tools that run without AI credits.
Excel versionsUse the formula in any Excel version that supports its functions. Say which version you have to get a compatible alternative.

Plan availability

The Formula Assistant is part of Excel Studio and needs Pro ($20/month) or Smart ($90/month, more Studio usage); team plans start at $25 per seat per month. It is not available during the 7-day trial. See plans

Try these prompts

More requests to try

Describe the outcome, name the columns, and mention what should happen with blanks or missing matches.

"Sum column D only where column C says "Approved" and column E is greater than 1000."
"Write a formula that flags invoices overdue by more than 30 days."
"Calculate month-over-month growth and avoid division-by-zero errors."
"Create a formula for a weighted average using values in B and weights in C."
FAQ

AI Excel formula generator FAQ

What is an AI Excel formula generator?+

A tool that turns a plain-English description of a calculation into an Excel formula. In MultipleChat it is the Formula Assistant tab in Excel Studio: describe the result you want, optionally paste your column headers, and get the formula with a step-by-step explanation, edge-case warnings and alternatives.

Which formulas can the Excel formula maker write?+

You can ask for any calculation, from a simple IF to conditional sums, nested lookups, date math and dynamic arrays. If a function is not available in your Excel version, say which version you use and ask for an alternative.

Does it work with XLOOKUP, SUMIFS and INDEX/MATCH?+

Yes. Describe the lookup or condition and the assistant picks a suitable function. XLOOKUP needs Excel 2021, Excel 2024 or Microsoft 365; INDEX/MATCH also works in older versions.

How do I make the formula match my spreadsheet?+

Paste your column headers and a few sample rows into the optional context field, and mention sheet names. The assistant then uses your real ranges instead of placeholders.

Why does Excel reject a formula that uses commas?+

Some regional settings use semicolons as the argument separator, which is common where the decimal separator is a comma. Replace the commas between arguments with semicolons, or tell the assistant your locale.

Can it explain a formula I already have?+

Yes. Paste the formula and ask what each part does and where it can break. The answer follows the same format: a step-by-step explanation, edge cases and alternatives.

Which plan includes the Formula Assistant?+

It is part of Excel Studio and needs Pro ($20/month) or Smart ($90/month, more Studio usage); team plans start at $25 per seat per month. It is not available during the 7-day trial.

Related Excel AI Pages

More ways to use Excel Studio

AI Excel generator

Open the focused guide

AI spreadsheet generator

Open the focused guide

AI CSV cleaner

Open the focused guide

Clean spreadsheets with AI

Open the focused guide

Create Excel dashboards with AI

Open the focused guide

Analyze CSV with AI

Open the focused guide

Excel AI for small business

Open the focused guide

Describe the calculation. Paste the formula.

Open the Formula tab in Excel Studio, add your column headers, and get a formula you can understand and trust.

Start in Excel Studio