Figuring out how to write formulas to achieve the result you need can be a challenge, especially when you have a lot of data on a spreadsheet and need an intricate formula beyond calculating a sum. That is until ChatGPT arrived. Also: 5 ways to use ChatGPT to make your life easier ChatGPT and other AI chatbots can easily help you create Excel formulas for free and without signing up for a specialized website, like ExcelFormulaBot. The great thing about using AI like ChatGPT or Bing Chat to create formulas for Microsoft Excel (and Google Sheets) is that you can request formulas that are as simple or as complicated as you’d like – as long as you’re crystal clear in your instructions.
How ChatGPT can write Excel formulas
What you need: Using ChatGPT to write Excel formulas requires having access to Microsoft Excel or Google Sheets, as you can use formulas for both applications. You will also need an OpenAI account to access ChatGPT. Keep in mind that, as intelligent as AI chatbots are, they’re still not as well-versed in nuances as a person and can make errors or misinterpret prompts.
Why is the formula from ChatGPT not working?
If ChatGPT gave you a formula that isn’t working in Excel or Sheets, then it might’ve misunderstood your prompt. Go through the formula to see where the error could be on ChatGPT’s end and see how you can reword your prompt to get the answer you need. In the example below, my prompt was “Create a formula for the total cost that adds the values in columns F, G, and H”. Also: How to use ChatGPT to write code The spreadsheet below is the example we’re going to use: A made-up inventory of devices for January 2023. It has 45 products in column A, each with an SKU number (column B), amount in inventory (column C), quantity purchased in January (column D), price for each unit (column E), and the subtotal (column F, with a formula already). We’re going to use ChatGPT to create a few simple examples of formulas, including calculate sales tax (column G), seller’s commission (column H, not pictured), total (column I, not pictured), and the leftover quantity in inventory for the next month (column J, not pictured). Also: How to use the new Bing (and how it’s different from ChatGPT) It’s important that you be very clear, mind-numbingly so, as any errors ChatGPT makes as a result of a misunderstanding can lead to inaccurate values in your table. Channel your inner eleventh-grader asking your computer lab teacher how to create a specific formula. If we want ChatGPT to create the rest of the formulas, we have to explain it very plainly and specifically, so we’ll ask the AI chatbot to “write an Excel formula to calculate the sales tax of the monetary value in column F, at a 6% rate”. Also: How to create a drop-down list in Excel – quickly and easily In the example below, I corrected the formula to reflect the correct cell, F3, that needs to be included in the calculation of the sales tax. Also: How to add a drop down list in Google Sheets The same formatting will be followed, including the subsequent progression of the formulas. Since I didn’t specify I needed the formula to add the values in cells F3, G3, and H3, the formula adds the values in the entire column range, which is not what we need. I then corrected my prompt to request ChatGPT to “Create a formula for the total cost that adds the values in cells F3, G3, and H3”.
Can ChatGPT write intricate Excel formulas?
ChatGPT is the perfect resource to write formulas for Excel or Google Sheets, whether they’re simple or intricate. We used simple formulas for this example to walk you through the process, but you can ask the AI chatbot to write more complicated formulas and test its limits. Remember that the accuracy of ChatGPT’s results depends a lot on how clear your prompts are.
Can you use Bing Chat to write Excel formulas?
Other AI chatbots, like Bing Chat and Google Bard, are also able to create Excel formulas for you by following the steps above.
