Netmend

Netmend · Tools · Netmend Formula

Describe it in plain words, get the formula

Write what you want in English, Portuguese, Spanish or any language. Netmend Formula returns a formula that works in Excel, Google Sheets or LibreOffice, explains it step by step, and fixes formulas that throw #N/A, #VALUE! or #REF!.

5 free formulas a dayExcel · Google Sheets · LibreOfficeComma or semicolon separatorsPro $19 lifetime

Write a formula free

Get a formula now

Uses your own free Gemini key. Your text goes from this browser to Google, never to a Netmend server.

Try:

Good for

Lookups that never break

XLOOKUP, INDEX/MATCH and FILTER with a clean fallback, written for your exact columns and your Excel version.

European spreadsheets

Semicolon separators and, with Pro, function names in Portuguese, Spanish, French, German, Italian or Dutch, ready to paste.

Fixing #N/A, #VALUE!, #REF!

Paste the broken formula and the error. You get the fixed version and the reason in one sentence.

Netmend Formula Pro: $19 once

AI formula bots usually charge a monthly fee. Pro is one payment, and it runs on your own free Gemini key.

Pro is available now: $19 lifetime. Pay with the Gumroad button above; the licence key is in your Gumroad receipt — paste it here to unlock Pro. 14-day refund.

FAQ

Is it free?

Yes: 5 formulas, explanations or fixes a day in this browser, in English function names with comma or semicolon separators. You need a free Gemini key from Google AI Studio.

What does Pro add?

No daily limit; localized function names (SOMA.SE, SUMAR.SI, SOMME.SI, SUMMEWENN…); VBA macros, Google Apps Script, regex and SQL; and a saved history of your last 50 formulas in this browser. $19 once, 14-day refund.

Does my spreadsheet get uploaded?

No. You only type a description and, if you want, your column names. That text goes from your browser to Google's Gemini API with your key. Nothing goes to Netmend.

Can the AI be wrong?

Sometimes. Every answer comes with an explanation and a small worked example, so test it on a few rows before you fill a whole column.

How do I get a Pro licence?

Pro is available now: a $19 lifetime licence. Pay on Gumroad and paste the licence key from your receipt on this page. 14-day refund.

More Netmend tools