Excel Formula Translator

What Problem It Solves

Excel users often get stuck in two places: they know the desired result but do not know whether to use COUNTIF, SUMIFS, or XLOOKUP; or they receive a formula from an AI and it breaks because of version differences, Chinese/English function names, locale settings, or edge-case data. This skill targets that gap by turning plain-language requirements into executable formulas.

Core Capabilities and Steps

• Translate: convert natural-language requests into Excel or WPS formulas, preferring functions compatible with the stated version.
• Explain: describe each parameter and why a particular reference style, condition range, or error-handling approach is used.
• Avoid common traps: cover VLOOKUP exact matching, text-formatted numbers, date serial values, SUMIFS range alignment, blanks, and error values.

During use, it first checks the Excel version, data shape, expected output, and whether the formula needs to be filled down a column. Then it selects formulas: prefer XLOOKUP, FILTER, and TEXTSPLIT when supported; otherwise fall back to more stable functions. For multi-condition calculations, prefer SUMIFS / COUNTIFS over harder-to-maintain array formulas. Finally, it outputs the formula, explanation, boundary handling, and absolute-reference notes.

Boundaries

This skill focuses only on formulas. It does not proactively write VBA macros, Power Query, or pivot-table design. If the user needs those, they should request them explicitly.