Tech & Auto
How To Use ChatGPT For Writing Excel Formulas
By MARINEL SIGUE
Writing Excel formulas can be a drag and if you’re still figuring out how to get it done, you can get AI-powered assistance via ChatGPT.
Once you have created a ChatGPT account on chat.openai.com, open an Excel file and determine the formulas you need for your sheet.
In our example, we want to get the total number of items sold, the Total Sales for each item, the Grand Total Sales, and the Quota Classification.
The Quota Classification is simply an indication (“Pass” or “Fail”) of whether the quantities sold for each item met the quota specified in column E.
Click “New chat” in the upper left corner of the page and in the “Send a message” field, type your request. Mention what you want the formula to do and name the cells.
Here's our request for the sample sheet's Quota Classification formula. Then copy and paste it to your Excel sheet and repeat the last two steps until you have all your formulas.