ChatGPT's Excel Formula Proficiency
AI Performance#LLM Capabilities🏛️ Official|Analyzed: Jan 3, 2026 06:33•
Published: Jan 2, 2026 18:22
•1 min read
•r/OpenAIAnalysis
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 / Citation
View Original"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?""