ChatGPT's Excel Formula Proficiency
Published:Jan 2, 2026 18:22
•1 min read
•r/OpenAI
Analysis
The article discusses the limitations of ChatGPT in generating correct Excel formulas, contrasting its failures with its proficiency in Python code generation. It highlights the user's frustration with ChatGPT's inability to provide a simple formula to remove leading zeros, even after multiple attempts. The user attributes this to a potential disparity in the training data, with more Python code available than Excel formulas.
Key Takeaways
- •ChatGPT struggles with basic Excel formula generation.
- •The issue may stem from a lack of sufficient Excel formula data in its training set compared to Python code.
- •Users are experiencing inconsistent performance between different coding tasks.
Reference
“The user's frustration is evident in their statement: "How is it possible that chatGPT still fails at simple Excel formulas, yet can produce thousands of lines of Python code without mistakes?"”