How to Use ChatGPT for Excel Formula Writing: A Step-by-Step Guide

Do you sometimes find it challenging to create formulas in Microsoft Excel for your data tables? Let ChatGPT assist you by generating unique and original rephrased content.

Microsoft Excel is an exceptional tool for managing inventory in businesses or creating a budget for groceries at home. However, crafting formulas that deliver the precise results you need can be challenging, especially when dealing with vast amounts of data. But don’t worry, because ChatGPT is here to save the day!

ALSO ChatGPT: Build Your Resume with in 4 easy steps

With ChatGPT and other AI chatbots, creating Excel formulas has never been easier. You don’t have to sign up for a specialized website, like or ExcelFormulaBot, and the best part is, it’s entirely free! Whether you’re using Microsoft Excel or Google Sheets, you can request formulas of any complexity, and ChatGPT will deliver them flawlessly.

Just give clear instructions, and ChatGPT will do the rest, saving you time and effort. With the power of AI at your fingertips, you can now focus on the more crucial aspects of your business or personal life.

How ChatGPT Can Help You  Writing Excel Formulas

To use ChatGPT for writing Excel formulas, you will need access to either Microsoft Excel or Google Sheets. Also, an OpenAI account is necessary to access ChatGPT’s impressive capabilities.

But it’s essential to understand that despite the impressive power of AI chatbots like ChatGPT, they’re not perfect and can misinterpret prompts or make errors due to the lack of nuances. However, by providing clear and concise instructions, you can minimize the chance of any misunderstandings and ensure that ChatGPT delivers accurate and precise results every time.

ALSO ChatGPT: How To Write Cover Letters within 3 Easy Steps

So, if you’re tired of struggling with Excel formulas, let ChatGPT take the burden off your shoulders. It’s an excellent opportunity to leverage AI technology and simplify your work process. Get started today, and see how ChatGPT can help streamline your Excel formula creation process!

1.Excel Formula Creation: Open ChatGPT and Your Spreadsheet Together

Ready to streamline your Excel formula creation process? Follow these simple steps to use ChatGPT:

 Excel Formula
Excel sheet for inventory/FDM
  1. Open your Excel or Sheets spreadsheet and head over to to access ChatGPT. If you haven’t logged in yet, create an OpenAI account or sign in to continue.
  2. Once you’re logged in, ChatGPT will open up in a new conversation window. It’s time to start creating your formulas!
  3. Let’s take the example of a grocery store’s inventory for May 2023. The spreadsheet contains 100 different products in column A, with corresponding SKU numbers (column B), inventory amounts (column C), quantities purchased in April (column D), prices per unit (column E), and subtotal amounts (column F, calculated using a pre-existing formula).
  4. With ChatGPT’s assistance, you can easily create formulas to calculate the sales tax (column G) for each item, as well as the seller’s commission (column H, not shown), total amount (column I, not shown), and leftover inventory quantities for the next month (column J, not shown).

With ChatGPT, you can easily generate even complex formulas with ease, all while focusing on other critical aspects of your work.

2.Be clear with ChatGPT

you create an Excel formula that will calculate the sales tax of the monetary value in column F, at a rate of 8%. No need to worry about manual calculations or human errors anymore!

To get started, simply ask ChatGPT :


“write an Excel formula to calculate the sales tax of the monetary value in column F, at a 8% rate”.

 Excel Formula
Sales tax formula/FDM

Our cutting-edge technology will generate a formula that is both accurate and efficient, ensuring that your data analysis is top-notch.

With ChatGPT’s help, you’ll be able to streamline your workflow, save time, and impress your colleagues with your newfound Excel skills.

ALSO ChatGPT: How to Use This AI Chatbot to Write Code in 3 Easy Steps

3.How to Use Formulas in Excel: A Step-by-Step Guide

Simply copy and paste the formula provided by ChatGPT into the designated cell, and make any necessary edits to reflect the correct cell reference.

 Excel Formula
sales tax formula copy and paste/FDM

For example, let’s say you need to


calculate the sales tax for a monetary value in cell F3, using an 8% tax rate.” ChatGPT’s formula will automatically generate the correct result, ensuring that your data analysis is error-free.

ALSO How to Design Your App using ChatGPT: In Easy 3 Step-by-Step Guide

Don’t waste time on manual calculations – let ChatGPT handle the hard work for you! Our advanced AI technology will generate formulas that are tailored to your specific needs, ensuring that your data analysis is top-notch

4. Finish adding the remaining of your formulas

Simply request a formula to


calculate a 10% commission on the monetary total in the designated cell

and watch as ChatGPT generates an accurate and efficient formula.

 Excel Formula
Commision formula/FDM

For example, let’s say you need to calculate a 10% commission on the total monetary value in cell F3. ChatGPT’s formula will automatically generate the correct result, ensuring that your data analysis is seamless and error-free.

5.How to Complete the Table

Once you’ve added your commission formula, you can move on to the next two columns and effortlessly calculate the total and leftover inventory to complete your table

 Excel Formula
Total amount Excel formula/FDM


“Create the formula for the total cost that adds the column F3 , G3 and H3.”

6.Fill in the remaining cells of your worksheet.

It’s time to populate the rest of your spreadsheet with your brand new formulas, and it’s as easy as a click-and-drag!

 Excel Formula
Complete Excel sheet/FDM

Simply place your cursor on the lower right corner of the cell with the formula and drag your cursor over the rest of the cells you want the formula in. Watch as ChatGPT’s advanced AI technology automatically populates the cells with the correct formulas, ensuring that subsequent progressions are followed accurately.

ALSO How to use ChatGPT on WhatsApp using BuddyGPT,WizAI,Jinni AI,Shmooz AI


1.Is ChatGPT capable of creating complex Excel formulas?

writing formulas for Excel or Google Sheets has never been easier, no matter how simple or complex the task.

In this example, we’ve used simple formulas to guide you through the process, but ChatGPT’s advanced AI technology is capable of much more! Ask the AI chatbot to write more intricate formulas and test its limits. The accuracy of ChatGPT’s results depends heavily on how clear and concise your prompts are, so be sure to provide detailed and specific instructions to get the best results.

2.What is causing the ChatGPT formula to malfunction?

If you receive a formula that doesn’t seem to be working in Excel or Sheets, don’t give up just yet! Take a closer look at the formula to see where the issue could be on ChatGPT’s end, and try rewording your prompt to get the answer you need.

For instance, let’s say your initial prompt was to “Create a formula for the total cost that adds the values in columns F, G, and H”. If the resulting formula isn’t giving you the correct answer, double-check that the correct columns are being included and that the syntax is correct. You could also try rephrasing your prompt to make it more clear, such as “What formula can I use to calculate the total cost by adding the values in columns F, G, and H together?”

3.Is it possible to create Excel formulas with Bing Chat?

You can also use other AI chatbots, such as Bing Chat and Google Bard, to make Excel formulas by following the same steps as above.

Excel formula with Bing/FDM

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *