/cdn.vox-cdn.com/uploads/chorus_asset/file/23962442/acastro_STK067__03.jpg)
/cdn.vox-cdn.com/uploads/chorus_asset/file/24247717/lp_logo_3.0.jpg){kind=logo}
/cdn.vox-cdn.com/uploads/chorus_asset/file/24016885/STK093_Google_04.jpg)
/cdn.vox-cdn.com/uploads/chorus_asset/file/24808816/Starfield__The_Settled_Systems___Supra_Et_Ultra_____Starfield__The_Settled_Systems___Su)
[ad_1]
Figuring out how to write the right Excel formula to get a result can be a challenge, especially when you have a lot of data on a spreadsheet and need a complex formula beyond just calculating a sum. That is, till the arrival of ChatGPT.
How to use ChatGPT to write: Code | Curriculum Vitae | Essay | Cover Letter
ChatGPT and other AI chatbots can help you easily create formulas for your Excel spreadsheets for free and without signing up for any special websites, such as excelformulabot, The great thing about using artificial intelligence in 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 complex as you want — when As long as you’re very clear in your instructions.
How to Use ChatGPT to Write Your Excel Formulas
what you need: Using ChatGPT to write Excel formulas requires 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 still aren’t as nuanced as a person and can make mistakes or misinterpret prompts.
Open your Excel file or Sheets spreadsheet and go to chat.openai.com To access ChatGPT. If you aren’t logged in, this is the time to do so with your OpenAI account — you can also create an account at this point. After logging in, you will be taken to a chat with ChatGPT.
Too: How to use ChatGPT to write code
The spreadsheet below is the example we’re going to use: a constructed list of equipment for January 2023. There are 45 products in column A, one of each SKU number (Column B), Quantity in the list (column C), quantity purchased In January (Column D), worth for each unit (column E), and Use (Column F, already with a formula).
We are going to use ChatGPT to create some simple examples of formulas including calculations sales tax (column G), salesman’s commission (Column H, not pictured), Total (Column I, not pictured), and quantity left In inventory for the next month (column J, not pictured).
Now is the time to put forward the concept of what you want to achieve with ChatGPT and ask for the formula you want. To do this, you have to tell the AI chatbot exactly what you want the formula to do.
Too: How to save ChatGPT conversations for later viewing
It is important that you are very clear, not mind numbing, as any error made by ChatGPT as a result of misunderstanding can lead to incorrect 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 generate the rest of the formula, we need to explain it very clearly and specifically, so we ask the AI chatbot to “Write an excel formula to calculate sales tax of the monetary value in column F”. Will say.” a 6% rate”.
I didn’t specify which row we wanted the formula to start with in column F, so ChatGPT defaulted to F2. Screenshot by Maria Diaz/ZDNet
Copy the formula from ChatGPT and paste it into the Excel cell you want to populate with the results, making any necessary edits. To the best of your ability, verify that the results are correct before populating the rest of your cells.
Too: 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 sales tax calculation.
You can see ChatGPT’s formula highlighted on the left, with the result in the cell on the right. Screenshot by Maria Diaz/ZDNet
I’ll end up adding the formulas I need to my spreadsheet, starting with the commission calculation, by telling ChatGPT to “Create a formula to calculate the 10% commission on the monetary total in cell F3.”
Once I’ve added my commission formula, I can move on to the next two columns to calculate the total and remaining inventory to complete the table.
Now it’s time to fill the rest of your spreadsheet with your shiny new formulas. To do this, position your cursor at the bottom right corner of the cell with the formula and click and drag your cursor to the remaining cells that you want the formula in.
Too: ChatGPT and new AI are wreaking havoc on cyber security in new and sinister ways
Same formatting will be followed including subsequent progression of formulas.
Once you’ve added the formula to the rest of the columns, the spreadsheet is complete. Screenshot by Maria Diaz/ZDNet
questions to ask
Is there any way to use AI for formulas in Excel?
Ideally, you’ll be able to generate formulas easily within Microsoft Excel with ChatGPT, an AI tool already built into the program. At this time, it isn’t, but Microsoft is rolling out Copilot, a set of AI tools for the Microsoft 365 suite of programs. Although Microsoft Copilot is not yet widely available, new features to be expected include GPT-4-integrated Microsoft Excel.
Why is ChatGPT’s formula not working?
If ChatGPT gave you a formula that isn’t working in Excel or Sheets, it may have misunderstood your prompt. Look at the formula to see where the error may be on ChatGPT’s side and see how you can change your prompt to get the correct answer. In the example below, my prompt was “Create a formula for total cost that adds the values in columns F, G, and H”.
Since I didn’t specify that I needed the formula to add the values in cells F3, G3, and H3, the formula adds the values across the entire column range, which we don’t 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 complex Excel formulas?
ChatGPT is the perfect resource for writing formulas for Excel or Google Sheets, whether they are simple or complex. For this example we used simple formulas to guide you through the process, but you can ask the AI chatbot to write more complex formulas and test its limits. Remember that the accuracy of ChatGPT results depends a lot on how clear your signals are.
Can you use Bing Chat to write Excel formulas?
Other AI chatbots like Bing Chat and Google Bard are also capable of generating Excel formulas for you by following the above steps.
How Bing Chat and Google Bard responded to the same prompt I gave ChatGPT to write a formula to calculate sales tax. Screenshot by Maria Diaz/ZDNet
