AI for Business
Excel & Google Sheets Formula Helper
Say what you want a cell to do — in words, with your column headers — and get the formula for Excel and for Google Sheets, an explanation of each part, the ways it can go wrong, and an alternative.
This is a cloud tool. Your description and the header cells you paste are sent to the model. Headers and one example row are enough; the data itself is not needed. Nothing is stored by us; the call is counted against your month’s allowance — 10 free, 300 on Pro. How the AI tools handle data.
Tips
- Paste the header row and a couple of real-looking rows. The formula then refers to your columns by letter, and the example field shows what it would return on those rows — a quick way to see whether it understood you.
- Say which Excel you have. XLOOKUP and FILTER do not exist in Excel 2016, and the older formulas that stand in for them are different enough to matter.
- If your Excel expects semicolons between arguments — common on European settings — pick that and every formula comes out that way.
- The pitfalls list is worth reading once per formula: dates stored as text and numbers stored as text are behind most "it returns 0" questions.
Frequently asked questions
Will the formula be correct?
Usually, for the ordinary cases — lookups, conditional sums and counts, date arithmetic, splitting and joining text. The model reasons about your description and cannot see your sheet, so the assumptions list says what it took for granted; check those against reality, and test anything that feeds a decision on a row where you know the answer.
Can it write a macro or an Apps Script?
Formulas are its job, and the answer is formula-shaped. For VBA or Apps Script a general assistant is the better tool.