In our example, ChatGPT generated the following formula for our request: =B2-C2. The correct answer to your formula should immediately appear in the cell you selected. Then paste your formula into the cell by pressing CTRL + V on your keyboard. Step 5: Go to your Excel spreadsheet and select the cell in which you want your formula to be. Copy the formula from the chat screen by highlighting it and then pressing CTRL + C on your keyboard. Step 4: ChatGPT's response to your request should include a formula for you to use and a brief explanation of how to use it in an Excel spreadsheet. You need to be careful in wording your request clearly and precisely as possible, otherwise, ChatGPT could misunderstand you and give you the wrong formula.įor our example we sent the following message to ChatGPT: Please write an Excel formula subtracting the value in C2 from the value in B2.

So we'll start by asking ChatGPT to write an Excel formula subtracting the number in cell C2 from the number in B2. In our example, we want to fill in the cells of the Differences column (Column D) with the answers from subtracting the values of the Actual Price column (Column C) from their corresponding values in the Projected Price column (Column B). text box at the bottom of the chat screen. Step 3: On the new chat screen, type in your request for an Excel formula for your data in the Send a message. Why pay for GPT-4? This AI tool gives it to you for free, plus moreĬhatGPT gets a private mode for secret AI chats.

Microsoft excel online free