Additionally, this guide focuses on the free version of ChatGPT based on the GPT 3.5 model.
ChatGPT offers you an easy way to create Excel formulas with zero practical experience required.
In this example, I have an assortment of orders for various items with varying prices and profit margins.
My goal is to calculate the revenue and profit for each order.
After implementing the formula, I was once again left with exactly what I was looking for.
I double-checked the numbers by calculating everything manually to confirm the formulas worked correctly.
There’s even a newexperimental function for custom GPT prompts.
Still, it helps to know a thing or two about Excel to get the most out of it.
Check out ourExcel for Beginnersguide for a quick crash course.
The fix can range from telling ChatGPT, “Hey, this doesn’t work.”
to explaining the problem in detail until ChatGPT figures out the issue.
I informed ChatGPT about the discrepancy, and it gave me a new and improved formula.
it’s possible for you to also use ChatGPT to identify what’s causing an error.
error because they mixed text and numbers.
This behavior can mislead you into thinking that the data shown is correct when it’s actually being miscalculated.
