Netmend · Tools · Netmend 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!.
Uses your own free Gemini key. Your text goes from this browser to Google, never to a Netmend server.
Try:
XLOOKUP, INDEX/MATCH and FILTER with a clean fallback, written for your exact columns and your Excel version.
Semicolon separators and, with Pro, function names in Portuguese, Spanish, French, German, Italian or Dutch, ready to paste.
Paste the broken formula and the error. You get the fixed version and the reason in one sentence.
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.
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.
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.
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.
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.
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.