Not everyone is an Excel spreadsheet expert and you may not always know how to write the formula you need for a give data set . If you ’re having trouble figuring out the right formula for your information and computation need , there ’s a Modern option that can help you save up that recipe in just a few steps .
That option isChatGPT , the buzzy , new AI chatbotfrom unreal intelligence fellowship OpenAI . And among everything else ChatGPT can do , it can also write Excel formulas . In this guidebook , we ’ll show youhow to use Microsoft Exceland ChatGPT together . allow ’s get start .
How to use ChatGPT to write Excel formulas
Let ’s take a look at how to use ChatGPT to write Excel formulas . For the role of this usher , we ’ll use a dim-witted sample distribution datum set to do canonic calculations ( such assubtracting values ) with the formulas that ChatGPT give .
Do n’t forget : You ’ll need an OpenAI report and a Microsoft Excel spreadsheet with a data solidification .
Step 1 : Go ahead and get to the Excel spreadsheet you want to apply .
In our model , we have a simple mesa of products , service , projected prices , and their actual prices . Using Excel formula written by ChatGPT , we want to calculate the difference between the jut out price and actual price for each product or service listed ( Column D ) , and the subtotals of Columns B , C , and D.
gradation 2 : Now open your entanglement browser app and go tothe ChatGPT website . Then lumber into your OpenAI account . You should now see theNew chatscreen for ChatGPT .
Step 3 : On the novel Old World chat screen , case in your request for an Excel formula for your data in theSend a substance … school text corner at the bottom of the chat CRT screen . Then pressEnteron your keyboard .
In our good example , we want to satiate in the cells of the Differences chromatography column ( Column D ) with the answers from deduct the values of the Actual Price column ( Column C ) from their correspond value in the Projected Price column ( Column B ) .
So we ’ll set forth by ask ChatGPT to publish an Excel formula deduct the number in cadre C2 from the issue in B2 . You need to be thrifty in wording your request clearly and precisely as potential , otherwise , ChatGPT could misunderstand you and give you the wrong rule .
For our example we direct the undermentioned substance to ChatGPT : Please write an Excel formula subtracting the economic value in C2 from the note value in B2 .
Step 4 : ChatGPT ’s reply to your postulation should include a normal for you to use and a brief explanation of how to employ it in an Excel spreadsheet . Copy the formula from the confabulation screen by highlighting it and then press theCTRL + Ckeyboard shortcut .
Step 5 : Go to your Excel spreadsheet and choose the cell in which you want your recipe to be . Then paste your formula into the cell by pressingCTRL + Von your keyboard . The correct response to your formula should right away appear in the cell you selected .
In our illustration , ChatGPT render the follow formula for our request:=B2 - C2 . And once we copy and pasted that formula into our hope spreadsheet cellular phone ( D2 ) , the chemical formula give the correct reply : The difference between ware 1 ’s Projected Price ( B2 which equals $ 50 ) and its Actual Price ( C2 which equals $ 22 ) is $ 28 .
stair 6 : Then , to replete in the rest of the blank cells in the Differences column ( Column D ) with each product or service ’s right answers , you’re able to just brood your cursor over the low right corner of the cell in which you just re-create and pasted your normal . Then once you see the blackPlus signicon appear , take the recess and tangle your cursor to select the rest of the chromatography column until the last row of data point .
Then release your hold on the cursor . Once you do , those empty cells should then mechanically populate the right answers for their various rows of data .
gradation 7 : get ’s do one more example , this prison term with gain . Using the same spreadsheet example , we now desire to recognise the sum sum of all the values in Column B ( Projected Price ) .
So we ’ll go back to ChatGPT and commit the chatbot a postulation for an Excel chemical formula that adds up all of the values in pillar B , from B2 to B11 .
In this case , our message to ChatGPT was : Please write an Excel formula that tot up all the values in Column B , from B2 to B11 .
Step 8 : ChatGPT should answer with its rule and an account of how to use it . Then you should imitate and glue that formula into your desire spreadsheet cellphone as we did for the subtraction chemical formula originally in this templet .
Once you paste this increase formula , the correct answer should mechanically appear in that prison cell . For our example , ChatGPT provided this formula to add up all the cellphone in Column B , from B2 to B11:=SUM(B2 : B11 ) .
This rule right supply the result of $ 5,497 . This means the subtotal of the Projected Prices of the products and services list in this spreadsheet is $ 5,497 .
Step 9 : Lastly , since we want to fill up in the rest of the data set in this spreadsheet with the subtotal of columns C and D ( the actual prices and remainder of all the Cartesian product and services , respectively ) , we ’re give way to hover our pointer over the lower correct corner of the cellular telephone we just copy and paste our addition convention into .
Once the blackPlus signicon appears , we ’ll select this corner and then trail it over to the rightfield to select the next two cells . Once they ’re selected , let go your hold .
Once you release your delay , the correct subtotal answers should seem for their respective pillar of data .
While you canmake a graph with Exceland all manner of other datum analytic thinking tasks , give the alternative of streamlining formulas with ChatGPT can potentially change how you use the software .
you’re able to alsouse Microsoft Copilot with Exceland other applications in the Microsoft 365 suite .
