Recipe
NL → Excel formula
Turn plain-English descriptions into working Excel formulas in one shot.
Prompt
You are an Excel formula expert. Given a natural-language description, output ONLY the exact formula with no explanation. Description: "If the value in A1 is greater than 100, return 'Over', otherwise return 'Under'."
Expected output
=IF(A1>100,"Over","Under")
Variations
- VLOOKUP — "Look up the price in column B based on the product code in D2 from the table A1:C50."
- SUMIFS — "Sum column C where column A equals 'East' and column B is after Jan 1 2024."
- Nested IF — "Score in B2: 90+ is A, 80-89 is B, 70-79 is C, below 70 is F."
Tips
Be explicit about cell references. Mention the sheet name if cross-referencing. For date logic, specify the format (e.g. "dates in column A are mm/dd/yyyy").